PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the plugin. INSTALL PLUGIN also registers the plugin by adding a line that indicates the plugin name and library file name to the ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-innodb-mutex-waits-performance-schema.html
Wait event data collected in Performance Schema tables can help identify mutexes with the most waits or the greatest total wait time, for example. To view available InnoDB mutex wait instruments, query the Performance Schema setup_instruments table, ... A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-concepts.html
The data actually stored in the database tables at the time that the backup was made Transaction log. Each node saves the same table definitions (for all tables in the cluster) to its own version of this file. BACKUP-backup_id-0.node_id.data A data ... A backup is a snapshot of the database at a given ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
A unique index read operation generates 2 primary key read operations—1 for the hidden unique index table, and 1 for the table on which the read takes place. Note A unique index update operation can generate multiple PK read and write operations ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-quick.html
row *************************** Engine: NDBCLUSTER Support: YES Comment: Clustered, fault-tolerant, memory-based tables *************************** 13. Try to create an NDBCLUSTER table: $> mysql mysql> USE test; Database changed mysql> CREATE TABLE ... To familiarize you with the basics, we describe the simplest possible configuration for a functional NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
mysql_install_db handles initialization tasks that must be performed before the MySQL server, mysqld, is ready to use: It initializes the MySQL data directory and creates the system tables that it contains. It initializes the system tablespace and ... Note mysql_install_db is deprecated as of MySQL 5.7.6 because its functionality has been integrated into mysqld, the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Alternatively, create a shortcut that only sets the console font, and set the character set in the [mysql] group of your my.ini file: [mysql] default-character-set=utf8 Displaying Query Results Vertically Some query results are much more readable ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. Pluggable authentication makes it possible for clients to ...The server then authenticates the client, determining from the account row which authentication plugin applies to the client: If the server cannot find the plugin, an error occurs and the connection attempt is ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
As an example, suppose that around 13:00:00 on May 27, 2020, an SQL statement was executed that deleted a table. You can perform a point-in-time recovery to restore the server up to its state right before the table deletion. In our example, given ...