PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-connections-table.html
TIME_OF_EXPIRY Timestamp showing when an idle connection will expire if no new request arrives before then; this is NULL when the thread is currently processing a request. TIME_OF_ADD Timestamp showing when the connection was added to the thread ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-group-state-table.html
PRIO_KICKUP_TIMER The value of the thread_pool_prio_kickup_timer system variable for the thread group. TIME_OF_LAST_THREAD_CREATION The point in time when the thread was last created. QUERY_THREADS_COUNT same as num_query_threads, but used for ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-info-table.html
SET_TIME The time at which the variable was most recently set. The default is the time at which the server initialized global system variables during startup. If a variable with a VARIABLE_SOURCE value other than DYNAMIC is set at runtime, ... The ...
https://dev.mysql.com/doc/refman/9.7/en/pluggable-authentication.html
To minimize the potential for incompatibilities, regularly upgrade the server, clients, and connectors on a timely basis. The only time the client loads the plugin specified by the server is for a change-plugin request, but in that case it can be ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-examples.html
Consider the following stored procedure, which adds .0001 to a variable 1,000 times. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.25.3, ...
https://dev.mysql.com/doc/refman/9.7/en/program-variables.html
Many MySQL programs have internal variables that can be set at runtime using the SET statement. Both set the size of the server's key buffer to 512MB: [mysqld] key_buffer_size=512M [mysqld] key-buffer-size=512M Suffixes for specifying a value ...
https://dev.mysql.com/doc/refman/9.7/en/regexp.html
To control the maximum number of steps performed by the engine (and thus indirectly the execution time), set the regexp_time_limit system variable. Because this limit is expressed as number of steps, it affects execution time only indirectly. This ...
https://dev.mysql.com/doc/refman/9.7/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format; namely, the TIME, DATETIME, and ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-fractional-seconds.html
MySQL 9.7 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.