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/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
MySQL Enterprise Backup can also create compressed backup files, and back up subsets of tables and databases. Logical Backups Using mysqldump In addition to physical backups, it is recommended that you regularly create logical backups by dumping ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
The default setting is ibtmp1:12M:autoextend, which creates the ibtmp1 temporary tablespace data file in the data directory. For example: --innodb-temp-data-file-path=../../../tmp/ibtmp1:12M:autoextend As of MySQL 8.0, enabling innodb_read_only ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-other-options.html
myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line Format --analyze Analyze the distribution of key values. This improves join performance by enabling the join optimizer to better ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html
As an example, suppose that around 20:06:00 on March 11, 2020, an SQL statement was executed that deleted a table. You can perform a point-in-time recovery to restore the server up to its state right before the table deletion. These are some sample ... The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. Serialized dictionary information (SDI) is present in all InnoDB tablespace files except for temporary tablespace and undo ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
For example: mysql> GET DIAGNOSTICS CONDITION 1 @p5 = SCHEMA_NAME, @p6 = TABLE_NAME; mysql> SELECT @p5, @p6; +------+------+ | @p5 | @p6 | +------+------+ | | | +------+------+ In standard SQL, if there are multiple conditions, the first condition ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-list.html
See Section 15.1.20, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, and also registers it in the mysql.plugins system table to cause the server to load it ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...