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/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/selecting-all.html
Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the record in question and does not require you to reload the table. For example, you may happen to ...
https://dev.mysql.com/doc/refman/8.0/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/8.0/en/compiling-for-debugging.html
In this case, you can try to add -g using the CMAKE_C_FLAGS and CMAKE_CXX_FLAGS CMake options and not use -DWITH_DEBUG=1. If they find something “unexpected,” an entry is written to stderr, which mysqld_safe directs to the error log! This also ... If you have some very specific problem, you can always try to debug ...