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/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. Returns a JSON object containing information about a ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
Our experience shows that this kind of “educated guess” rarely misses optimal plans, and may dramatically reduce query compilation times. Because the difference in performance between “good” and “bad” plans can be orders of magnitude ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. You can use the following methods to speed up inserts: If you are inserting many rows from the ... To optimize insert speed, combine many small operations into a single large ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-component-scheduler-tasks-table.html
WAITING if the task is idle and waiting for the background thread to pick it up or waiting for the next time it needs to be run to arrive. Each row contains information about the ongoing progress of a task that applications, components, and plugins ... The component_scheduler_tasks table contains a row for each scheduled ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-examples-compression-sect.html
Compressing or uncompressing pages has consumed less than a second since the time the statistics were reset, because the columns COMPRESS_TIME and UNCOMPRESS_TIME are zero. Example 17.1 Using the Compression Information Schema Tables The following ...The following table shows the contents of INFORMATION_SCHEMA.INNODB_CMP under a light ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-fractional-seconds.html
MySQL 8.0 permits fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-pool-tables.html
In the case of tp_thread_state, all rows for a thread group comprise a snapshot in time. But it does not hold mutexes on all thread groups at the same time, to prevent a statement against tp_thread_state from blocking the entire MySQL server. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-tables-with-full-table-scans.html
The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have these columns: object_schema The schema name. latency The total wait time of full scans of the table. These views display which tables are being accessed ...
https://dev.mysql.com/doc/refman/8.0/en/windows-and-ssh.html
Create a new file in Windows and link to MySQL using the ODBC driver the same way you normally do, except type in localhost for the MySQL host server, not yourmysqlservername. This section describes how to get an encrypted connection to a remote ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
Explicitly defined transactions (with a START TRANSACTION or BEGIN statement) are subject to the timeout, disconnection, and incoming transaction blocking even if they do not modify any data. There is no default setting for the timeout, so if you do ...The current primary becomes a read-only secondary, and the specified group member becomes the read-write ... The ...