Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
--debug-info Command-Line Format --debug-info Type Boolean Default Value FALSE Print debugging information and memory and CPU usage statistics when the program exits. The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlimport.html
--debug-info Command-Line Format --debug-info Type Boolean Default Value FALSE Print debugging information and memory and CPU usage statistics when the program exits. The mysqlimport client provides a command-line interface to the LOAD DATA SQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlshow.html
--debug-info Command-Line Format --debug-info Type Boolean Default Value FALSE Print debugging information and memory and CPU usage statistics when the program exits. The mysqlshow client can be used to quickly see which databases exist, their ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
--debug-info, -T Command-Line Format --debug-info Type Boolean Default Value FALSE Print debugging information and memory and CPU usage statistics when the program exits. mysqlslap is a diagnostic program designed to emulate client load for a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
MySQL includes a mysql_native_password plugin that implements native authentication; that is, authentication based on the password hashing method in use from before the introduction of pluggable authentication. Note The mysql_native_password ...
https://dev.mysql.com/doc/refman/8.4/en/optimization.html
Optimizing CPU and memory usage can also improve scalability, allowing the database to handle more load without slowing down. This chapter explains how to optimize MySQL performance and provides examples. Depending on your job role (developer, DBA, ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-character.html
Such compact tables reduce disk I/O and memory usage for common queries. For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-diskio.html
If the Unix top tool or the Windows Task Manager shows that the CPU usage percentage with your workload is less than 70%, your workload is probably disk-bound. If you follow best practices for database design and tuning techniques for SQL ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/performance-schema-user-defined-functions-table.html
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 statement. For information about operations that add or remove table rows, see Section ...