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/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/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 11.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/doc/refman/5.7/en/repeat.html
[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 expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O optimizations. If the Unix top tool or the Windows Task Manager shows ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, see Section 16.1.3, “Replication with Global Transaction Identifiers”.
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Increase the value of the innodb_buffer_pool_size configuration option, which performs ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them available. After a plugin has been installed, you control it by means of the system variables associated with it. These system ...
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 ...