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/information-schema-innodb-tablestats-table.html
The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data is used by the MySQL optimizer to calculate which index to use when querying an InnoDB table. InnoDB tables are represented in this view if ...This information is derived from in-memory data structures rather than data stored on ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
A change in max_heap_table_size takes effect for MEMORY tables that are created or updated using ALTER TABLE ... When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
(Bug #16396) References to stored functions, loadable functions, and tables in the ON SCHEDULE clauses of CREATE EVENT and ALTER EVENT statements are not supported. Altering the system tables in the mysql database is not supported and is very likely ...The following statements are not permitted: The locking statements LOCK TABLES and UNLOCK ...Some of the restrictions ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam-bulk-data-loading.html
For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if there are no deleted rows in middle of the data file. With some extra work, it is possible to make LOAD DATA run even faster for a ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
For releases before MySQL 8.0.17, the default value of 1000 for gtid_executed_compression_period can be used, meaning that compression of the table is performed after each 1000 transactions, or you can choose an alternative value. The MySQL system ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.0/en/request-access.html
This is where the privilege columns in the grant tables come into play. These privileges can come from any of the user, global_grants, db, tables_priv, columns_priv, or procs_priv tables. (You may find it helpful to refer to Section 8.2.3, “Grant ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/8.0/en/nontransactional-tables.html
If you receive the following message when trying to perform a ROLLBACK, it means that one or more of the tables you used in the transaction do not support transactions: Warning: Some non-transactional changed tables couldn't be rolled back These ...
https://dev.mysql.com/doc/refman/8.0/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. row *************************** SCHEMA_NAME: NULL NAME: ts1 TYPE: TABLESPACE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html
The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary Tables”). Section 29.12.6, “Performance Schema ...To ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variable-summary-tables.html
The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable Tables”. It also makes aggregated status variable information available in summary tables, ...