PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-version.html
Note As of MySQL 8.0.18, this view is deprecated and subject to removal in a future MySQL version. This view provides the current sys schema and MySQL server versions. Applications that use it should be migrated to use an alternative instead. For ...
https://dev.mysql.com/doc/refman/8.0/en/system-variable-privileges.html
Note Any user who has SYSTEM_VARIABLES_ADMIN or SUPER effectively has SESSION_VARIABLES_ADMIN by implication and need not be granted SESSION_VARIABLES_ADMIN explicitly. (For information about dynamic variables, see Section 7.1.9.2, “Dynamic System ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html
Note To spread the load effectively, these paths should be located on different physical disks, not different partitions of the same disk. On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-elements.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; Note If you do not load all the monitoring tables, ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-information-schema-tables.html
Note As of MySQL 8.0.14, the INFORMATION_SCHEMA thread pool tables are also available as Performance Schema tables. (See Section 29.12.16, “Performance Schema Thread Pool Tables”.) The INFORMATION_SCHEMA tables are deprecated; expect them be ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool.html
Note MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Thread Pool, implemented using a server plugin. The default thread-handling model in ...
https://dev.mysql.com/doc/refman/8.0/en/time.html
Note that because '00:00:00' is itself a valid TIME value, there is no way to tell, from a value of '00:00:00' stored in a table, whether the original value was specified as '00:00:00' or whether it was invalid. MySQL retrieves and displays TIME ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
Note The following examples use DEFAULT 0, a default that can produce warnings or errors depending on whether strict SQL mode or the NO_ZERO_DATE SQL mode is enabled. TIMESTAMP and DATETIME columns can be automatically initialized and updated to ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...