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.