Search Results
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
The resulting fast database operations are then available to be reused by other queries, applications, and even code written in different programming languages. To avoid slowing down the source while making backups, you can make backups using a ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
If a big transaction is slowing down server performance, rolling it back can make the problem worse, potentially taking several times as long to perform as the original data change operations. When a long-running transaction modifies a table, ... To ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. A SELECT statement that takes a long ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/8.4/en/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/doc/refman/8.4/en/unix-signal-response.html
SIGUSR1 causes the server to flush the error log, general query log, and slow query log. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process.
https://dev.mysql.com/doc/internals/en/caching.html
(Note that the some of the filenames contain an incorrect spelling of the word “cache.”) Key Cache A shared cache for all B-tree index blocks in the different NISAM files. Uses hashing and reverse linked lists for quick caching of the most ...
https://dev.mysql.com/doc/mysql-installer/en/server-logging-options.html
Advanced configuration options are related to the following MySQL log files: Error Log General Log Slow Query Log Bin Log Note The binary log is enabled by default. This step is available if the Show Advanced Configuration check box was selected ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-5-7.html
This section provides information about keywords and reserved words in MySQL 5.7. MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-0.html
This section provides information about keywords and reserved words in MySQL 8.0. MySQL 8.0 Keywords and Reserved Words MySQL 8.0 New Keywords and Reserved Words MySQL 8.0 Removed Keywords and Reserved Words MySQL 8.0 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-4.html
This section provides information about keywords and reserved words in MySQL 8.4. MySQL 8.4 Keywords and Reserved Words MySQL 8.4 New Keywords and Reserved Words MySQL 8.4 Removed Keywords and Reserved Words MySQL 8.4 Keywords and Reserved Words ...