PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html
The setup_timers table contains a row with a NAME value of wait that indicates the unit for wait event timing. The Performance Schema instruments waits, which are events that take time. These tables store wait events: events_waits_current: The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
The statement is always logged in statement format, even if the binary logging format is set to ROW, and it is written even if read_only or super_read_only mode is set on the server. When binlog_format=ROW, you can prevent the replica from stopping ...To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or (from MySQL 5.7.32) TRUNCATE TABLE statement for that table to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
This variable takes a set of values from the following table, which shows the effects of each mode on the replica's type-conversion behavior: Mode Effect ALL_LOSSY In this mode, type conversions that would mean loss of information are permitted. A ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-pitr.html
To perform point-in-time recovery of NDB Cluster, it is necessary to follow the steps shown here: Back up all NDB databases in the cluster, using the START BACKUP command in the ndb_mgm client (see Section 21.6.8, “Online Backup of NDB Cluster”). Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the server to its state when the backup was ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
The normal way to report bugs is to visit http://bugs.mysql.com/, which is the address for our bugs database. Bugs posted in the bugs database at http://bugs.mysql.com/ that are corrected for a given release are noted in the release notes. To ...We ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
.frm Files MySQL stores data dictionary information for tables in .frm files in database directories. InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ...However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-basics.html
You should also bear in mind that using MAX_ROWS to set the number of partitions in this fashion is deprecated in NDB 7.5.4 and later, where you should use PARTITION_BALANCE instead; see Section 13.1.18.9, “Setting NDB Comment Options”, for more ...This procedure applies whether you are using ndbd or ndbmtd binaries for the data node ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for ...The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-profiling-table.html
Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 13.7.5.30, “SHOW PROFILE Statement”). The table is empty unless the profiling session variable is set to 1. Use the Performance ...