From the Administrator's perspective: Comparison between MyISAM and InnoDB In the MySQL table Engine

Question: Some problems are just common sense, but in some situations, "impatient" Administrators may ignore these common sense. Of course, this is also a mistake that many people will make. I would like to record this anecdote just now. Common MySQ

Question: Some problems are just common sense, but in some situations, "impatient" Administrators may ignore these common sense. Of course, this is also a mistake that many people will make. I would like to record this anecdote just now. Common MySQ

Question: Some problems are just common sense, but in some situations, "impatient" Administrators may ignore these common sense. Of course, this is also a mistake that many people will make. I would like to record this anecdote just now.

There are many commonly used MySQL table engines, but MyISAM and InnoDB are the most common ones. There are many good articles on the differences between the two, if you only list URLs, you will not go into details.

This article is not about this, but about another thing. If you have installed a new system in a hurry and have not backed up some of the data on the old system using a dedicated import, export, or backup tool, it may be difficult in the future. In particular, you can copy the original database files from the data directory to the data directory of the new database, fortunately, you can stop the Database Service for migration purposes. However, if you forget the engine used by tables in some of your databases, it may cause you a lot of pain, because you may have forgotten to restart the database, or it may be interesting if you are eager to demonstrate what features haven't restarted the database. Because a database can use multiple table engines at the same time, as shown in (the data in the table has been cleared ):

It is interesting that the MyISAM table can be directly used after being directly copied to the data directory, but InnoDB cannot. It may report an error message indicating that the table does not exist, deletion is not allowed. It is not until you restart the database that you can use it again.

Therefore, using MyISAM databases not only reduces the load on the database system, but also achieves this nice effect, which is quite attractive without any tools. This is also a difference between MyISAM and InnoDB.

The above questions are just common sense, but in some situations, eager administrators may ignore these common sense. Of course, this is also a mistake that many people may make. I would like to record this anecdote just now.

This article is from the "communication, my favorite" blog. Please keep this source