…described here Used hardware CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel…RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5…_memory=1G –falcon_max_record_memory=2GB –falcon_page_cache_size=1500M –max-…
Post: JOIN Performance & Charsets
October 21, 2008 By 2 Comments
… index 2 rows in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1003 Message: select… index 2 rows in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1003 Message: select… time, from 4.33 to 3.12 seconds. This test was performed with MySQL 5.0.67, FreeBSD 7, on a box with 2GB RAM.
