Upgrading MySQL Server is a very interesting task as you can approach it … need to deal with. Stress Testing Running single stream of queries with good speed is not enough. You also need to perform stress testing to ensure both MySQL…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…server in a replication environment, the process can be speed up by having prefetch threads to warm the server… Backported fix for MySQL bug #53761 (Wrong estimate for RANGE query with compound indexes…). Improvements and fixes on the Percona Server Test Suite: #862378, #862252, #860416, #838725, #…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…MySQL 5.5.16, including all the bug fixes in it, Percona Server…server in a replication environment, the process can be speed up by having prefetch threads to warm the server…startup to the server. #785489 (Alexey Kopytov). The Slow Query …and fixes on the Percona Server Test Suite: #760085, #803140, #…
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
… System cache speeding up query run. So what can you do ? First decide on what are you looking to test – do you want to test worse… a lot of queries to simulate situation even remotely close to real world. Get large number of similar queries from your MySQL server logs or generate…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… and spindle speed. I need to know how…query logs in the stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server…to it, and show the difference afterwards. Or we might have a test server to run on. It varies widely; some clients have a test server…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…MySQL Also was very slow running some queries so we changed scripts a bit to kill extremely long running queries to…queries within an hour. We can also see MySQL 6.0 improving query 20 speed dramatically, the rest of the queries is however close and MySQL…Server…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…to crash again – such crashes qucikly following one another are kind of worse because they explore many less tested code paths in MySQL…file_per_table=1 your recovery speed will depend on number of Innodb… If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache)…
Post: Percona Server 5.1.50-rel12.1
October 14, 2010 By 2 Comments
…Server 5.1.50-rel12.1 is now based on MySQL…to handle end-of-line in BLOB fields differently. This change also fixed bug #625066. (Sasha Pachev) response_time_distribution – Counts queries…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…test with innodb_buffer_pool_sizeset to approximately 1/10th of the dataset: mysql> SET expand_fast_index_creation=OFF; Query…creation chapter in the MySQL manual: “… you can generally speed the overall process … Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona Server…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…MySQL Query Cache (Unix Socket) 13500 Selecting from table (TCP/IP) 5100 Selecting from table (Unix Socket) 7400 Note: The test…to MySQL Query Cache – It performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL Query…
