connects to the master and requests it to send updates recorded in its binary logs

monitors and schedules I/O calls to the subsystem for the relay logs

acquires a lock on the binary log for reading each event to be sent to the slave

reads the relay log and executes the events contained in them

The root user had the largest number of modified rows for a SELECT statement.

User bob had the largest total time waiting for locks.

The root user had the largest single wait time.

The app user had the highest total number of rows read from storage engines.

User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

redo tablespaces

encryption tablespaces

schema tablespaces

data tablespaces

undo tablespaces

temporary table tablespaces

The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.

It is possible to filter a Query Analyzer view graph by database and by table.

The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager ' s built-in Agent installation.

It is possible to export statements included in a graph selection in CSV format.

They are backups taken from snapshots of a running database.

They are backups taken from OS copy commands.

They are good to use if only data structures must be backed up but not log files.

They are good to use when many users are online accessing the database.

installing and configuring the Connection Control plugin

avoiding concatenation of SQL statements and user-supplied values in an application

using stored procedures for any database access

using PREPARED STATEMENTS

ALTER USER baduser@hostname PASSWORD DISABLED;

ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

ALTER USER baduser@hostname ACCOUNT LOCK;

ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

ALTER USER baduser@hostname DEFAULT ROLE NONE;

You can scale writes by creating a replicated mesh.

It guarantees near real-time replication between a master and a slave.

You can scale reads by adding multiple slaves.

MySQL Enterprise Backup will automatically back up from an available slave.

It allows backup to be done on the slave without impacting the master.

It supports backing up only table structures.

It can perform hot or warm backups.

It creates logical backups.

It supports the creation of incremental backups.

It supports backup of a remote MySQL system.

It supports restoring to a remote MySQL system.

The account used to perform this recovery needs the BACKUP_ADMIN privilege.

A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

InnoDB tablespaces outside the datadir are able to be cloned.

It is always slower than {recoveryMethod: ‘incremental’}.

A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.