… overview section. So say if you were using the vanilla MySQL server, you would see an entry like this in the slow… SELECT wp_terms wp_term_taxonomy # 18 0xCDFFAD848B0C1D52 0.0465 0.6% 9 0.0052 1.00 0.01 SELECT wp_posts… 0 0 0 0 0 # pages distin 2 683 2 7 4.58 6.98 1.29 4.96 # queue wait 0 0 0 0…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1 19018 19018 0 -1…Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1…1 18 6.84 9.83 2…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… Amazon cloud. It’s a quadruple extra large EC2 server (currently priced at $2/hour for a non-reserved instance) with a….1 12.2 0.0 0.0 3.5 2% 0 18.2 sdj1 0.2 0.1 10.6 0.0 0.0 3.2 2% 0 19.2 sdj1 0.2 0.1 13.4 0.0 0.0 4.2…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there… have on this server. This is because of Random I/O we had during execution of query, as MySQL used index to… 0.21 318.76 0.41 2558.35 4.95 1279.18 2.47 8.03 1.02 3.21 3.21 102.43… 0.00 318.76 0.62 2558.35 4.95 1279.18 2.47 8.03 1.02 3.21 3.21 102.49…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…(NEW.i); mysql> insert into t VALUES(1),(2),(3); Binary Log: #111213 23:16:21 server id 1 end_log_… on all servers: #111214 0:51:54 server id 1 end_log_pos 1593 Query thread_id=18 exec_time=…=1323896046/*!*/; insert into y (i,value) VALUES(4,1),(NULL,1),(NULL,1) Conclusion As we can see there are …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… online. There are two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied….96 344.57 64 60.05 633.89 128 58.18 1066.05 256 57.62 1669.11 As you may… trx=1, Binlog sync=0 trx=1, Binlog sync=1 1 382.39 371.17 381.03 2 800.89 676.39 748.53 4 1385…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… remote server you have to run MySQL server ® with XtraDB6 storage engine, you can take one of our binary builds with 5.1.36. On new server we…: 2 indexes are detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…@db1 ~]$ uname -a Linux hostname.domain 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:…2.00GHz stepping : 11 cpu MHz : 1995.022 cache size : 4096 KB physical id : 1 siblings : 4 core id : 3 cpu cores : 4… MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… good for system running mySQL Server. As far as I understand this problem is limited to EXT2/3/4 while over systems like… 22 23:18:25 2011 Last write time: Wed Aug 24 00:01:56 2011 Mount count: 2 Maximum mount count: -1 Last… is probably not needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes on this…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… with CentOS 5.2 as OS. This is quite typical server we recommend to run MySQL on. What is …_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size … remember as Linux kernels 2.6.18+ (which are used on CentOS / RedHat 5.2) are coming with CFQ …
