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/mysql-cluster-ndbinfo-table-info.html
The table_info table provides information about logging, checkpointing, distribution, and storage options in effect for individual NDB tables.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-history-long-table.html
The events_stages_history_long table contains the N most recent stage events that have ended globally, across all threads. Stage events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when ...The Performance Schema autosizes the value of N during server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-history-long-table.html
The events_statements_history_long table contains the N most recent statement events that have ended globally, across all threads. Statement events are not added to the table until they have ended. When the table becomes full, the oldest row is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-history-long-table.html
The events_transactions_history_long table contains the N most recent transaction events that have ended globally, across all threads. Transaction events are not added to the table until they have ended. When the table becomes full, the oldest row ...The Performance Schema autosizes the value of N is autosized at server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-history-long-table.html
The events_waits_history_long table contains N the most recent wait events that have ended globally, across all threads. Wait events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when a ...The Performance Schema autosizes the value of N during server ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
The following table shows all Performance Schema tables relating to the NDBCLUSTER storage engine. When attempting to synchronize such objects, NDB removes the object from the queue awaiting synchronization, and from this table, and tries to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-threads-table.html
row *************************** NAME: thread/sql/event_scheduler ENABLED: YES HISTORY: YES PROPERTIES: singleton VOLATILITY: 0 DOCUMENTATION: NULL The setup_threads table has these columns: NAME The instrument name. For background threads, setting ...It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create.html
Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. To create a FEDERATED table you should follow these steps: Create the table on the remote server. Create the table on the local ...The optimization occurs because the query sent to the remote server includes the contents of the WHERE clause and is sent to the remote server and subsequently executed ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. If you have UNIQUE constraints on secondary keys, you can speed up table ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
(Selecting from the view selects, in effect, using the SELECT statement.) The select_statement can select from base tables or from other views. Beginning with MySQL 8.0.19, the SELECT statement can use a VALUES statement as its source, or can be ...