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/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the global level; see Section 13.7.1.4, “GRANT ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema.html
Other terms that are sometimes used for this information are data dictionary and system catalog. INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
This mode of operation might be unfamiliar if you have experience with other database systems, where it is standard practice to issue a sequence of DML statements and commit them or roll them back all together. If autocommit mode is enabled, each ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-backup-recovery.html
This section covers topics related to InnoDB backup and recovery. For information about backup techniques applicable to InnoDB, see Section 14.19.1, “InnoDB Backup”. For information about point-in-time recovery, recovery from disk failure or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benchmarking.html
In this case, add the ENGINE=other_engine_name clause to the CREATE TABLE statement to avoid the error. If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
This cache applies to many types of information and speeds up processing. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. Use joins wherever data is pulled from multiple tables based on identical ID values from those ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression.html
This section provides information about the InnoDB table compression and InnoDB page compression features. The page compression feature is referred to as transparent page compression. Using the compression features of InnoDB, you can create tables ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuration.html
This section provides configuration information and procedures for InnoDB initialization, startup, and various components and features of the InnoDB storage engine. For information about optimizing database operations for InnoDB tables, see Section ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
This section discusses the main considerations for I/O and disk space with the default kind of MySQL tables (also known as InnoDB tables): Controlling the amount of background I/O used to improve query performance. As a DBA, you must manage disk ...