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/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). This indicates how much of the sequence ...By default, rows are sorted by descending usage ratio and maximum column ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-overview.html
This view summarizes the types of objects within each schema. Note For MySQL instances with a large number of objects, this view might take a long time to execute. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Also, remember that if you enable additional configuration, you can easily restore the default configuration like this: CALL ...Because the sys schema ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-unused-indexes.html
This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an index in this view may not be meaningful. These views display indexes for which there are no events, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version.html
This view provides the current sys schema and MySQL server versions. Note As of MySQL 5.7.28, this view is deprecated and subject to removal in a future MySQL version. Applications that use it should be migrated to use an alternative instead. For ...
https://dev.mysql.com/doc/refman/5.7/en/system-variable-privileges.html
This section describes the privileges required to assign values to system variables at runtime. If a session system variable is restricted in this way, the variable description indicates that restriction. A system variable can have a global value ...
https://dev.mysql.com/doc/refman/5.7/en/table-corruption.html
If this happens, MySQL writes an entry in the hostname.err file 'Warning: Checking table ...' which is followed by Warning: Repairing table if the table needs to be repaired. If you have started mysqld with the myisam_recover_options system ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Daemon This thread is internal to the server, not a thread that services a client connection.
https://dev.mysql.com/doc/refman/5.7/en/thread-pool.html
Note MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Thread Pool, implemented using a server plugin. The default thread-handling model in ...
https://dev.mysql.com/doc/refman/5.7/en/transport-protocols.html
This section describes how to select these protocols, and how they are similar and different. (Named-pipe transport does allow for remote connections, but this capability is not implemented in MySQL.) Interpretation of localhost If the transport ...