June 18, 2013

Post: Death match! EBS versus SSD price, performance, and QoS

February 21, 2011 By 55 Comments

… 0.5 0.1 5.8 0.0 0.0 1.0 4% 2 15.1 sdj1 0.0 0.0 0.0 1.6 1.2 12.7 15% 0 16.1 sdj1 0.3 0.2 16.2 0.0 0.0 5.5 3% 0….1 0.0 0.0 3.7 2% 0 21.2 sdj1 0.2 0.1 10.2 0.0 0.0 2.5 2% 0 22.2 sdj1 0.4 0.3 19.1 0.0 0.0 1.0…

Filed Under: Cloud and NoSQL, Hardware and Storage, MySQL

Comment: MySQL Performance on Memory Appliance

June 19, 2008 By 23 Comments

….75 0.00 12.63 0.92 0.00 62.70 Average: all 27.15 0.00 16.21 1.44 0.00 55.21 Average: 0 38.58 0.00 22.03 1.28 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: 5 0.00 0.00 0.00 0…

Filed Under: Benchmarks Tagged With: , ,

Post: Identifying the load with the help of pt-query-digest and Percona Server

December 29, 2011 By 3 Comments

… 0 15.65k 27.52 34.95 312.56 0 # Rows affecte 1.34k 0 65 0.07 0 1.35 0 # Rows read 105.76k 0 1000 5… 0 0 0 0 0 0 0 0 # Tmp tables 0 0 0 0 0 0 0 0 # Tmp disk tbl 0 0 0 0 0 0 0 0 # Tmp tbl size 0 0 0 0 0 0 0 0 # Query size 0 21.63k 71 71 71 71 0 71 # InnoDB: # IO r bytes 0 0 0 0 0 0 0 0 # IO r ops 0 0 0 0 0 0 0 0 # IO r wait 0 0 0 0 0 0 0 0 # pages…

Filed Under: Insight for DBAs, MySQL

Post: Percona Server 5.5.15 + Galera 21.1-beta2

October 3, 2011 By 18 Comments

…/TESTING/Galera/Percona-XtraDB-Galera-5.5.15.tar.gz What difference between Percona Server+Galera and MySQL 5.5.15 ? First of course, Percona Server….google.com/js/plusone.js’; var s = document.getElementsByTagName(‘script’)[0]; s.parentNode.insertBefore(po, s); })(); mbgc=’f5f5f5′;ww=’320′;mbc…

Filed Under: Insight for DBAs, MySQL, Percona Software

Post: Percona Server 5.5.15-21.0

August 31, 2011 By 10 Comments

… Percona Server 5.5.15-21.0 on August 31, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.15, including all the bug fixes in it, Percona Server 5.5.15-21.0 is now the current stable release in the 5.5 series… can be found in the 5.5.15-21.0 milestone at Launchpad. Improvements Improved MEMORY Storage Engine As of MySQL 5.5.15, a Fixed Row Format…

Filed Under: MySQL, Percona Software

Post: MySQL 6.0 vs 5.1 in TPC-H queries

March 25, 2008 By 17 Comments

… restarting mysqld) 5.1 – time 1 hour 14 min 36.90 sec 6.0 – time 1 hour 6 min 2.21 sec So… 15.78 0.20 524.39 0.41 130224.59 4.92 65112.30 2.46 248.15 0.30 0.56 0.56 29.61 dm-0 0.00 0.00 540.37 0.61 130224.59 4.92…

Filed Under: Benchmarks Tagged With:

Post: Optimizing slow web pages with mk-query-digest

April 7, 2011 By 14 Comments

…0 0 0 0 0 0 0 0 # Tmp tables 0 15 0 1 0.03 0 0.17 0 # Tmp disk tbl 0 3 0 1 0.01 0 0.08 0 # Tmp tbl size 0 4.78k 0…0 0 0 0 0 0 0 0 # rec lock wai 0 0 0 0 0 0 0 0 # Boolean: # Filesort 0% yes, 99% no # Full scan 7% yes, 92% no # QC Hit 78% yes, 21…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , ,

Post: Statement based replication with Stored Functions, Triggers and Events

December 16, 2011 By 4 Comments

…writes. The issue is fixed only in Percona server 5.5.17-22.1. AUTO INCREMENTAL VALUES In order to…end_log_pos 1382 Query thread_id=15 exec_time=0 error_code=0 SET TIMESTAMP=1323817490/*!*/; INSERT INTO y (value)…INSERT_ID is the next auto incremental value: #111214 21:54:06 server id 1 end_log_pos …

Filed Under: MySQL

Post: Shard-Query adds parallelism to queries

November 15, 2010 By 18 Comments

…, both Percona Server and MySQL 5.5.7rc have numerous performance …sans-serif;font-size:100.0%;font-weight:normal;font-…2458.1987349987039.58619904518134.30126380920414.240373134613.15 year59.21110.0974.3684….70486.62519168853814.2979900836945.74865603446965.7037448883057.21 year89.09114.7386.086….

Filed Under: Insight for Developers, MySQL Tagged With: , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… Checks | 21.23662567138672 | | 66 | Michigan Free Public Records, Criminal Records And Background checks | 5.363710880279541 | |…< 0.5 * 7150, so none of these should be treated as stopwords in MyISAM. With 5.5: mysql…this particular query, “James R Peterson” is #15 on the list. At this point,…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts