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/partitioning-limitations-storage-engines.html
Partitioned InnoDB tables cannot have foreign key references, nor can they have columns referenced by foreign keys. InnoDB tables which have or which are referenced by foreign keys cannot be partitioned. CREATE TABLE and ALTER TABLE statements that ... In MySQL 8.0, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
pt does not have any partitions that use the DATA DIRECTORY option. In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... Table nt contains no ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
For example, the events_transactions_history and events_transactions_history_long tables are collections of the most recent transaction events that have ended, up to a maximum number of rows per thread and globally across all threads, respectively.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-metadata-locks-table.html
The Performance Schema exposes metadata lock information through the metadata_locks table: Locks that have been granted (shows which sessions own which current metadata locks). Locks that have been requested but not yet granted (shows which sessions ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-rwlock-instances-table.html
An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access to some common resource following certain rules. The access is either shared (many threads can have a read lock at the same time), ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
In other words, for a given digest, 95% of the statements measured have a latency lower than QUANTILE_95. The row with DIGEST = NULL is maintained because Performance Schema tables have a maximum size due to memory constraints. The Performance ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
events_statements_history: The most recent statement events that have ended per thread. events_statements_history_long: The most recent statement events that have ended globally (across all threads). Instruments for commands have names that begin ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-wait-summary-tables.html
These columns have the same meaning as in the events_waits_current table. As indicated in the column descriptions, some columns are more general and have values that are the same as the sum of the values of more fine-grained columns. These columns ... The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock waits per table 29.12.20.8.1 The table_io_waits_summary_by_table Table The table_io_waits_summary_by_table table aggregates all table I/O wait events, as generated by the wait/io/table/sql/handler ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
Monitoring occurs only for those thread events produced from instruments that have the ENABLED column set to YES in the setup_instruments table. Logging occurs only for those thread events produced from instruments that have the ENABLED column set ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
If columns d1 and d2 had been defined as DECIMAL rather than DOUBLE, the result of the SELECT query would have contained only one row—the last one shown above. Floating-point numbers sometimes cause confusion because they are approximate and not ...