… 5.1 and 6.0 in cold mode (I dropped OS caches by `echo 1 > /proc/sys/vm/drop_caches` and restarting mysqld) 5.1 – time 1 hour 14 min 36.90 sec 6.0 – time 1 hour… svctm %util sda 16.22 1.23 534.29 1.85 132547.02 24.64 66273.51 12.32 247.27 0.30… svctm %util sda 16.02 0.20 526.77 1.01 130724.54 9.74 65362.27 4.87 247.70 0…
Post: Percona Server 5.1.54-12.5
January 11, 2011 By 9 Comments
… version 5.1.54-12.5 is now available for download. It is now the current stable release version. Functionality Added or Changed Percona Server 5.1.54-12.5 is based on MySQL 5.1.54. New Features Added: None Other Changes: Added system…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… 1 and 3 and lo_quantity < 25\G *************************** 1. row *************************** revenue: 446268068091 1 row in set (22.54… | 12 | Sending data | 33.764396 | 7.523023 | 40.173893 | 13.027019 | 4979 | 21399 | 0 | 0 | 90 | 90 | | 5…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
….5484.64 Q969.0547.67 For reference I used 5.1.36-Tokutek-2.1.0 for both MyISAM and TokuDB tests. And….746.768.13 Q8 (2y)102.171.13.6828.8216.54 Q8 (3y)104.71.695.4435.3724.46 Q8 (4y….5429.1417.4272.6770.35 Q969.056.30.3176.129.54 The all results are available in summary Spreadsheet I especially…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… sda3 32.6 1.1 0.5 2.7 0.0 0.4 54% 0 60032.9 sda3 30.0 1.0 0.5 3.0…% 1 72040.6 sda3 25.5 2.7 1.6 3.8 0.2 1.5 47% 1 78041.7 sda3 25.5 1.2 0.7 4.5 0.1 0… 0.5 1.4 90.8 0.0 0.0 4.0 25% 0 3.0 sdj1 0.6 0.2 12.3… 4% 0 12.1 sdj1 0.5 0.1 4.4 0.0 0.0 1.8 3% 0 13.1 sdj1 0.7 5.1 235.2…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…% 11.1% 0.1% 1.1% 6.1% 59.1% cpu01 14.9% 0.0% 7.5% 0.0% 0.0% 5.9% 71.5% cpu02 10.5% 0.0% 12.5% 0.0% 0.1% 7.1% 69.5% cpu03 12.7% 0… 0.08 0.54 0.32 8148218 4819040 cciss/c0d0p9 0.00 0.00 0.00 248 0 # vmstat 5 2 procs…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
…| 17855 | index | CLUST_IND | | SYS_COLUMNS | | 13 | 0 | 9 | 12 | 354 | 0 | 0 | 15 | 17855 | index | ID_IND | …| 55 | 17855 | index | CLUST_IND | | SYS_IBUF_TABLE_0 | | 54 | 0 | 54 | 55 | 6313 | 0 | 0 | 56 | 17855 | index … Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main idea was taken from …
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…: 8.13 sec 2y: 16.54 sec 3y: 24.46 sec 4y: 32.49 sec 10y: 1 min 10.35 sec Query…)0.551.746.768.13 Q8 (2y)1.13.6828.8216.54 Q8 (3y)1.695.4435.3724.46 Q8 (4y)2.127….3176.129.54 Conclusions InfiniDB server version shows Server version: 5.1.39-community InfiniDB Community Edition 0.9.4.0-5-alpha (GPL…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… writes. The issue is fixed only in Percona server 5.5.17-22.1. AUTO INCREMENTAL VALUES In order to have the same… incremental column: 1,2,3,5 Then we execute the following: insert into y (i,value) VALUES(4,1),(NULL,1),(NULL,1); Binary Log… INSERT_ID=6/*!*/; #111214 21:54:06 server id 1 end_log_pos 319 Query thread_id=12 exec_time=0 SET TIMESTAMP…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… 4.8 668.1 1042.5 54.1 | 30.0 5.2 660.9 1048.3 64.6 164.8 | 131.8 1.8 608.0….5 448.2 647.6 45.3 | 43.9 0.1 439.5 623.6 47.1 256.9 | 204.2 5.1 390.9 521.1 42.9 | 52.7 0.2 383.4 505.7 43.1 295… 319.0 503.5 60.2 | 62.1 12.8 322.3 496.6 59.9 300.5 | 239.7 4.1 331.4 1207…
