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/myisam-maintenance-schedule.html
It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair MyISAM tables is with the CHECK TABLE and REPAIR TABLE statements. It is also a good idea to enable automatic MyISAM ...The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these operations. This currently has the following formats: Base table: ...The syntax just shown for fully qualified object names is an internal interface which is subject to change in future ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these columns: table_schema The schema that contains the table. total_latency The ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or both. (Ideally, the InnoDB tables should ...Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
The plugin determines whether to rewrite statements based on its in-memory cache of rewriting rules, which are loaded from the rewrite_rules table in the query_rewrite database. The following example creates a simple rule to match statements that ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. Time Zone Variables Populating the ...Beginning with MySQL 8.0.19, time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. Using the SHOW TABLE STATUS statement to determine whether a table is ... This ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cached-indexes-table.html
The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each index. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. row ...Index ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-brief-table.html
The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for file-per-table, general, undo, and system tablespaces. INNODB_TABLESPACES provides the same metadata but loads more slowly because other metadata ...