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.

To express your thoughts on Computerworld content, visit Computerworld's Facebook page, LinkedIn page and Twitter stream.
Fix Windows 10 problems with these free Microsoft tools
Shop Tech Products at Amazon