… how of LVM and snaphots and using LVM2 >= 2.02.58 (January 2010) which is when the … lvconvert binary. Base installs of Ubuntu 11.04 (Natty) and CentOS 5.7 includes packages with this feature, … at 336797160 #120223 1:59:55 server id 1 end_log_pos 336797275 Query thread_id=47 exec_time=1 error_code=…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being done i… have been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57… log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… 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 6 min 2.21 sec So difference….70 0.62 2493.83 4.94 1246.91 2.47 8.03 1.02 3.29 3.28 102.18 Device: rrqm… 944.97 0.82 7582.75 11.50 3791.38 5.75 8.03 1.01 1.07 1.07 101.40 dm-0 0…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…230.93 Query1521.5023.611.10 Query1655.4861.421.11 Query179.009.331.04 Query18N/A1962.96N/A …451450.420.47 Query21NANANA Query22108.56100.720.93 As you can see on 100G data set MySQL 5.1 could only…queries it can execute in reasonable time frame. There 2 queries (Query8 and Query20) which MySQL 6.0 …
Post: Percona Server scalability on multi-cores server
September 29, 2010 By 14 Comments
… 270GB in total, with the underlying configuration RAID10 over eight 2.5” 15K RPM disks. To make the system even more powerful… took Percona Server 5.1.47-11.2 and ran the sysbench oltp read-only and read-write benchmarks using from 1 to 32 threads… million rows ( about 23GB of data). (Starting with Percona Server 5.1.49-12.0, we are going to provide regular builds…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… 0.5 3.1 0.0 0.4 43% 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.4 46% 0 84042.8 sda3 24.4 0.7 0.5… in_prg 1.0 sdj1 0.6 4.1 228.3 0.0 0.1 45.3 11% 0 2.0 sdj1 0.5 1.4 90…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… we chose next indexes: KEY `Year` (`Year`,`Month`), KEY `Year_2` (`Year`,`DayOfWeek`), KEY `DayOfWeek` (`DayOfWeek`,`Year`,`DepDelay`), KEY `DestCityName` (`DestCityName… FROM (SELECT carrier,count(*) as totalflights,sum(if(depdelay>10,1,0)) as ndelayed from ontime where year=2007 group by….5484.64 Q969.0547.67 For reference I used 5.1.36-Tokutek-2.1.0 for both MyISAM and TokuDB tests. And if…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… 1.35 0 # Rows read 105.76k 0 1000 5.39 9.83 32.69 0 # Bytes sent 46.63M 11 191.38k 2.38k 6.63k 11.24k 202…. # Scores: Apdex = 1.00 [1.0], V/M = 0.00 # Query_time sparkline: | .^_ | # Time range: 2011-12-28 18:42:47 to 19….18k 11.91k 3.35k 2.06k # Merge passes 0 0 0 0 0 0 0 0 # Tmp tables 10 149 1 1 1 1 0 1…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
… | 0 | 0 | 0 | 0 | 10 | 2 | undo_log | | | | | 9 | 0 | 50 | 0 | 0 | 0 | 0 | 11 | 2 | undo_log | | | | | 10 | 0… | 0 | 0 | 16 | 17855 | index | CLUST_IND | | SYS_FIELDS | | 47 | 0 | 46 | 0 | 0 | 0 | 0 | 49 | 17855 | index…is Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main idea was taken from …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied. The…-back cache: Threads Nofix Group Commit fix 1 38.19 33.11 2 49.35 47.32 4 87.88 86.97 8 170… binlog trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 59.45 468.59 33.11 21.99 2 85.15 1021.56 47.32…
