…-servers/ is now available in our latest releases of XtraBackup 0.8.1 and XtraDB-6. Now I am going to show…/export/ xtrabackup: tables regcomp(): Success xtrabackup Ver 0.8.1rc Rev 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: uses… 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… HP ProLiant DL380 G6 with HP Smart Array RAID10 over 8 disks and ability to disable/enable write-back cache online…. The last test was done with a disabled sync_binlog=0 and without write-back cache: Threads Nofix Group Commit fix….19 33.11 2 49.35 47.32 4 87.88 86.97 8 170.42 170.58 16 332.21 331…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… all available cores/cpus in systems ( I run benchmark on 8 cores box), and it allowed to load data faster than… (1189.56 sec) 9399.965 sec Q2.3 1 hour 8 min 23.41 sec (4103.41) 19 min 52.27….977 sec Q3.3 2 hours 58 min 18.87 sec (10698.87 sec) 19 min 58.29 sec (1198.29 sec….96 sec (777.96 sec) 686.202 sec Q4.1 8 hours 53 min 52.55 sec (32032.55 sec) 32…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… (SELECT carrier,count(*) as totalflights,sum(if(depdelay>10,1,0)) as ndelayed from ontime where year=2007 group by carrier… Q3123.0466.87 Q46.926.91 Q513.6111.86 Q5i7.686.96 Q6123.8469.03 Q7187.22159.62 Q8 (1y)8.757… For reference I used 5.1.36-Tokutek-2.1.0 for both MyISAM and TokuDB tests. And if you are…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…rows affected (3 min 4.87 sec) Records: 4194304 Duplicates: 0 Warnings: 0 mysql> SHOW PROFILE; +——————————+————+ | Status | Duration | +——————————+————+ . ….: 4194304 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE t MODIFY v VARCHAR(8); Query OK, …
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 9 Comments
…: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): In general it shows stable throughput topping…/sec, but every 20 min, there is small drop to 87 MiB/sec, which I guess is related to internal garbage… getting to the peak throughput at 8 threads. And response time: For 8 threads, we may expect 0.62ms response time. In general…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
… (6 min 47.87 sec) Rows matched: 11010048 Changed: 10900996 Warnings: 0 Lets see what …SIMPLE | idxtest | ref | combined | combined | 8 | const,const | 121137 | | +—-+————-+———+——+—————+———-+———+————-+——–+——-+ 1 row in set (0.00 sec) We …
Post: Maatkit's mk-query-digest filters
March 28, 2011 By Leave a Comment
… 0 # Tmp disk tbl 381.88G 0 4.00G 136.41k 0 14.08M 0 # Tmp tbl size 255.54G 0 2.39G 91.28k 0 8.59M 0 # Query size 418.38M 6 257.39k 149.45 563.87 1.49k 42.48 # InnoDB: # IO r bytes 272.92G 0 1.58G 479.74k 0 18.19M 0 # IO r…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… default ”, `state_id` tinyint(3) unsigned NOT NULL default ‘0‘, `zip` varchar(8) NOT NULL default ”, `country_id` smallint(5) unsigned NOT NULL default ‘0‘, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`), KEY… is bad for Falcon. InnoDB is better than MyISAM by 87% in case with 4 threads but drops down very fast…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…87 sec) Records: 245760 Duplicates: 0 Warnings: 0…
