Geek Answers Handbook

MySQL MyISAM Data Loss Opportunities?

Many sites and script still use MySQL instead of PostgreSQL. I have several low-priority blogs and therefore I do not want to switch to another database, so I use MySQL.

Here's the problem, their on VPS with low memory. This means that I cannot enable InnoDB, since it uses about 80 MB of memory for download only. Therefore, I have to risk launching MyISAM.

With that in mind, what data loss am I viewing with MyISAM? If there was a power failure because someone was posting a blog post, would I just lose this entry or the entire database?

In these low-level boxes, I'm fine with the loss of some recent comments or blog posts until the entire database is lost.

+5
source share
6 answers

You can find the following MySQL performance article:

For me, this applies not only to table locks. Table locks are just one of the MyISAM limitations that must be considered when using it. Especially if you come from "traditional" databases, which are likely to be shocked by the behavior of MyISAM (and this is due to the behavior of MySQL by default) - it will be damaged due to inactive shutdown, it will fail to execute a partial statement if detected certain errors, etc ..

http://www.mysqlperformanceblog.com/2006/06/17/using-myisam-in-production/

+2
source

MyISAM ACID . , ... InnoDB . MyISAM, , , ? MyISAM - , MyISAM . mysqldump - . , , , , , - MyISAM.

+5

MySQL , , , , myisamchk . , .

REPAIR TABLE table;

, "". , , .

0

, 122, 123, 75912371234, 75912371235 ( 123). , , .

0

VLAN, , . , :

  • .
  • See if your host has shared hosting of any type of database in the VLAN, which you can use for a small fee.
  • Make regular backups and be prepared for the worst.
0
source

In my humble opinion, there is no data loss in MyISAM.

The risk of data loss during a power outage is explained by a power outage, and not by the database storage mechanism.

-4
source

More articles:


All Articles