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/index-page-merge-threshold.html
The MERGE_THRESHOLD for index pages can be defined for a table or for individual indexes. A MERGE_THRESHOLD value defined for an individual index takes priority over a MERGE_THRESHOLD value defined for the table. Setting MERGE_THRESHOLD for a Table ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. <AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> ...Typically the first audit record written after plugin startup contains the server description and startup ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. You can find more detailed information about each of these tables in the next several sections. ndbinfo ... ndbinfo is a database containing information specific to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...As of MySQL 5.7.11, that is still true for nondependent ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-memory.html
A change in max_heap_table_size takes effect for MEMORY tables that are created or updated using ALTER TABLE ... When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
This section builds on the performance tuning advice from Section 14.9.1.3, “Tuning Compression for InnoDB Tables”, and shows how to find problems that might not turn up during initial testing. To dig deeper into performance considerations for ... Overall application performance, CPU and I/O utilization and the size of disk files are good indicators of how effective compression is for your ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
(Bug #16396) References to stored functions, loadable functions, and tables in the ON SCHEDULE clauses of CREATE EVENT and ALTER EVENT statements are not supported. Altering the system tables in the mysql database is not supported and is very likely ...The following statements are not permitted: The locking statements LOCK TABLES and UNLOCK ...Some of the restrictions ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
When copying an NDB table as part of an ALTER TABLE, the creation of the copy is nontransactional. NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the ...