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/mysqlshow.html
The output displays only the names of those databases, tables, or columns for which you have some privileges. The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. The same information ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table. The exact changes made to each table depend on the storage engine used by that ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
You can see that this is the case by re-running the previous SELECT query: mysql> SELECT * FROM tr WHERE purchased -> BETWEEN '1995-01-01' AND '1999-12-31'; Empty set (0.00 sec) Because of this, you must have the DROP privilege for a table before ...
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. Specific Performance Schema features can be enabled at runtime to control which types of event collection occur. For additional details about these tables, see Section 25.12.2, “Performance Schema Setup ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-tables.html
For this reason, some columns in these tables can be changed if you have the UPDATE privilege. The setup tables provide information about the current instrumentation and enable the monitoring configuration to be changed. The use of tables rather ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. The log consists of a set of binary log files, plus an index file ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-status-and-maintenance.html
Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. To check whether the query cache is present in your MySQL server, use the following statement: mysql> SHOW VARIABLES LIKE 'have_query_cache'; ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines only. Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data ...