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-pre-filtering.html
Pre-filtering can be applied to either the producer or consumer stage of event processing: To configure pre-filtering at the producer stage, several tables can be used: setup_instruments indicates which instruments are available. An instrument ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
If you encounter a runaway rollback caused by a failing mass import or ALTER TABLE, you can kill the mysqld process and set innodb_force_recovery to 3 to bring the database up without the rollback, and then DROP the table that is causing the runaway ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
Consistent read does not work over ALTER TABLE operations that make a temporary copy of the original table and delete the original table when the temporary copy is built. This exception causes the following anomaly: If you update some rows in a ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-start.html
myisam_max_sort_file_size The maximum size of the temporary file that MySQL is permitted to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA). The following options to mysqld can be used to change the behavior of ...bulk_insert_buffer_size The size of the tree cache used in bulk insert ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. See Section 8.4.7, “Limits on Table Column Count and Row Size”. (The practical limit is less than 3000.) A table can ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/5.7/en/deleting-from-related-tables.html
If the total length of the DELETE statement for related_table is more than 1MB (the default value of the max_allowed_packet system variable), you should split it into smaller parts and execute multiple DELETE statements. You probably get the ...
https://dev.mysql.com/doc/refman/5.7/en/table-definition-issues.html
...
https://dev.mysql.com/doc/refman/5.7/en/table-maintenance-statements.html
...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
If a stored program that modifies data is nondeterministic, it is not repeatable. To create or alter a stored function, you must have the SUPER privilege, in addition to the CREATE ROUTINE or ALTER ROUTINE privilege that is normally required. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema.html
This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list ...