Hi and I have a mysql table that gets a few million records inserted per day and it seems to get corrupted very often. The current database structure is myisam but it keeps on getting corrupted. Are there any mysql data structures that won't corrupt even when restarting the mysql service while a record is being inserted? BTW I only need to insert and select records and needs to be fast at selecting from the database too. Please help. Thanks.
cwarn23 387
Occupation: Genius Team Colleague Featured Poster
Recommended Answers
Jump to PostI like InnoDB. Use it to contain several booking websites' data. It got very large, although not millions per day. Never had any corrupt data issues.
With databases with these sizes I prefer to switch to postgres, oracle or mssql (depending on the customer of course).
Jump to PostIf you're looking to avoid row corruption you'll definitely want to look into atomic transactions http://dev.mysql.com/doc/refman/5.5/en/ansi-diff-transactions.html
But the issue still remains if you restart mysql while updates are still running there's really nothing you can do, you killed the thread it can't recover if it doesn't …
All 6 Replies
pritaeas 2,194
¯\_(ツ)_/¯ Moderator Featured Poster
ShawnCplus 456
Code Monkey Team Colleague
cwarn23 387
Occupation: Genius Team Colleague Featured Poster
logonchristy 0
Light Poster
ShawnCplus 456
Code Monkey Team Colleague
cwarn23 387
Occupation: Genius Team Colleague Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.