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/partitioning-limitations.html
If, when creating tables with a large number of partitions (but less than the maximum), you encounter an error message such as Got error ... Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were ... This section discusses current restrictions and limitations on MySQL partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
Per second averages provided in InnoDB Standard Monitor output are based on the elapsed time since InnoDB Standard Monitor output was last printed. youngs/s The per second average of accesses to old pages in the buffer pool LRU list that have ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
In particular, any MAX value in the innodb_data_file_path option is a hard limit, and exceeding that limit causes a fatal error. Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the ...Make sure the disk is not full and you are not exceeding any disk ... The troubleshooting steps for InnoDB I/O problems depend on when the problem occurs: during startup of the MySQL server, or during normal operations ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-language.html
For example, if the server is using the fr_FR locale for error messages, a client can execute this statement to receive error messages in English: SET lc_messages = 'en_US'; . By default, mysqld produces error messages in English, but they can be ...By default, the language files are located in the share/mysql/LANGUAGE directory under the MySQL base ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the character set), see Section 10.12, “Setting the Error Message Language”. For ...Character (nonbinary) string values are converted from their character set to ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Innodb_row_lock_time_max The maximum time to acquire a row lock for InnoDB tables, in milliseconds. Max_execution_time_exceeded The number of SELECT statements for which the execution timeout was exceeded. Com_xxx The Com_xxx statement counter ...| ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
On the right side of the IN() predicate, row constructors contain only runtime constants, which are either literals or local column references that are bound to constants during execution. The interval on the second line uses only one key part. The ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-tc-time-track-stats.html
This is the number of times that this activity occurred with a latency within the range specified by the row (that is, where the latency does not exceed the upper bound). key_op_errors Based on duration of all unsuccessful key read or write ... The ...A set of counters is maintained for each activity, each counter covering a range of latencies less than or equal to an upper ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-error-handling.html
InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction. If you run out of file space in a tablespace, a MySQL Table is full error occurs and InnoDB rolls back the SQL statement. A lock wait ...A ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-format.html
The log_timestamps system variable controls the time zone of timestamps in messages written to the error log (as well as to general query log and slow query log files). The ID included in error log messages is that of the thread within mysqld ...