… 0 1.35 0 # Rows read 105.76k 0 1000 5.39 9.83 32.69 0 # Bytes sent 46.63M 11 191… # 7 0x7AEDF19FDD3A33F1 0.1381 1.7% 909 0.0002 1.00 0.00 SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00… 0 0 0 # pages distin 40 11.77k 34 44 38.62 38.53 1.87 38.53 # queue wait 0 0 0 0…/84%), wp_blog_tw… (36/11%)… 1 more # Hosts # InnoDB trxID 86B40B (1/0%), 86B430 (1/0%), 86B44A (1/0%)… 309 more # Last errno 0…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… 11%. However if we run the same side load on DPE2 we get: Summary: 5349 out of 10000 rounds (53….; Max: 519.61 ms Avg: 5.02 ms Summary: 5355 out of 10000 rounds (53.55%) Delay distribution: Min: 0… XtraDB Cluster (GPL), wsrep_23.7.2.r3843 wsrep_node_address=10.9.9.1 wsrep_provider=/usr/lib/libgalera_…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…5303 correspond to 3.47 seconds of user time and 53.03 system time consumed by the process. Collecting these at…31 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes 0 0 0…to do 2592000000 IOPS per month and (using our 0.7 factor) we have 6480000000 queries such system can run …
Post: Intel 320 SSD read performance
July 29, 2011 By 11 Comments
… RAID/Intel 320 strip 1 0.53 0.56 6.13 11.57 10.95 2 0.72 0.59 7.27 10.10 12.32 4 0.89 0.74 10.07 11.31 13.61 8 1.24 0.95 15.63 12.60 16.45 16 1.76 1.38 25…, this card provides great read performance. A single card provides 5-8x better throughput and 10-14x better response time. Striping…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… it is know to have good decompression speed even with 1 thread. UPDATE 17-Mar-2009: I added lzma results also… support it and different level of compression ( 1,2,3 for qpress; -1 and -5 for other tools) The raw results are available… I skipped it In my opinion in all cases Level 1 of compression shows better tradeoff between size of archive and…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… extension and with innodb_expand_import=1 setting) 4) run alter table IMPORTEDTABLE discard tablespace; 5) copy .exp and .ibd files to destination server 6) run alter table IMPORTEDTABLE import tablespace; 7) enjoy progress… indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 10 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… 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63… log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
Comment: Analyzing air traffic performance with InfoBright and MonetDB
November 28, 2009 By 50 Comments
…1-4) Month TINYINT NOT NULL, — 3 Month DayofMonth TINYINT NOT NULL, — 4 Day of Month DayOfWeek TINYINT NOT NULL, — 5…2) NOT NULL COMMENT ‘LOOKUP’, — 7 Unique Carrier Code…Number FlightNum SMALLINT NOT NULL, — 11 Flight Number Origin CHAR(3…Minutes NASDelay DECIMAL(6,2), — 53 NAS Delay, in Minutes…
