…1 row in set (0.00 sec) Populated it with 75M of rows to reach 4G in size so workload will be IO bound on the box with 2GB…query to perform full table scans, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql…(which fits in OS cache): read_buffer_size impace on in memory…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql…2GB –falcon_page_cache_size=1500M –max-connections=1500 –table-cache…
