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-events-waits-history-long-table.html
The events_waits_history_long table contains N the most recent wait events that have ended globally, across all threads. Wait events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when a ...The Performance Schema autosizes the value of N during server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
The following table shows all Performance Schema tables relating to the NDBCLUSTER storage engine. When attempting to synchronize such objects, NDB removes the object from the queue awaiting synchronization, and from this table, and tries to ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-formats.html
The third, compressed format, can be created only with the myisampack utility (see Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”). When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
For a query in which the condition is on the tables of a view created using ALGORITHM=TEMPTABLE instead of on the view itself, the multiple equality is not recognized at resolution, and thus the condition cannot be not pushed down. When a derived ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html
If a file-per-table tablespace is created in a location outside the MySQL data directory, the path value is a fully qualified directory path. The INNODB_DATAFILES table provides data file path information for InnoDB file-per-table and general ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tp-thread-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; The TP_THREAD_STATE table has one row per thread ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-table.html
Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
When some code creates a mutex, a row is added to the mutex_instances table. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. The mutex_instances table has these columns: NAME The instrument ...A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-state-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA table instead; see Section 28.5.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”. The ...