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/string-types.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For descriptions of functions that operate on string values, see Section 14.8, “String Functions and Operators”. For information about storage requirements ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-errors.html
In MySQL 8.0.19 and later, all of the errors described in this section also apply when using TABLE in subqueries. Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-reset-to-default.html
row *************************** status: Resetting: setup_actors DELETE FROM performance_schema.setup_actors WHERE NOT (HOST = '%' AND USER = '%' AND ROLE = '%') *************************** 1. Parameters in_verbose BOOLEAN: Whether to display ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-save.html
ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). If you end your session without invoking ps_setup_save(), the ...This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-id.html
Note As of MySQL 8.0.16, ps_thread_id() is deprecated and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in PS_THREAD_ID() and PS_CURRENT_THREAD_ID() functions instead. See Section 14.21, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. in_auto_setup BOOLEAN: Whether to disable all other threads and enable all instruments and consumers. Dumps all Performance Schema data for an ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-unused-indexes.html
This view is most useful when the server has been up and processing long enough that its workload is representative. These views display indexes for which there are no events, which indicates that they are not being used. Otherwise, presence of an ...
https://dev.mysql.com/doc/refman/8.0/en/sys-version.html
This view provides the current sys schema and MySQL server versions. Note As of MySQL 8.0.18, this view is deprecated and subject to removal in a future MySQL version. Applications that use it should be migrated to use an alternative instead. For ...
https://dev.mysql.com/doc/refman/8.0/en/too-many-connections.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of unprivileged clients are connected.
https://dev.mysql.com/doc/refman/8.0/en/updating-apt-repo.html
On Debian and Ubuntu platforms, to perform an in-place upgrade of MySQL and its components, use the MySQL APT repository. See Upgrading MySQL with the MySQL APT Repository in A Quick Guide to Using the MySQL APT Repository.