Statement-based logging. Tells the server to not log any statement where the default database (that is, the one selected by USE) is db_name. Prior to MySQL 5.6.12, this option caused any statements containing fully qualified table names not to be logged if there was no default database specified ...
Taking Advantage of System Memory For best performance, deploy the InnoDB memcached plugin on machines that are configured like typical database servers: in particular, with the majority of system RAM devoted to the
Maximum of Column per Group Task: Find the highest price per article. SELECT article, MAX(price) AS price FROM shop GROUP BY article; +++ | article | price | +++ | 0001 | 3.99 | | 0002 | 10.99 | | 0003 | 1.69 | | 0004 | 19.95 | +++ ...
Unplugging a Storage Engine To unplug a storage engine, use the UNINSTALL PLUGIN statement: mysql UNINSTALL PLUGIN example; If you unplug a storage engine that is needed by existing tables, those tables become inaccessible, but will still be present on disk (where applicable). Ensure that there ...
Latency and binary log size. Because RBL writes changes for each row to the binary log, its size can increase quite rapidly. In a replication environment, this can significantly increase the time required to make changes on the slave that mat...
Partition. This is a portion of the data stored by the cluster. There are as many cluster partitions as nodes participating in the cluster. Each node is responsible for keeping at least one copy of any partitions assigned to it (that is, at lea...
Replication of the mysql System Database Data modification statements made to tables in the mysql database are replicated according to the value of binlog_format [2047]; if this value is MIXED, these statements are replicated using rowbased format. However, statements that would normally update t...
Setting the Master Configuration on the Slave To set up the slave to communicate with the master for replication, you must tell the slave the necessary connection information. To do this, execute the following statement on the slave, replacing the option values with the actual values relevant to ...
SSH. A secure shell connection is used to enable the back end to perform actions on remote hosts. For this reason, an SSH server must be running on the remote host. In addition, the system user running the installer must have access to the remote server, either with a user name and password, or b...
Stage Instrument Components Stage instruments have names of the form stage/code_area/stage_name, where code_area is a value such as sql or myisam, and stage_name indicates the stage of statement processing, such as Sorting result or Sending data. Stages correspond to the thread states displayed b...
