PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-filtering.html
The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and (for enabled instruments) whether to collect timing information: mysql> SELECT * FROM performance_schema.setup_instruments; ... Events ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-runtime-configuration.html
If you have the UPDATE privilege, you can change Performance Schema operation by modifying setup tables to affect how monitoring occurs. For additional details about these tables, see Section 25.12.2, “Performance Schema Setup Tables”. The ...
https://dev.mysql.com/doc/refman/5.7/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
Trigger or stored program updates a table having an AUTO_INCREMENT column. In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. ON ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Indexes are especially important for queries that reference ...
https://dev.mysql.com/doc/refman/5.7/en/server-shutdown.html
For additional information about thread termination, see Section 13.7.6.4, “KILL Statement”, in particular for the instructions about killed REPAIR TABLE or OPTIMIZE TABLE operations on MyISAM tables. If a thread is updating a nontransactional ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR TABLE. (Even with ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
row *************************** id: 2 select_type: DEPENDENT SUBQUERY table: t2 type: ref_or_null possible_keys: maybe_null_key key: maybe_null_key key_len: 5 ref: func rows: 2 Extra: Using where; Using index ... Triggered equalities can be used by ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table and that derived table is materialized ...