Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Chapter 17

memorize.ai (lvl 286)

(0)

16 cards

()

Section 1

Preview this deck

Relay Log

Front

1 / 16

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (16)

Section 1

(16 cards)

Relay Log

Front

What is when one or more binary files that are used on a slave machine to relay any changes that have been made on the master machine?

Back

Mysqld Program, MySQL DAEMON

Front

When you start the configuration file this specifies that the following system variables apply to What?

Back

Status Variable

Front

What contains information about the status of MYSQL server?

Back

Data File

Front

Which files define the tables, indexes and other database objects?

Back

Database Replication

Front

What involves setting up two or more MySQL servers, usually running on different machines, where one server is the master and the other is slave?

Back

Log File

Front

Which files contain information that is written by a database server?

Back

Slave

Front

Who does the work on a server?

Back

Process

Front

What is a connection to the database?

Back

Binary Log

Front

When one or more binary files that contain a record of changes that have been made to the database. What type of log can be used with backups to restore, and also enable replications?

Back

General Log

Front

What is a text file that contains a record of client connections, sql statements received from the clients, and other information?

Back

Error Log

Front

What text file contains messages about server startup and shutdown and error messages?

Back

System Variable

Front

What stores a setting for the current configuration of the mysql server?

Back

Slow Query Log

Front

What text file contains SQL statements that take a long time to execute?

Back

Database Administrator(DBA)

Front

Who has many responsibilities that vary depending on the database?

Back

Configuration File

Front

Which files contain options that the mysql server uses to set defaults?

Back

Master

Front

Who runs the server?

Back