PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimize-multi-tables.html
Some techniques for keeping individual queries fast involve splitting data across many tables. When the number of tables runs into the thousands or even millions, the overhead of dealing with all these tables becomes a new performance consideration.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instance-tables.html
They provide event names and explanatory notes or status information: cond_instances: Condition synchronization object instances file_instances: File instances mutex_instances: Mutex synchronization object instances rwlock_instances: Lock ...There ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-lock-tables.html
The Performance Schema exposes lock information through these tables: metadata_locks: Metadata locks held and requested table_handles: Table locks held and requested The following sections describe these tables in more detail.
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
Adding an AUTO_INCREMENT column to a table with ALTER TABLE might not produce the same ordering of the rows on the replica and the source. Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, subject to the following exceptions: When using statement-based replication prior to MySQL 5.7.1, AUTO_INCREMENT columns in tables on the replica must match the same columns on the source; that is, AUTO_INCREMENT columns must be replicated to AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Prepared Statements in SQL Scripts An alternative SQL interface to prepared statements is available. Metadata changes to tables or views referred to by prepared statements are detected and cause automatic repreparation of the statement when it is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-background.html
The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. Specify a value that is too small, and the CREATE TABLE or ALTER TABLE statement fails. An InnoDB table created with ROW_FORMAT=COMPRESSED can ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users who have privileges for that database. The tables use the InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. This is a very easy way to get the definition of any table in a database. You should also include the output ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...