…query performance improvements followed indexing/query changes or MySQL configuration changes our customers often decide to run the query… the problem they usually run into is – query speed when it is run first time …warm it up or test warmup load. In any case testing with single query rarely gives …
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… of my analysis focused on testing specific MySQL functionally with Infobright’s storage engine. A lot of my tests involved corner or edge… Loading capability and speed of loading Accuracy of results of queries over the large data set Speed of results of queries over the large… it could not run some of the queries. ICE supports almost all of the MySQL aggregation functions. Notably, GROUP_CONCAT is not…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… (which could both cause different result set or make query not runnable in MySQL 5.0) In case you’re using Reckless… just for this project. Query Validation It is often hard to ensure queries work same way with different MySQL version, unless you have…. Stress Testing Running single stream of queries with good speed is not enough. You also need to perform stress testing to ensure both MySQL does…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and … was mostly CPU bound. Next I went on testing MySQL. My goal was to simulate as much IO …, however it still peaked out at 13.500 queries/sec with multiple threads which corresponds to even…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… PHP Associative array. This is to show kind of peak speed possible at all. Furthermore this type of caching is rather… File Cache 27000 Memcached Cache (TCP/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache (Unix Socket) 13500 Selecting from table (TCP/IP) 5100 Selecting from table (Unix Socket) 7400 Note: The test measures…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… speed stays about the same: mysql> select count(*) from m3; +———-+ | count(*) | +———-+ | 10476840 | +———-+ 1 row in set (0.00 sec) mysql… -> END REPEAT; -> END; -> // Query OK, 0 rows affected (0.00 sec) mysql> DELIMITER ; mysql> call test_read(1000); Query OK, 0 rows affected…
Post: How fast can you sort data with MySQL ?
August 18, 2007 By 26 Comments
…table as I used for MySQL Group by Performance Tests to see how much MySQL can sort 1….size is 32K which gives us the following speed: mysql> select * from gt order by i desc limit 10; …buffer_size ? mysql> set sort_buffer_size=100000000; Query OK, 0 rows affected (0.00 sec) mysql> select * from…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…they are, both in terms of size and spindle speed. I need to know how many physical spindles …10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL server …show the difference afterwards. Or we might have a test server to run on. It varies widely; some …
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… full table scan. Not all queries are going to be affected …./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done…Going to 10000 tables however insert speed dropped 20 times. This could… of overhead. During this last test box felt really sluggish responding …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… we used for testing. Even though box had 8 cores it is little use for MySQL as only one query is ran concurrently….1 and MySQL 6.0 can complete all 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…
