Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/memory-storage-engine.html
For information on handling each of these situations to prevent stale reads or errors, see Section 19.5.1.21, “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/8.4/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/8.4/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/8.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--recover, -r Command-Line Format --recover Do a repair that can fix almost any problem except unique keys that are not unique (which is an extremely unlikely error with MyISAM tables). --correct-checksum Command-Line Format --correct-checksum ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
If you start the MySQL server with external locking disabled, myisamchk may report an error for a table that is updated while it runs. To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from ...
https://dev.mysql.com/doc/refman/8.4/en/myisamlog.html
If a recovery is done (-r), all writes and possibly updates and deletes are done and errors are only counted. To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: myisamlog [options] [file_name ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
Previously, it read them and sent them to the server, resulting in a syntax error. The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to ...