PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/nontransactional-tables.html
This can happen if you try to create a table using a transactional storage engine that is not supported by your mysqld server (or that was disabled with a startup option). If mysqld does not support a storage engine, it instead creates the table as ... 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 nontransactional tables are not affected by the ROLLBACK ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-memory-management.html
Online DDL operations that create or rebuild secondary indexes allocate temporary buffers during different phases of index creation. The setting applies to buffers created by threads executing online DDL operations. Defining an appropriate buffer ...The innodb_ddl_buffer_size variable, introduced in MySQL 8.0.27, defines the maximum buffer size for online DDL ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Do not create a separate secondary index for each column, because each query can only make use of one index. If you have many queries for the same table, testing ...Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
To see whether a given Performance Schema table has indexes and what they are, use SHOW INDEX or SHOW CREATE TABLE: mysql> SHOW INDEX FROM performance_schema.accounts\G *************************** 1. row *************************** Table: accounts ... Applications that monitor databases may make frequent use of Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
Instrument Server Command statement/com/Prepare COM_STMT_PREPARE statement/com/Execute COM_STMT_EXECUTE statement/sql/prepare_sql SQLCOM_PREPARE statement/sql/execute_sql SQLCOM_EXECUTE The Performance Schema manages the contents of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
To see the structure of individual tables, use SHOW CREATE TABLE: mysql> SHOW CREATE TABLE performance_schema.setup_consumers\G *************************** 1. row *************************** Table: setup_consumers Create Table: CREATE TABLE ... This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html
The maximum number of channels that can be created on one replica server in a multi-source replication topology is 256. To provide compatibility with previous versions, the MySQL server automatically creates on startup a default channel whose name ... In MySQL multi-source replication, a replica opens multiple replication channels, one for each source ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
You must obtain (or create) a suitable security certificate that you can use on the source, and a similar certificate (from the same certificate authority) on each replica. If you want to ensure that the source only accepts replicas that connect ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html
If an upgraded replication source server still has old replicas using MySQL versions that do not support multiple triggers, an error occurs on those replicas if a trigger is created on the source for a table that already has a trigger with the same ... With statement-based replication, triggers executed on the source also execute on the ...