9.2.1 MySQLThis is NOT the latest copy of this book; click here for the latest version.
MySQL is the world's most popular DBMS, and is open-source, free, and very, very fast. It owes a great deal of its popularity to PHP, as when PHP 3 started to take off, the PHP developers worked very closely with the MySQL developers to make sure the two integrated very easily on the web.
MySQL achieves its incredible performance by not providing much of the enterprise-level functionality seen in other databases, but it is now working to add them in without sacrificing too much performance. MySQL 4.0 is the latest stable version of the DBMS at the time of writing, and plans are already in place for 4.1, 5.0, and 5.1, each of which are destined to add more functionality.
MySQL runs on many platforms, and is open-sourced (using the GPL licence) so you can look at, edit, and redistribute the source code if you so wish. MySQL allows you to select from a number of "table handlers" - each table can be of a different type, with MyISAM being the default. MyISAM tables are very fast for reading, but slow for writing. Another popular option is the InnoDB table handler, which are much slower, but have full support for transactions and foreign keys. If you use MyISAM, MySQL will not support transactions at all.
9.2.1.1 Advantages
9.2.1.2 Disadvantages
|
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
