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/performance-schema-setup-objects-table.html
For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED ...
https://dev.mysql.com/doc/refman/8.0/en/component-loading.html
MySQL supports manual component loading at runtime and automatic loading during server startup. For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles ...The INSTALL COMPONENT and UNINSTALL COMPONENT SQL statements enable component loading and ...
https://dev.mysql.com/doc/refman/8.0/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 17.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...Internal Details InnoDB uses a buddy allocator system to manage memory allocated to pages of various sizes, from 1KB to ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped. However, this privilege is granted automatically to the creator of a routine if necessary (and dropped from ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam-bulk-data-loading.html
This does not update any indexes and therefore is very fast. If you use locking, connections 2, 3, and 4 probably do not finish before 1 or 5, but the total time should be about 40% faster. INSERT, UPDATE, and DELETE operations are very fast in ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
If you often need to calculate results such as counts based on information from a lot of rows, it may be preferable to introduce a new table and update the counter in real time. Try to avoid complex SELECT queries on MyISAM tables that are updated ...This updates a value for each index part that indicates the average number of rows that have the same ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better ...
https://dev.mysql.com/doc/refman/8.0/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. Please spend some time and effort in preparing a good bug report. For example, if ...In this case, the replication thread stops and waits for you to clean up the tables manually to bring them into ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
Prepared statement execution Execution of a COM_STMT_EXECUTE or SQLCOM_PREPARE command for an instrumented prepared statement instance updates the corresponding prepared_statements_instances table row. COUNT_REPREPARE The number of times the ...This ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.0/en/checksum-table.html
For example, the storage format for temporal types such as TIME, DATETIME, and TIMESTAMP changed in MySQL 5.6 prior to MySQL 5.6.5, so if a 5.5 table is upgraded to MySQL 5.6, the checksum value may change. You can use this statement to verify that ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...