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/batch-mode.html
If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Batch mode can also be useful while you are developing a query, particularly for multiple-line statements or ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
Enable the stage/innodb/alter% instruments: mysql> UPDATE performance_schema.setup_instruments SET ENABLED = 'YES' WHERE NAME LIKE 'stage/innodb/alter%'; Query OK, 7 rows affected (0.00 sec) Rows matched: 7 Changed: 7 Warnings: 0 Enable the stage ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
This makes MySQL very convenient for Web applications where you obtain year, month, and day in three different fields and you want to store exactly what the user inserted (without date validation). You should use this format in UPDATE expressions ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-and-mysql-replication.html
For information about setting up a replica, see Section 16.1.2.5, “Setting Up Replicas”, and Section 16.1.2.4, “Choosing a Method for Data Snapshots”. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM ... It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html
Because the effects of these parameters can vary widely based on your hardware configuration, your data, and the details of your workload, always benchmark to verify the effectiveness before changing these settings in any performance-critical or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
Module names can be used to enable, disable, or reset all counters for a particular subsystem. mysql> SET GLOBAL innodb_monitor_reset = dml_inserts; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/5.7/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password plugin. Note There are easier ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
This can be done by setting an appropriate value in the config.ini file for the MaxNoOfExecutionThreads configuration parameter or the ThreadConfig configuration parameter. ndbmtd is intended for use on host computers having multiple CPU cores. For ... ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
(Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default explicit.) When the Performance Schema checks for a match in setup_objects, it ...