Search Results
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...
https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
The OBJECT_TYPE column says USER LEVEL LOCK and the OBJECT_NAME column indicates the lock name. When this happens, the server chooses a caller and terminates its lock-acquisition request with an ER_USER_LOCK_DEADLOCK error. While held by one ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-error-messages.html
The error_messages table provides information about The error_messages table contains the following columns: error_code Numeric error code error_description Description of error error_status Error status code error_classification Error ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-overview.html
Typical users aim to get the best database performance out of their existing software and hardware configurations. Advanced users look for opportunities to improve the MySQL software itself, or develop their own storage engines and hardware ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-persisted-variables-table.html
The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings, enabling the file contents to be inspected at runtime using SELECT statements. Variables are persisted using ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-queries.html
Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
Rows can be inserted into or deleted from setup_objects by users with the INSERT or DELETE privilege on the table. For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-characteristics.html
The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
In this way, aggregations at higher levels are available directly without the need for user-defined views that sum lower-level columns. In this way, aggregations at higher levels are available directly without the need for user-defined views that ...