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/thread-pool-elements.html
To identify them, use this query: SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%thread_pool%'; For more information, see Chapter 25, MySQL Performance Schema. MySQL Enterprise Thread Pool comprises these elements: A plugin ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
CEILING(3.7004397181411) is 4, and V = POWER(2,4), which is 16.) Set N = F(column_list) & (V - 1). MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas ...
https://dev.mysql.com/doc/refman/5.7/en/repeat.html
For the rules regarding label use, see Section 13.6.2, “Statement Labels”. [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
If you already created some InnoDB tables, also delete the corresponding .frm files for these tables, and any .ibd files if you are using multiple tablespaces, from the MySQL database directories. The troubleshooting steps for InnoDB I/O problems ...Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all ib_logfile ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-exclusive-to-cluster.html
For example, you cannot have a management node running on a PowerPC which directs a data node that is running on an x86 machine. NDB Cluster has the following limitations or restrictions with regard to binary logging: NDB Cluster cannot produce a ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-installation.html
Run the chosen script as follows: $> mysql -u root -p < install_rewriter.sql Enter password: (enter root password here) The example here uses the install_rewriter.sql installation script. To verify that, connect to the server and execute this ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
(This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data --routines --events > dump-defs.sql On the upgraded server: $> mysql < dump-defs.sql Because the dump file does not contain table data, it ...Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. The function library base name is openssl_udf and the suffix is platform dependent. For example, the file name on Linux or ... MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory (the directory named by the plugin_dir system ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-troubleshooting.html
You should check that there is enough memory allocated for the backup. Important If you have set BackupDataBufferSize and BackupLogBufferSize and their sum is greater than 4MB, then you must also set BackupMemory as well. This is due to the fact ...
https://dev.mysql.com/doc/refman/5.7/en/primary-key-optimization.html
The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance benefits from the NOT NULL optimization, because it cannot include any NULL values. If your table is big and important, ...With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column or ...