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/performance-schema-quick-start.html
row *************************** THREAD_ID: 0 EVENT_ID: 5523 END_EVENT_ID: 5523 EVENT_NAME: wait/synch/mutex/mysys/THR_LOCK::mutex SOURCE: thr_lock.c:525 TIMER_START: 201660494489586 TIMER_END: 201660494576112 TIMER_WAIT: 86526 SPINS: NULL ... This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-restrictions.html
Tables in the performance_schema database cannot be locked with LOCK TABLES, except the setup_xxx tables. The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes be ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
TABLE filtering affects table I/O events (wait/io/table/sql/handler instrument) and table lock events (wait/lock/table/sql/handler instrument). The setup_objects table controls whether the Performance Schema monitors particular objects. This table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variables.html
Performance_schema_locker_lost How many events are “lost” or not recorded, due to the following conditions: Events are recursive (for example, waiting for A caused a wait on B, which caused a wait on C). Performance_schema_metadata_lock_lost The ...Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was ...
https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html
With this method, also include a password so that if the account is unlocked later, it cannot be accessed with no password. (If the validate_password component is enabled, creating an account without a password is not permitted, even if the account ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html
PURGE BINARY LOGS should not be issued while a LOCK INSTANCE FOR BACKUP statement is in effect for the instance, because it contravenes the rules of the backup lock by removing files from the server. PURGE { BINARY | MASTER } LOGS { TO 'log_name' | ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html
When you are using MyISAM, you must stop processing statements on the source to obtain a read-lock, then obtain its current binary log coordinates and dump its data, before permitting the source to continue executing statements. If you are using ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
Example: SELECT * INTO @myvar FROM t1; Before a trailing locking clause. The position before a locking clause is deprecated as of MySQL 8.0.20; expect support for it to be removed in a future version of MySQL. INTO form of SELECT enables a query ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
If it is desired to compile without particular types of instrumentation, that can be done with the following CMake options: DISABLE_PSI_COND DISABLE_PSI_DATA_LOCK DISABLE_PSI_ERROR DISABLE_PSI_FILE DISABLE_PSI_IDLE DISABLE_PSI_MEMORY ... The CMake ...
https://dev.mysql.com/doc/refman/8.0/en/stop-group-replication.html
STOP GROUP_REPLICATION does not complete until either the situation is resolved (for example, by the lock being released), or the component timeout expires and the modules are shut down regardless of their status. This statement requires the ...