June 19, 2013

Post: More on MySQL transaction descriptors optimization

April 26, 2013 By Leave a Comment

… SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside …tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to… third one features even higher QPI speed (and thus, faster inter-process/node …

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: Upgrading MySQL

January 5, 2010 By 24 Comments

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…

Filed Under: Insight for DBAs, 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, #…

Filed Under: MySQL, Percona Software

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, #…

Filed Under: MySQL

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

…server for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL…test server having 4*7200RPM SATA hard drives in RAID10. It has 8GB of RAM and I’m running Percona Server…to large full table scan and index scan queries…

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

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

… queries to use ANSI JOIN syntax.  No other changes to the queries were made. Test Environment The MySQL … pool (no IO on repeat runs) Test Server: Intel core i970-3.20GHz.  12 …MySQL 5.5.30.  It took 361.49 seconds to complete all 13 queries.  I then repeated the run three more times.  The speed…

Filed Under: MySQL Tagged With: , , , , ,

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…

Filed Under: Benchmarks, Insight for Developers

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…

Filed Under: Insight for Developers Tagged With:

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

March 4, 2013 By 7 Comments

…Query OK, 0 rows affected (0.02 sec) mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query…To test this hypothesis, I reset innodb_ft_min_token_size to 1, dropped/rebuilt the InnoDB index, and tried again. mysql…

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

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

…to the MySQL queries would make them even slower, I’m sure. Indeed, the result set of 20 rows from SphinxQL queries…MySQL crashed with an out of memory fatal error, and the Windows 7 server I was testing on prompted me to…

Filed Under: Events and Announcements, Insight for Developers, MySQL
« Older Posts