Search Results
https://dev.mysql.com/doc/refman/9.7/en/keyring-plugin-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'keyring%'; +--------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +--------------+---------------+ | keyring_okv | ACTIVE | ...
https://dev.mysql.com/doc/refman/9.7/en/kill.html
If the thread is waiting for free disk space in a write call, the write is aborted with a “disk full” error message. KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers ...
https://dev.mysql.com/doc/refman/9.7/en/linux-installation-apt-repo.html
This section provides guidance on installing MySQL using the MySQL APT repository. First, add the MySQL APT repository to your system's software repository list. Follow these steps: Go to the download page for the MySQL APT repository at ...
https://dev.mysql.com/doc/refman/9.7/en/making-trace-files.html
The trace file can become very large! To generate a smaller trace file, you can use debugging options something like this: mysqld --debug=d,info,error,query,general,where:O,/tmp/mysqld.trace This only prints information with the most interesting ...
https://dev.mysql.com/doc/refman/9.7/en/memory-storage-engine.html
For information on handling each of these situations to prevent stale reads or errors, see Section 19.5.1.22, “Replication and MEMORY Tables”. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that ...
https://dev.mysql.com/doc/refman/9.7/en/merge-storage-engine.html
If you specify no INSERT_METHOD option or if you specify it with a value of NO, inserts into the MERGE table are not permitted and attempts to do so result in an error. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection ...
https://dev.mysql.com/doc/refman/9.7/en/mle-component-memory.html
You can obtain the number of out of memory errors that have been raised by MLE stored programs by checking the value of the mle_oom_errors status variable. Memory allocation and usage information for the MLE component can be obtained by checking ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-servers.html
If you use the following log file options, their values must differ for each server: --general_log_file=file_name --log-bin[=file_name] --slow_query_log_file=file_name --log-error[=file_name] For further discussion of log file options, see Section ... In some cases, you might want to run multiple instances of MySQL on a single ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-maintenance-schedule.html
The -s option (short for --silent) causes myisamchk to run in silent mode, printing messages only when errors occur. It is a good idea to perform table checks on a regular basis rather than waiting for problems to occur. One way to check and repair ...
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-memory.html
If TMPDIR points to a memory file system, out of memory errors can easily occur. myisamchk uses no more memory than its memory-related variables are set to. If you are going to use myisamchk on very large tables, you should first decide how much ...