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/show-errors.html
In particular, SHOW ERRORS cannot display information for more than max_error_count messages, and error_count can exceed the value of max_error_count if the number of errors exceeds max_error_count. SHOW ERRORS [LIMIT [offset,] row_count] SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
ALGORITHM=INPLACE, REORGANIZE PARTITION is not needed (and causes an error if executed). To upgrade a KEY partitioned table that was created in MySQL 5.1, first execute SHOW CREATE TABLE and note the exact columns and number of partitions shown. Now ... Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
The next time the old client attempts to connect to the account, it cannot, because the account has a long password hash that requires the 4.1 hashing method during authentication. Note The information in this section applies fully only before ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html
By default, source and replica servers assume that they are in the same time zone. If you are replicating between servers in different time zones, the time zone must be set on both source and replica. Otherwise, statements depending on the local ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
MaxNoOfConcurrentTransactions: Maximum number of transactions executing concurrently on this data node, total number of transactions that can be executed concurrently is this value times number of data nodes in cluster. TransactionInactiveTimeout: ...LcpScanProgressTimeout: Maximum time that local checkpoint fragment scan can be stalled before node is shut down to ensure systemwide LCP ... The listings in this section ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The SUM_CONNECT_ERRORS value can exceed the max_connect_errors value because multiple connection attempts from a host can occur simultaneously while the host is not blocked. COUNT_HOST_BLOCKED_ERRORS The number of connections that were blocked ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
Error Message Sources Error Message Elements Error Message Sources Error messages can originate on the server side or the client side: On the server side, error messages may occur during the startup and shutdown processes, as a result of issues that ... This section discusses how error messages originate within MySQL and the elements they ...
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/mysql-tzinfo-to-sql.html
The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name: mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql If your time zone needs to account for leap seconds, invoke ... The mysql_tzinfo_to_sql program loads the time zone tables in the mysql ...One likely location for these ...
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 ...