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/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/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/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/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/replication-rules.html
On the source, you can control which databases to log changes for by using the --binlog-do-db and --binlog-ignore-db options to control binary logging. For a description of the rules that servers use in evaluating these options, see Section ...You ... If a replication source server does not write a statement to its binary log, the statement is not ...
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/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
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 ...