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/miscellaneous-optimization-tips.html
Similarly, if your application computes a single result based on several column values or large volumes of data, combining the computation into a loadable function can help performance. If you have data that does not conform well to a ... This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql.html
If you have problems due to insufficient memory for large result sets, use the --quick option. This forces mysql to retrieve results from the server a row at a time rather than retrieving the entire result set and buffering it in memory before ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-timing.html
The time a statement (or stage) takes to execute is in general orders of magnitude larger than the time it takes to execute a single wait. Performance Schema Timer Representation in Events Rows in Performance Schema tables that store current events ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-overview.html
Note For MySQL instances with a large number of objects, this view might take a long time to execute. This view summarizes the types of objects within each schema. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: NULL normalized_pattern: NULL The rule specifies a pattern template indicating which SELECT ... To ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
The table implementation uses a fixed-size, in-memory ring buffer, with old events automatically discarded as necessary to make room for new ones. row *************************** LOGGED: 2020-08-06 09:25:00.338624 THREAD_ID: 0 PRIO: System ... Of ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
The optimizer now is more complex and bases its estimate on additional factors such as table size, number of rows, and I/O block size. MySQL quickly detects that some SELECT statements are impossible and returns no rows. For each table in a join, a ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-and-mysql-replication.html
This is true whether you are using statement-based or row-based replication. It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate ...