Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-tables.html
If the clone plugin is loaded but disabled, the tables are not created. The following sections describe the Performance Schema tables associated with the clone plugin (see Section 7.6.7, “The Clone Plugin”). clone_status: status information ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ... An ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
user_defined_functions: Loadable functions registered by a component, plugin, or CREATE FUNCTION statement. The following sections describe tables that do not fall into the table categories discussed in the preceding sections: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. Example information about NDB database objects which cannot be synchronized with ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
It is possible that a plugin installed later may create the instrument, at which time the name is recognized and configured. To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-pool-tables.html
If the thread pool plugin is loaded but disabled, the tables are not created. The following sections describe the Performance Schema tables associated with the thread pool plugin (see Section 7.6.3, “MySQL Enterprise Thread Pool”). They provide ...
https://dev.mysql.com/doc/refman/8.4/en/perror.html
perror displays the error message for MySQL or operating system error codes. For example, for the ER_WRONG_VALUE_FOR_VAR error, perror understands any of these arguments: 1231, 001231, MY-1231, or MY-001231, or ER_WRONG_VALUE_FOR_VAR. The meaning ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.4/en/primary-key-optimization.html
If your table is big and important, but does not have an obvious column or set of columns to use as a primary key, you might create a separate column with auto-increment values to use as the primary key. The primary key for a table represents the ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-mysql-sock.html
On most versions of Unix, you can protect your /tmp directory so that files can be deleted only by their owners or the superuser (root). Another approach is to change the place where the server creates the Unix socket file. The default location for ...