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/innodb-buffer-pool-resize.html
Note To avoid potential performance issues, the number of chunks (innodb_buffer_pool_size / innodb_buffer_pool_chunk_size) should not exceed 1000. | +----------------------------------+----------------------------------+ Buffer pool resizing ... You ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
With --force, mysqldump prints the error message, but it also writes an SQL comment containing the view definition to the dump output and continues executing. The option value is a list of comma-separated error numbers specifying the errors to ...It ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
If cas_column and expire_time_column fields of the innodb_memcached.containers table are set to NULL, the following error is returned when attempting to load the memcached plugin: InnoDB_Memcached: column 6 in the entry for config table 'containers' ...If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. If the slow query log is enabled and FILE is selected as an output destination, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
When XA COMMIT or XA ROLLBACK is issued, a second part of the transaction containing only the XA COMMIT or XA ROLLBACK statement is written using a second GTID. If there is an unexpected halt while the server is in the middle of executing an XA ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-performance.html
If the LOCK clause specifies a less restrictive level of locking than is permitted for a particular DDL operation, the statement fails with an error. Use this clause if the primary concern is finishing the DDL operation in the shortest amount of ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
YEAR(2) column definitions for new tables produce warnings or errors: Before MySQL 5.7.5, YEAR(2) column definitions for new tables are converted (with an ER_INVALID_YEAR_COLUMN_LENGTH warning) to 4-digit YEAR columns: mysql> CREATE TABLE t1 (y ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
For multithreaded replica operation, SHOW SLAVE STATUS reports all coordinator and worker thread errors using the Last_SQL_Errno and Last_SQL_Error fields, so only the most recent of those errors is visible and information can be lost. The ...This ...