… 1 18 6.84 9.83 2.20 7.70 # queue wait 0 0 0 0 0 0 0 0 # rec lock wai 0 0 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last errno 0 # Users…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
….1% 0.0% 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% 6.7% 0.0% 0.0% 6.7…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… 0.00 TRUNCATE TABLE poller_time # 14 0x3E84BF7C0C2A3005 0.0624 0.8% 272 0.0002 1.00 0.00 SELECT wp_postmeta # 15 0xA01053DA94ED829E 0.0567 0.7% 213 0.0003 1.00 0.00 SELECT data_template_rrd data_input_fields # 16 0xBE797E1DD5E4222F 0.0524 0.6% 79 0.0007 1.00 0…
Comment: MySQL Performance on Memory Appliance
June 19, 2008 By 23 Comments
… 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7719.43 0.88 0.00 0.00 0.00 Average: 1 0.00 0.00 0.00 0… 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Average: 7 0.00 0.00 0.00 0… PM 1 0.00 0.00 0.00 0.00 0.00 0.00 Average: 0 0.00 0.00 0.00 0.00 0.00 0.00 Average: 1 0.00 0.00 0.00 0.00 0.00 0…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…overflow:hidden;white-space:normal;letter-spacing:0;word-spacing:0;background-color:#fff;z-index:1;border-top:0px none;border-… year24.1864.2341.8811.9224.1862978935244.23355388641361.88101196289061.9195370674133.7 year27.5894.8332.2482.14327.5890979766854.83267164230352.24800109863282.1432509422302….
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com Version 5.1.43-60.hardy.7-log Server ID… Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com Version 5.1.43-60.hardy.7-log Server ID… Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com Version 5.1.43-60.hardy.7-log Server ID…
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 carrier….64 Q969.0547.67 For reference I used 5.1.36-Tokutek-2.1.0 for both MyISAM and TokuDB tests. And if…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% si Cpu1 : 0.0% us, 0.0% sy, 0.0% ni, 99.3% id, 0.7% wa, 0.0% hi, 0.0% si Cpu2 : 0.3% us, 0.0% sy, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% si Cpu3 : 0.0% us, 0.0% sy, 0.0% ni, 98.6% id, 1…
Comment: XtraDB storage engine release 1.0.3-7
August 19, 2009 By 6 Comments
….1.37-7]# rpm -U Percona-XtraDB-1.0.3-7-5.1.37-7.rhel5.x86_64.rpm file /usr/lib64/mysql/plugin/ha_innodb.so.0.0.0 from install of Percona-XtraDB-1.0.3-7-5.1.37-7.rhel5.x86_64 conflicts with file from package Percona-XtraDB-1.0.3…
Post: What is stored InnoDB buffer pool
September 28, 2008 By 8 Comments
… | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 2 | 6 | unknown | | | | | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 5 | unknown | | | | | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 4 | 6 | unknown | | | | | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 3 | inode | | | | | 4 | 0 | 4 | 0 | 0 | 0 | 0 | 6… | 0 | 0 | 7 | 17855 | index | CLUST_IND | | SYS_INDEXES | | 6 | 0 | 5 | 242 | 0 | 3 | 0 | 8 | 7 | unknown | | | | | 7 | 0 | 6 | 3006 | 0 | 0 | 0 | 9 | 6 | unknown | | | | | 8 | 0 | 45 | 0 | 0 | 0 | 0 | 10…
