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/common-errors.html
This section lists some errors that users frequently encounter when running MySQL programs. Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
If you omit the --console option, the server writes diagnostic output to the error log in the data directory (C:\Program Files\MySQL\MySQL Server 5.7\data by default). The error log is the file with the .err extension, and may be set using the ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-status-variables.html
Mysqlx_sessions_fatal_error The number of sessions that have closed with a fatal error. Mysqlx_errors_unknown_message_type The number of unknown message types that have been received. Mysqlx_stmt_execute_mysqlx The number of StmtExecute messages ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
If the option is given without a value, the timeout is set to 300 seconds. To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify this maximum by using an option of the form ...However, in most ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the total length of all columns cannot exceed this size. If a row containing variable-length columns ...
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/timestamp-lookups.html
This phenomenon can lead to different results for a given TIMESTAMP column query, depending on whether the optimizer uses an index to execute the query. Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
Prior to MySQL 5.7.8, the Status field displays several values if WITH_DEBUG was defined at MySQL compilation time. Pre-MySQL 5.7.8 Status field values include: count indicates how many times the mutex was requested. os_yields indicates the number ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
The thread pool tries to ensure a maximum of one thread executing in each group at any time, but sometimes permits more threads to execute temporarily for best performance: Each thread group has a listener thread that listens for incoming statements ...thread_pool_prio_kickup_timer: How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
mysqlx_connect_timeout: Maximum permitted waiting time in seconds for a connection to set up a session. binlog_transaction_dependency_tracking: Source of dependency information (commit timestamps or transaction write sets) from which to assess which ... Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL ...