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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-rwlock-instances-table.html
An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access to some common resource following certain rules. The rwlock_instances table lists all the rwlock (read write lock) instances seen by ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html
UDF_LIBRARY The name of the library file containing the executable function code. The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION ...
https://dev.mysql.com/doc/refman/8.0/en/perl-installation.html
Note that when you run that command during the DBD::mysql installation to exercise the interface code, the MySQL server must be running or the test fails. MySQL Perl support requires that you have installed MySQL client programming support ...
https://dev.mysql.com/doc/refman/8.0/en/programs-development.html
Check the source code of any of the standard MySQL clients to see how to do this. This section describes some utilities that you may find useful when developing MySQL programs. In shell scripts, you can use the my_print_defaults program to parse ...