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/replication-options.html
Command-Line Format --server-id=# System Variable server_id Scope Global Dynamic Yes Type Integer Default Value 0 Minimum Value 0 Maximum Value 4294967295 This variable specifies the server ID. Once START SLAVE has been executed, the value of the ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
In this scenario, replication fails with a duplicate entry error on the primary key column. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the BLACKHOLE ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
Note Do not enable the WITH_TEST_TRACE_PLUGIN option if you want to use your own protocol trace plugins because only one such plugin can be loaded at a time and an error occurs for attempts to load a second one. Many options configure compile-time ... The CMake program provides a great deal of control over how you configure a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal structure and caches that structure to be used during execution. If the server does not detect this change the next ...To avoid problems caused by metadata changes to tables or views referred to by the prepared statement, the server detects these changes and automatically reprepares the statement when it is next ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
On Unix, the mysql client writes a record of executed statements to a history file (see Section 4.5.1.3, “mysql Client Logging”). MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
After using this value, be prepared to drop and recreate all secondary indexes. To investigate database page corruption, you might dump your tables from the database with SELECT ... Usually, most of the data obtained in this way is intact. Serious ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-startup-configuration.html
It is possible that a plugin installed later may create the instrument, at which time the name is recognized and configured. At runtime, SHOW VARIABLES displays the actual values that autosized parameters were set to. To use the MySQL Performance ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
The column is also indexed and the optimizer can take that index into account during execution plan construction. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-full-table-scans.html
By default, rows are sorted by descending percentage of time a full scan was done and descending total latency. total_latency The total wait time of timed statement events for the statement. no_index_used_count The total number of times no index was ... These views display normalized statements that have done full table ...