PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables. Section 29.12.6, “Performance Schema Statement Event Tables” describes the events on which statement ...Example statement event summary information: mysql> SELECT * FROM performance_schema.events_statements_summary_global_by_event_name\G *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
The row format of a table can also be defined explicitly using the ROW_FORMAT table option in a CREATE TABLE or ALTER TABLE statement. If you create the table, load data, and then run ALTER TABLE to add a primary key later, that operation is much ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...Note ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...The THREAD_ID and EVENT_ID values taken together uniquely identify the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
These rules also apply to existing nonpartitioned tables that you wish to partition using ALTER TABLE ... The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must ... This section discusses the relationship of partitioning keys with primary keys and unique ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. As of MySQL 8.0.14, a derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-example.html
In addition, for each table, the ALTER TABLE statement should be followed by an OPTIMIZE TABLE to reclaim wasted space. However, in NDBCLUSTER tables that existed prior to the addition of the new nodes, neither existing nor new data is distributed ...You can verify that all existing data nodes were restarted using the updated configuration by checking the ndbinfo.nodes table in the mysql ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
As of MySQL 8.0.22, depending on error log configuration, the server can also write the most recent error events to the Performance Schema error_log table. Granting the SELECT privilege for the error_log table thus gives clients and applications ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dictionary-tables.html
dictionary_tables contains the columns listed here: table_id The table' unique ID database_name Name of the database containing the table table_name Name of the table status The table status; one of New, Changed, Retrieved, Invalid, or Altered.