PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-communication-information-table.html
This is set to accommodate the oldest MySQL Server version that you want the group to support. For a group in single-primary mode with the group_replication_paxos_single_leader system variable set to ON and the communication protocol version set to ... This table shows group configuration options for the whole replication ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-restrictions.html
The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes be incorrect. If the values in this table for a given timer name are NULL, that timer is not supported on ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-tables.html
The setup tables provide information about the current instrumentation and enable the monitoring configuration to be changed. For this reason, some columns in these tables can be changed if you have the UPDATE privilege. For example, you can use a ...The use of tables rather than individual variables for setup information provides a high degree of flexibility in modifying Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-threads-table.html
It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G *************************** 1. For background threads, setting the ENABLED value controls whether INSTRUMENTED is set to YES or NO for threads that ...row *************************** NAME: thread/performance_schema/setup ENABLED: YES HISTORY: YES PROPERTIES: singleton VOLATILITY: 0 DOCUMENTATION: NULL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variable-tables.html
variables_info: Shows, for each system variable, the source from which it was most recently set, and its range of values. The global_variables and session_variables tables have these columns: VARIABLE_NAME The system variable name. The ... The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-characteristics.html
Many tables in the performance_schema database are read only and cannot be modified: mysql> TRUNCATE TABLE performance_schema.setup_instruments; ERROR 1683 (HY000): Invalid performance_schema usage. That might be useful, for example, after you have ... The name of the performance_schema database is lowercase, as are the names of tables within ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-state-table.html
The value shown in this column is one of CONNECTION_HANDLER_WORKER_THREAD, LISTENER_WORKER_THREAD, QUERY_WORKER_THREAD, or TIMER_WORKER_THREAD. The tp_thread_state table has one row per thread created by the thread pool to handle connections. Note ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/8.0/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). Such truncation is not an error, even in strict SQL mode (see Section 14.24.3, “Expression ...The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-drop-if-exists.html
The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP VIEW IF EXISTS statements are always replicated, even if the database, table, or view to be dropped does not exist on the source. IF EXISTS statements for stored programs (stored ...This ...