X-Gote
03-20-2003, 05:16 PM
Announced stable recently. Well I know no one gives a shit, especially Jason since he thinks I am make fun of him for liking xml more then I do.. if you are still not sold on free DB technology:
Multiple table update and delete statements
It is significantly faster - mostly in database writes
More reliable replication
A query cache (http://www.mysql.com/doc/en/Query_Cache.html) - for real speedy reads
SQL_CALC_FOUND_ROWS and FOUND_ROWS()
Improved full text indexing
InnoDB - full support for transactions and foreign keys
Ok so the biggest change is clearly InnoDB as a built in component. I found some interesting things with it though - it uses LOTS of memory and requires many processes:
No InnoDB:
root 3757 0.2 0.1 2220 1012 pts/3 S 15:02 0:00 /bin/sh bin/safe_mysqld --user=mysql --skip-innodb
mysql 3785 0.2 0.1 4280 1072 pts/3 S 15:02 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3787 0.0 0.1 4280 1072 pts/3 S 15:02 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3788 0.0 0.1 4280 1072 pts/3 S 15:02 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=
With InnoDB:
root 3835 1.5 0.1 2216 1012 pts/3 S 15:12 0:00 /bin/sh bin/safe_mysqld --user=mysql
mysql 3860 12.5 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3862 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3863 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3864 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3865 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3866 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3867 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3868 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3869 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3870 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaul
Multiple table update and delete statements
It is significantly faster - mostly in database writes
More reliable replication
A query cache (http://www.mysql.com/doc/en/Query_Cache.html) - for real speedy reads
SQL_CALC_FOUND_ROWS and FOUND_ROWS()
Improved full text indexing
InnoDB - full support for transactions and foreign keys
Ok so the biggest change is clearly InnoDB as a built in component. I found some interesting things with it though - it uses LOTS of memory and requires many processes:
No InnoDB:
root 3757 0.2 0.1 2220 1012 pts/3 S 15:02 0:00 /bin/sh bin/safe_mysqld --user=mysql --skip-innodb
mysql 3785 0.2 0.1 4280 1072 pts/3 S 15:02 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3787 0.0 0.1 4280 1072 pts/3 S 15:02 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3788 0.0 0.1 4280 1072 pts/3 S 15:02 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=
With InnoDB:
root 3835 1.5 0.1 2216 1012 pts/3 S 15:12 0:00 /bin/sh bin/safe_mysqld --user=mysql
mysql 3860 12.5 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3862 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3863 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3864 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3865 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3866 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3867 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3868 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3869 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr
mysql 3870 0.0 3.1 21860 17928 pts/3 S 15:12 0:00 /usr/local/mysql/bin/mysqld --defaul