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/optimizer-features-to-trace.html
They are: Greedy search: With an N-table join, this could explore factorial(N) plans. Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. Range ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-tracing-typical-usage.html
To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 10.15.3, “Traceable Statements”, for a listing of statements which can be traced. To examine traces for multiple ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-tracing.html
The MySQL optimizer includes the capability to perform tracing; the interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table.
https://dev.mysql.com/doc/refman/8.0/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Preventing one-time operations such as table scans from interfering ...Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance ...
https://dev.mysql.com/doc/refman/8.0/en/option-modifiers.html
For example, --maximum-max_heap_table_size=32M prevents any client from making the heap table size limit larger than 32M. Some options are “boolean” and control behavior that can be turned on or off. For example, the mysql client supports a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-and-plugins.html
The associated event information, including aggregate information, remains readable in performance_schema database tables. Removing a plugin with UNINSTALL PLUGIN does not affect information already collected for code in that plugin. Time spent ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-option-variable-reference.html
Table 29.18 Performance Schema Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic performance_schema Yes Yes Yes Global No Performance_schema_accounts_lost Yes Global No performance_schema_accounts_size Yes Yes Yes ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-options.html
Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within the name are equivalent. Performance Schema parameters can be specified at server startup on the command line or in option ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage-common-layer.html
Physical Storage: This involves everything from the overall page size for tables and indexes as well as the format used for storing data to physical disk. A MySQL pluggable storage engine is the component in the MySQL database server that is ...