… Percona Server 5.1.58-12.9 on August 12, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.58, including all the bug fixes in it, Percona Server 5.1.58-12.9 is now the current stable release in the 5.1 series… the details of the release can be found in the 5.1.58-12.9 milestone at Launchpad. Highlights Performance Improvements fsync() has been replaced…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… I used MySQL 5.5.7rc on a powerful Cisco UCS server with 12 real cores and…worker32 workerNo Shard-Query16 worker24 worker32 worker.1 year4.5481.0440.8540.8524.5484452247621….6122.4472.49632.1476650238045.61204981803892.44708514213562.4959940910339.9 year35.9046.2052.8482.73935.9037091732036….
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
… 14 | 17855 | index | CLUST_IND | | SYS_COLUMNS | | 13 | 0 | 9 | 12 | 354 | 0 | 0 | 15 | 17855 | index | ID_IND | … 0 | 0 | 0 | 59 | 4 | ibuf_free_list | | | | | 58 | 0 | 58 | 928 | 0 | 0 | 0 | 60 | 4 | ibuf_free_list | | | …Jeremy Cole’s patch for InnoDB plugin MySQL 5.1, and main idea was taken from…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… 4.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….4 | 58.9 0.1 330.5 461.9 46.4 350.3 | 279.4 5.0 287.5 419.8 43.2 | 70.9 0.1 277.6….2 4.9 319.0 503.5 60.2 | 62.1 12.8 322.3 496.6 59.9 300.5 | 239.7 4.1 331.4…
Post: Air traffic queries in MyISAM and Tokutek (TokuDB)
November 5, 2009 By 26 Comments
… 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…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…: scanned up to log sequence number 3 845737724 (99 %) InnoDB: 12 transaction(s) which must be rolled back or cleaned up… engine, you can take one of our binary builds with 5.1.36. On new server we run set global innodb_expand… indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68…
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…. InnoDB: Import: 9 indexes have been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15… 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… table with simple structure: mysql> show create table dt2 \G *************************** 1. row *************************** Table: dt2 Create Table: CREATE TABLE `dt2` ( `grp` int… full table scans, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select count(*) from…)82004.1516K4.1532K4.1264K4.11128K4.11256K4.12512K4.252M4.498M4.5432M4.58 As you see the difference in percents is smaller with…
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… indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68… – you just need to shutdown instance with innodb_fast_shutdown=1 (done in xtrabackup –prepare –export call). The more complex problem…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… 48us 119us 134us 36us # Rows sent 105.76k 0 1000 5.39 9.83 32.69 0 # Rows examine 539.46k 0…_taxonomy # 12 0x30DA85C940E0D491 0.0835 1.0% 542 0.0002 1.00 0.00 SELECT wp_posts # 13 0x8A52FE35D340A347 0.0767 0.9% 4… # Tmp tables 10 149 1 1 1 1 0 1 # Tmp disk tbl 30 149 1 1 1 1 0 1 # Tmp tbl size 16 12.00M 0 287.72k 82… 0 0 # pages distin 2 683 2 7 4.58 6.98 1.29 4.96 # queue wait 0 0 0 0…
