PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/myisam-crash-recovery.html
When performing crash recovery, it is important to understand that each MyISAM table tbl_name in a database corresponds to the three files in the database directory shown in the following table. This section describes how to check for and deal with ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-maintenance-schedule.html
For example, you can run a cron job to check important tables once a week, using a line like this in a crontab file: 35 0 * * 0 /path/to/myisamchk --fast --silent /path/to/datadir/*/*.MYI This prints out information about crashed tables so that you ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
You want to retain a copy in case something goes wrong.) Important If you are using replication, you should stop it prior to performing the above procedure, since it involves file system operations, and these are not logged by MySQL. The discussion ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-memory.html
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 memory you want it to use. The default is to use only about 3MB to perform repairs.
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
myisamchk -eis tbl_name Shows only the most important information from a table. To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section.
https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html
Important You must ensure that no other program is using the tables while you are running myisamchk. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-calendar.html
It is important to realize that the cutover did not occur at the same time in all countries, and that the later it happened, the more days were lost. MySQL uses what is known as a proleptic Gregorian calendar. Every country that has switched from ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-troubleshooting.html
Important If you have set BackupDataBufferSize and BackupLogBufferSize and their sum is greater than 4MB, then you must also set BackupMemory as well. If an error code is returned when issuing a backup request, the most likely cause is insufficient ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-basics.html
Important It is not realistic to expect to employ a three-node setup in a production environment. NDBCLUSTER (also known as NDB) is an in-memory storage engine offering high-availability and data-persistence features. The NDBCLUSTER storage engine ...