PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/optimizing-myisam-bulk-data-loading.html
For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if there are no deleted rows in middle of the data file. Locking also lowers the total time for multiple-connection tests, although ... These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-queries-myisam.html
The first time you sort a large table this way, it may take a long time. MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-supported-components.html
To be shown in the mysql_option.option_usage and mysql_option tables, a component or plugin must be written and compiled with support for the Option Tracker. The name of the Option Tracker status variable (usage counter) associated with this ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-hash.html
You should also keep in mind that this expression is evaluated each time a row is inserted or updated (or possibly deleted); this means that very complex expressions may give rise to performance issues, particularly when performing operations (such ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-connection-attribute-tables.html
Connection attributes are key-value pairs that application programs can pass to the server at connect time. FEDERATED storage engine connections: program_name: mysqld _client_role: federated_storage Connection Attribute Limits There are limits on ...For applications based on the C API implemented by the libmysqlclient client library, the mysql_options() and mysql_options4() functions define the connection attribute ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-metadata-locks-table.html
Lock requests that have timed out and are waiting for the requesting session's lock request to be discarded. When a pending lock request times out (ER_LOCK_WAIT_TIMEOUT), its row status is updated from PENDING to TIMEOUT. The VICTIM, TIMEOUT, and ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_hosts_lost The number of times a row could ...Performance_schema_digest_lost The number of digest instances that could not be instrumented in the events_statements_summary_by_digest ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-group-stats-table.html
PRIO_KICKUPS The number of statements that have been moved from low-priority queue to high-priority queue based on the value of the thread_pool_prio_kickup_timer system variable. BECOME_CONSUMER_THREAD The number of times thread have been assigned ...The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema.html
The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. An “event” is anything the server does that takes time and has been instrumented so that timing ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
A parameter which is an operand of a temporal operator has type DATETIME if the operator returns a DATETIME, TIME if the operator returns a TIME, and DATE if the operator returns a DATE. Exceptions: The derived type is TIME and the actual type is ...