PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
Examples: MySQLInstallerConsole --configure --show-settings server mysqlinstallerconsole.exe --configure server:port=3307 [--]help Displays a help message with usage examples and then exits. MySQLInstallerConsole.exe provides command-line ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/en/native-pluggable-authentication.html
MySQL includes two plugins that implement native authentication; that is, authentication based on the password hashing methods in use from before the introduction of pluggable authentication. This section describes mysql_native_password, which ...
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
MySQL includes two plugins that implement native authentication; that is, authentication based on the password hashing methods in use from before the introduction of pluggable authentication. This section describes mysql_old_password, which ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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/5.7/en/partitioning-pruning.html
The core concept behind partition pruning is relatively simple, and can be described as “Do not scan partitions where there can be no matching values”. By doing so, it is possible to expend much less time and effort in finding matching rows than ...