PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html
The size of the table slows down the insertion of indexes by log N, assuming B-tree indexes. If you are adding data to a nonempty table, you can tune the bulk_insert_buffer_size variable to make data insertion even faster. When loading a table from ... To optimize insert speed, combine many small operations into a single large ...
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/linux-installation-rpm.html
For Red Hat Enterprise Linux/Oracle Linux/CentOS systems: $> sudo yum install mysql-community-{client,common,libs}-* mysql-5.* A standard installation of MySQL using the RPM packages result in files and resources created under the system ... The ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. The following examples use HEX() to display the INET6_ATON() result in printable form: mysql> SELECT ...The function ...
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-limitations-multiple-nodes.html
Stored procedures, stored functions, triggers, and scheduled events are all supported by tables using the NDB storage engine, but these do not propagate automatically between MySQL Servers acting as Cluster SQL nodes, and must be re-created ...The ...
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 ...