PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. The DROP TABLE and CREATE TABLE statements are not executed because the default database is not db1, even though the statements name a table in db1. The INSERT ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. Caution Because a global privilege is considered a privilege ...The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild'] You see only those databases for which you have some kind of privilege, unless you have the global SHOW DATABASES ...
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/identifier-mapping.html
Because such conversions are deprecated, the --fix-db-names and --fix-table-names options for mysqlcheck and the UPGRADE DATA DIRECTORY NAME clause for the ALTER DATABASE statement are also deprecated. There is a correspondence between database and ...For the data and index files, the exact representation on disk is storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
Allowing or Disallowing DDL By default, you can perform DDL operations such as ALTER TABLE on tables used by the daemon_memcached plugin. Although the default behavior does not offer the best possible raw performance, it is still fast compared to ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
Note As of MySQL 5.7.39, an alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, like the threads table, does not require a mutex and has better performance characteristics. The ...
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/create-table-secondary-indexes.html
Even with additional write costs, secondary indexes on virtual columns may be preferable to generated stored columns, which are materialized in the clustered index, resulting in larger tables that require more disk space and memory. row ...A ...