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/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. This updates a value for each index part that indicates ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning.html
An attempt to create a partitioned tables using a storage engine that does not supply native partitioning support fails with ER_CHECK_NOT_IMPLEMENTED. Note Table partitioning differs from partitioning as used by window functions. In MySQL 8.0, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-tables.html
If the clone plugin is loaded but disabled, the tables are not created. Note The Performance Schema tables described here are available as of MySQL 8.0.17. The following sections describe the Performance Schema tables associated with the clone ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html
Attribute names that begin with an underscore (_) are reserved for internal use and should not be created by application programs. Connection attributes are key-value pairs that application programs can pass to the server at connect time. For ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-file-summary-tables.html
COUNT_MISC, SUM_TIMER_MISC, MIN_TIMER_MISC, AVG_TIMER_MISC, MAX_TIMER_MISC These columns aggregate all other I/O operations, including CREATE, DELETE, OPEN, CLOSE, STREAM_OPEN, STREAM_CLOSE, SEEK, TELL, FLUSH, STAT, FSTAT, CHSIZE, RENAME, and SYNC.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-miscellaneous-tables.html
user_defined_functions: Loadable functions registered by a component, plugin, or CREATE FUNCTION statement. The following sections describe tables that do not fall into the table categories discussed in the preceding sections: ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
When some code creates a mutex, a row is added to the mutex_instances table. The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. Example information about NDB database objects which cannot be synchronized with ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-pre-filtering.html
Modifications to any of these tables affect monitoring immediately, with the exception that modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. Pre-filtering is done ...