Personal tools
You are here: Home User Contributed Files Introduction to MySQL What MySQL lacks
Document Actions

What MySQL lacks

by Tracy R Reed last modified 2005-05-02 16:48

  • Still not a full SQL implementation
  • Views, virtual tables
  • Just added subselects in 4.1 (most recent version)
  • Transactions in 4.0
  • Stored procedures and triggers coming in 5.0
    • More features means less performance
    • New procedural programming language
    • Some say just put the logic in the apps
  • Currently has multiple table types with different styles of locking
    • table locking for ISAM/MyISAM and HEAP tables
    • page-level locking for BDB table
    • row-level locking for InnoDB table
  • Replication still kludgy - pipes around transaction logs
  • No clustering

-NEXT-> MySQL tools


Powered by Plone CMS, the Open Source Content Management System

This site conforms to the following standards: