PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
mysql schema tables fall into two broad categories: Data dictionary tables, which store database object metadata. Placing the host name and user name together means that index lookup can be used, which improves performance for CREATE USER, DROP ...
https://dev.mysql.com/doc/refman/8.0/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. Optionally, the DBD module for any other type of database server you want to access. To ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. These events bring databases up to date from the point of the backup. The term “binary log file” generally denotes ...It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is ...
https://dev.mysql.com/doc/refman/8.0/en/binlog-replication-configuration-overview.html
This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes take place) writes updates and changes as “events” to the binary ...Each replica receives a copy of the entire contents of the binary ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-find-table.html
You can check which tables are in the default database with SHOW TABLES. Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase.
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
For mysql, the first nonoption argument is taken as the name of the default database. Because there is no such argument, mysql selects no default database. This section describes use of command-line options to specify how to establish connections ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
When the underlying data dictionary tables store values previously obtained by directory scans (for example, to enumerate database names or table names within databases) or file-opening operations (for example, to read information from .frm files), ...In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html
This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database server. For large databases where you access data more or less randomly, you can be sure that you need at least one disk ...For information about optimizing an InnoDB configuration to improve I/O performance, see Section 10.5.8, “Optimizing InnoDB Disk ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-information-schema.html
Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Can I add to or otherwise modify the tables found in the INFORMATION_SCHEMA database? A.7.1. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? ...Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? ...