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/myisamchk-other-options.html
(The first time you use this option to sort a table, it may be very slow.) To determine a table's index numbers, use SHOW INDEX, which displays a table's indexes in the same order that myisamchk sees them. myisamchk supports the following options ...
https://dev.mysql.com/doc/refman/8.0/en/myisamlog.html
This option can be given multiple times to produce more and more output. To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: myisamlog [options] [file_name [tbl_name] ...] The default operation is ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-features-to-trace.html
Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. They are: Greedy search: With an N-table join, this could explore factorial(N) plans. Range ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
You may find that there are significant gains for some and not for others, or that the gains decrease over time until you next optimize the table. Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-and-plugins.html
Time spent executing the code while the plugin was loaded was still spent even if the plugin is unloaded later. Removing a plugin with UNINSTALL PLUGIN does not affect information already collected for code in that plugin. The associated event ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-binary-log-transaction-compression-stats-table.html
The statistics cover all transactions written to the binary log and relay log from the time the server was started or the table was truncated. FIRST_TRANSACTION_TIMESTAMP The timestamp when the first transaction was written to the log. This table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-file-instances-table.html
If a file was opened and then closed, it was opened 1 time, but OPEN_COUNT is 0. The file_instances table lists all the files seen by the Performance Schema when executing file I/O instrumentation. If a file on disk has never been opened, it is not ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-obtaining-parent-events.html
If a statement that executed a long time ago took a lock but is in a still-open transaction, it might not be possible to find the statement, but it is possible to find the transaction. Rows of this table have a THREAD_ID column indicating the thread ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-filters-table.html
COUNTER The number of times the replication filter has been used since it was configured. This table shows the replication channel specific filters configured on this replica. Each row provides information on a replication channel's configured type ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-coordinator-table.html
The start timestamp refers to when this thread read the first event of the transaction from the relay log to buffer it to a worker’s queue, while the end timestamp refers to when the last event finished buffering to the worker’s queue. For a ...