… out I’ve created table with simple structure: mysql> show create table dt2 \G *************************** 1. row *************************** Table: dt2 Create Table: CREATE TABLE… on the box with 2GB of memory. The was running Fedora Core i686 had 2 Xeon CPUs and 2 drives in… averaged results. MySQL 5.1.21-beta was used for tests. mysql> select count(*) from dt2 where slack like “a%”; +———-+ | count(*) | +———-+ | 4705992 | +———-+ 1 row in…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… : 3192.222 cache size : 8192 KB 32GB of RAM Fedora Core release 5 (Bordeaux) 2 Ñ… Dual Core AMD Opteron cpu family… KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1…
Comment: Slow Query Log analyzes tools
November 19, 2008 By 83 Comments
Hello, The function of mysql slow log filter is more attractive,so I just installed Fedora 9 and MySQL 5.1.29. Unfortunately, I am newbie… download the mysql_slow_log_filter file and issue the command “tail -f mysql-slow.log | mysql_slow_log_filter -T 0.5 -R 1000″, the result is always “bash: mysql_slow_log_filter…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… MySQL 5.0.45 on 32bit Fedora …1 | 68d91f476ff40116c9c9ba0b85037496ededa1ef | | 2 | 9bc66fb6426222e3a94c43a64ed701cf197f8cb8 | | 1 | 9c2a671310c810e1f4a9aa4763ce5e76d28e3af4 | | 1 | 2e282a3aeb832b8b5861f703041acba5a4285a35 | +—–+——————————————+ 10 rows in set (9 min 5…
