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/group-replication-view-changes.html
This section explains the process which controls how the view change identifier is incorporated into a binary log event and written to the log, The following steps are taken: Begin: Stable Group All servers are online and processing incoming ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 23.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. For additional information ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup.html
The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used directly by the mysqld server for faster restore. Using MySQL Enterprise Backup is the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. Use joins wherever data is pulled from multiple tables based on identical ID values from those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-io.html
InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while permitting other database operations to proceed while the I/O is still in progress. On Linux and Windows platforms, InnoDB uses the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-defragmenting.html
Random insertions into or deletions from a secondary index can cause the index to become fragmented. Fragmentation means that the physical ordering of the index pages on the disk is not close to the index ordering of the records on the pages, or ...