https://dev.mysql.com/loading-tables.html
When you want to add new records one at a time, the INSERT statement is useful. Suppose that your pet records can be described as shown here. You could create a text file pet.txt containing one record per line, with values separated by tabs, and ...
https://dev.mysql.com/lock-instance-for-backup.html
WITH READ LOCK; LOCK INSTANCE FOR BACKUP; UNLOCK INSTANCE; UNLOCK TABLES; The lock_wait_timeout setting defines the amount of time that a LOCK INSTANCE FOR BACKUP statement waits to acquire a lock before giving up. LOCK INSTANCE FOR BACKUP UNLOCK ...
https://dev.mysql.com/locking-functions.html
Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error occurred (such as running out of memory or the thread was killed with mysqladmin ...
https://dev.mysql.com/locking-issues.html
External locking occurs when the server and other programs lock MyISAM table files to coordinate among themselves which program can access the tables at which time. MySQL manages contention for table contents using locking: Internal locking is ...
https://dev.mysql.com/monitoring-performance-schema.html
You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.
https://dev.mysql.com/multiple-server-clients.html
If you normally use a specific socket file or port number, you can place commands to set these environment variables in your .login file so that they apply each time you log in. Start the client with --protocol=TCP to connect using TCP/IP, ...
https://dev.mysql.com/myisam-check.html
This may take a long time for a large table that has many indexes. To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. What it cannot find is corruption that involves only the data file (which is ...
https://dev.mysql.com/myisam-key-cache.html
To make this choice easier, the key cache module maintains all used blocks in a special list (LRU chain) ordered by time of use. To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems.
https://dev.mysql.com/myisam-repair.html
Stage 1: Checking your tables Run myisamchk *.MYI or myisamchk -e *.MYI if you have more time. The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR ...
https://dev.mysql.com/myisam-start.html
If the repair fails because of an error in the data file (for example, a duplicate-key error), the server tries again, this time re-creating the data file. The following options to mysqld can be used to change the behavior of MyISAM tables.
