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/optimization.html
Sometimes you can be proactive and plan in advance for performance, while other times you might troubleshoot a configuration or code issue after a problem occurs. This chapter explains how to optimize MySQL performance and provides examples.
https://dev.mysql.com/doc/refman/8.0/en/optimize-numeric.html
You also save code in your application because you can avoid parsing the text file to find line and column boundaries. For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string columns.
https://dev.mysql.com/doc/refman/8.0/en/optimize-overview.html
The InnoDB storage engine handles most locking issues without involvement from you, allowing for better concurrency in the database and reducing the amount of experimentation and tuning for your code. Database performance depends on several factors ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
row *************************** Level: Warning Code: 4537 Message: Variable 'collation_server' cannot be set using SET_VAR hint. One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
This is a straightforward technique that can improve performance when other techniques such as improving index usage or tuning application code are not practical. Once your data reaches a stable size, or a growing table has increased by tens or ...
https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-cond-instances-table.html
A condition is a synchronization mechanism used in the code to signal that a specific event has happened, so that a thread waiting for this condition can resume work. The cond_instances table lists all the conditions seen by the Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-configurations.html
If you do not need the information provided by enabling lower-level settings, disable them so that the Performance Schema executes less code on your behalf and there is less information to sift through. The consumer settings in the setup_consumers ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-examples.html
Tune the code (this applies to storage engine or server developers only). The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-performance-timers-table.html
The timer code is called only for timed events, so this overhead does not apply for nontimed events. For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event Timing”. For a cycle timer, the frequency is ...