mysql auto repair

0x001 Issue BackgroundMySQL executes the relevant MySQL command (we performed, show procedure status) When prompted Mysql.proc table crashed, cannot be repaired (marked as crashed and last (automatic?) Repair failed)Error message: MySQL table is

Introduction of Mysqlcheck The Mysqlcheck client can examine and repair the MyISAM table. It can also optimize and analyze tables. Mysqlcheck function is similar to MYISAMCHK, but its work is different. The main difference is that when the MYSQLD

There are 3 ways to fix MySQL database:1. mysql Native SQL command: RepairExecute the Repair TABLE SQL statementSyntax: REPAIR TABLE tablename[,tablename1 ...] [Options]Example: mysql> use database xxx;mysql> Repair Table *;2. Using MySQL's own

Summary of the restoration process of corrupted data in the mysql database this document is a summary of the original practice of Hewei, a master colleague. The process is really wonderful. Finally, the repair of damaged databases has achieved a

MySQL Upgrade Method Guide DaquanHttp://blog.sina.com.cn/s/blog_5a8b8eb80100ld7a.htmlIn general, when upgrading from one release version to another, we recommend that you upgrade the version in order. For example, to upgrade MySQL 3.23, upgrade to

MySQL server-side program hierarchy1.1 Connection LayerConnection Agreement: TCPIP socketVerifying connection legitimacyAssigning connection threads to client Services1.2 SQL LayerAnalyticalOptimizationAuthorization FormInquireProvide caching1.3

How does SQL Server modify the auto-increment column value and corresponding solutions? A special task encountered in today's work is to change the values of the two auto-incrementing columns.Since the SQL Server platform has previously migrated the

Instance The code is as follows Copy Code #locate Myisamchk#ln-S/usr/local/mysql/bin/myisamchk/usr/bin/myisamchk#myisamchk TableName. Myi#myisamchk-R-Q tablename If-R does not use the enforcement command as

Guide to MySQL upgrade Http://blog.sina.com.cn/s/blog_5a8b8eb80100ld7a.html We recommend that you upgrade the version from one released version to another. For example, to upgrade MySQL 3.23 to MySQL 4.0, instead of directly upgrading to MySQL 4.1

MySQL database Optimization How should we optimize the MySQL database? Next I will explain this problem from MySQL's hardware selection, MySQL installation, my. cnf optimization, MySQL architecture design, and data splitting. Optimization of server