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-wait-summary-tables.html
The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section 29.12.4, “Performance Schema Wait Event Tables” describes the events on which wait summaries are ...Example wait event summary information: mysql> SELECT * FROM performance_schema.events_waits_summary_global_by_event_name\G ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning-monitoring.html
This section builds on the performance tuning advice from Section 17.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/8.0/en/fulltext-fine-tuning.html
To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE with the DROP INDEX and ADD INDEX options to drop and re-create each index. To rebuild the FULLTEXT indexes for a MyISAM table, it is sufficient to do a QUICK repair operation: mysql> ...Do not alter the MySQL sources unless you know what you are ...You can exert more control over full-text searching behavior if you have a MySQL source ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-myisam-bulk-data-loading.html
For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if there are no deleted rows in middle of the data file. With some extra work, it is possible to make LOAD DATA run even faster for a ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-extensions-table.html
The TABLE_CONSTRAINTS_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table constraint attributes defined for primary and secondary storage engines. The TABLE_CONSTRAINTS_EXTENSIONS table has these columns: ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-table-usage-table.html
The VIEW_TABLE_USAGE table (available as of MySQL 8.0.13) provides access to information about tables and views used in view definitions. You can see information only for views for which you have some privilege, and only for tables for which you ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-remarks.html
The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are distributed across all data nodes, including the new ones, by means of the ALTER TABLE ... However, it is not possible to perform ...Table reorganization of both in-memory and Disk Data tables is ... This section provides general information about the ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. The name of ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...