The world's most popular open source database system. Available free from www.mysql.com and distributed under the GNU GPL license, MySQL powers more websites and software applications than any other open source database system.
Commonly used in combination with wordPHP for websites.
Commonly used in combination with wordPHP for websites.
by jleq July 16, 2003
A great choice of database for a very simple and small application, such as a blog or forum. A very bad database for any enterprise application, or even for educational purposes, since it is highly unstandard and will teach you bad habits (unstandard casting, implicit nonsensical casting such as strings to numbers, weak subqueries, too simple "explain" output, no schemas, case sensitivity problems, annoying but manageable unicode support, no timezone support, etc.). Instead, choose PostgreSQL for professional or other large tasks.
MySQL is the fastest free open source database when you are NOT using transactions (using myisam engine) (which is why it is so great for blogs). But when you are using transactions (using innodb engine) (which any enterprise application must always use) it is VERY slow.
A properly optimized query written by a master or that you spent days writing might be fastest in Oracle, but in all other cases, PostgreSQL beats both Oracle and MySQL (innodb).
MySQL is the fastest free open source database when you are NOT using transactions (using myisam engine) (which is why it is so great for blogs). But when you are using transactions (using innodb engine) (which any enterprise application must always use) it is VERY slow.
A properly optimized query written by a master or that you spent days writing might be fastest in Oracle, but in all other cases, PostgreSQL beats both Oracle and MySQL (innodb).
"My blog server goes so fast since I started using MySQL's myisam engine."
"MySQL's lack of time zone support is such a pain in the ass."
"MySQL is still running crash recovery, since 2 weeks ago (due to a known bug.... uh 'feature request' according to their developers, where it uses a primitive and ultra slow bubble sort to sort the transactions) . I wonder if my business will ever be up and running again."
"MySQL's lack of time zone support is such a pain in the ass."
"MySQL is still running crash recovery, since 2 weeks ago (due to a known bug.... uh 'feature request' according to their developers, where it uses a primitive and ultra slow bubble sort to sort the transactions) . I wonder if my business will ever be up and running again."
by peetaur March 1, 2010
by somebody, someone April 6, 2008
by LRS May 17, 2004
by Mydaho June 25, 2021
by Mydaho June 25, 2021