repair table

1. Why back up the database? Backup is the most important and easy to ignore for databases. Unexpected events may cause serious losses. The more important the data is, the more frequently the data changes, and the more frequently backup is

Import Database: load data infile 'd:/test.txt 'into table nmg fields terminated by', 'Lines terminated by' \ r \ n ';13.2.5. load data infile syntax load data [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE'File_name. Txt '[REPLACE | IGNORE] INTO

Avoid NULL values as much as possible It is difficult for MySql to optimize empty columns and can be replaced by 0, special value or null string. Limitations of B-TREE Indexing You can only start from the leftmost column of the index. You cannot

It's miserable to go to work on Saturday. A project on the JCS side is urgent. Let me do technical support in the past. They are too busy to stay up late. When I first arrived at the company, I found my blog could not be opened. prompt SQL

Document directory 1. mysqldump 2. mysqlhotcopy 3. SQL syntax backup 4. Enable BINLOG) 5. Back up data files directly 6. Backup Policy 7. Data Maintenance and disaster recovery 8. Summary Author/Translator: ye Jinrong (Email:); Source:

Msdn: http://msdn.microsoft.com/zh-cn/library/ms188796.aspx DBCC is a set of Console Commands provided by SQL Server. It has powerful functions and has some necessary statements, which is helpful for database operations. Therefore, we decided to

When MySQL is started, add the -- log-Slow-queries parameter to record the SQL statements whose execution time exceeds long_query_time seconds. MySQL slowThe log analysis tool mysqldumpslow.Slow log is MYSQL based on SQLThe execution time of the

The output result of the processlist command shows which threads are running. This command can be used to identify problematic query statements. 1. Enter mysqladmin processlist In the MySQL/bin directory; 2. Start MySQL and enter show

1. Call method of myisamchk Myisamchk [Options] tbl_name... Options specifies what you want myisamchk to do. It allows you to specify all tables in a directory by using the "*. myi" mode.Shell> myisamchk *. myi We recommend that you quickly

I. Summary of the causes of MyISAM Table Corruption in MySQL: 1. The data file is damaged due to a sudden power failure on the server. The MySQL service is forcibly shut down without being shut down first. The mysqld process is killed when writing a

Mysql backup data migration, error handling, mysql backup dataAll data files in/usr/lib/mysql are left behind in the project history. Previously, MyISAM engine of mysql5.1 In Debian was used. The current machine is ubuntu, and only mysql5.5 is used.

  Transactions are one of the important features of a database that distinguishes a file system. In a file system, if you are writing a file but the operating system suddenly crashes, the file may be damaged, of course, there will also be some

What I wrote today is to use Java to implement MySQL backup and recovery. The backup load method is recovery. Import java. io. File;Import java. io. IOException;Import java. io. InputStream;Import java. util. Properties;Public class JavaMysql {/****

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

The database size remains unchanged after the delete record of mysql is deleted, and mysqldelete This problem occurs when conditions are followed after the DELETE operation. Delete from table_name where Condition After the data is deleted, the

Batch kill SQL statements that run for a long time in mysql, killmysql KILL syntax KILL [CONNECTION | QUERY] thread_idEach connection to mysqld runs in an independent thread. You can use the show processlist statement to check which threads are

This blog post aims to read and understand your own books and use this picture to explain. If there are any mistakes, I hope you can correct them and share them with us for the purpose of mutual discussion. First of all, let's introduce the source

PHP and MYSQL transaction processing and PHPMYSQL Transaction Processing /*There are two main methods to process MYSQL transactions.1. Use begin, rollback, and commit to implementStart a transactionRollback transaction rollbackCommit transaction

Mind Map The most storage engines used in mysql are innodb and myisam. As the default storage engine of Mysql, myisam is worth learning. The following is my understanding of myisam mentioned in the High-Performance MYSQL. Please give me some

I watched the cacti monitoring today and found that no data was obtained yesterday. Check the log and a large number of errors occur: SQL assoc failed !, Error: '20140901 ', An error occurred while displaying the SQL Execution results, For