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/mysqldump.html
It is always enabled and attempting to disable it (--skip-secure-auth, --secure-auth=0) produces an error. NULL, 'NULL', and Empty Values: For a column named column_name, the NULL value, an empty string, and the string value 'NULL' are distinguished ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column values. The B-tree data structure lets the index quickly ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
Attempting to run innochecksum on a tablespace that the server already has open results in an Unable to lock file error. This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-resize.html
You can configure InnoDB buffer pool size offline or while the server is running. For additional information about configuring buffer pool size online, see Configuring InnoDB Buffer Pool Size Online. When increasing or decreasing ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. Assuming that the Performance Schema is available, it is enabled by default. To enable or disable it explicitly, start the server with ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
This section describes aspects of how the MySQL server manages client connections. Network Interfaces and Connection Manager Threads Client Connection Thread Management Connection Volume Management Network Interfaces and Connection Manager Threads ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. The idea of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuring-io-capacity.html
The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary indexes.