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/sys-ps-setup-show-disabled-instruments.html
Displays all currently disabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-show-enabled-instruments.html
Displays all currently enabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_enabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/9.7/en/sys-statements-with-errors-or-warnings.html
last_seen The time at which the statement was most recently seen. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/doc/refman/9.7/en/thread-pool-information-schema-tables.html
They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information about thread pool thread group states TP_THREAD_GROUP_STATS: Thread group statistics TP_THREAD_STATE: Information about thread pool thread states Rows in these ... Note The INFORMATION_SCHEMA thread pool tables are deprecated, and subject to removal in a future version of ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. To be safe, always use complete datetime, date, or time strings when doing ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/9.7/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 9.7 Options and Variables Deprecated in MySQL 9.7 Options and Variables Removed in MySQL 9.7 This section lists server variables, status variables, and options that were added for the first time, have been ...Options and Variables Introduced in MySQL 9.7 The following system variables, status variables, and server options have been added in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/alter-database.html
Events: CREATE EVENT ALTER EVENT DROP EVENT Event execution: Executing an event in the database fails because that would change the last-execution timestamp, which is event metadata stored in the data dictionary. It backs up and restores a read-only ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/9.7/en/archive-storage-engine.html
A bulk insert is visible only after it completes, unless other inserts occur at the same time, in which case it can be seen partially. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-setting.html
The logging format also can be switched at runtime, although note that there are a number of situations in which you cannot do this, as discussed later in this section. Some statements require a lot of execution time on the source, but result in ...
https://dev.mysql.com/doc/refman/9.7/en/bnl-bka-optimization.html
Incremental buffers also provide a savings in processing time due to the reduction in copying time. In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA ...