MySQL's Strengths -- and Weaknesses

The speed of MySQL, according to your article ["MySQL Breaks Into the Data Center," QuickLink 41750], is due to its simplicity -- one file for schema, one file for data, one file for index. This also reveals its weakness -- no separate transaction log, no separate rollback log, no file duplication. All your eggs in one basket. For those for whom low cost and high speed are more important than security, integrity, availability and recovery, MySQL looks good. For those for whom it is not, a slower, more complex, safer DBMS is required.

David P. Vernon

Senior technical solution specialist

IBM Life Sciences

Tucson, Ariz.

dvernon@us.ibm.com

To express your thoughts on Computerworld content, visit Computerworld's Facebook page, LinkedIn page and Twitter stream.
Windows 10 annoyances and solutions
Shop Tech Products at Amazon
Notice to our Readers
We're now using social media to take your comments and feedback. Learn more about this here.