June 19, 2013

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…

Filed Under: Benchmarks Tagged With:

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…

Filed Under: Benchmarks, Insight for DBAs Tagged With:

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

March 4, 2013 By 7 Comments

…=latin1; Query OK, 0 rows affected (0.02 sec) mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT…, we will take a look at performance. How does the speed of InnoDB FTS compare to its MyISAM counterpart, and what…

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

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… At the very bottom, the page claims that you can speed up bulk loading into an InnoDB FT index by …00 sec) mysql> delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | …

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

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 …

Filed Under: Insight for Developers Tagged With:

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 …

Filed Under: Benchmarks Tagged With: ,

Post: MySQL performance: Impact of memory allocators (Part 2)

March 8, 2013 By 12 Comments

…SELECT – very simple query – SELECT c FROM sbtest WHERE id=N. Test workload with this query allows …in these allocators that should help to speed up allocation,purging of the dirty pages…correlation with decreasing performance in workloads with MySQL. # Test: POINT_SELECT:throughput, QPS # # Set 1 – …

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

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…

Filed Under: Benchmarks

Post: Talking MySQL to Sphinx

April 19, 2009 By 4 Comments

…-rc2 there is a support for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx indexes. This support is currently… other queries, not using Full Text Search. [root@r27 sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor… raw scan speed was almost 10 millions of rows per second (this is on rather outdated CPU I used for testing) – this…

Filed Under: Insight for Developers Tagged With:

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

…##################################################### Total | 23.59G … Locator Size Speed Form Factor Type Type Detail ========= ======== ================= …MySQL configurations, I didn’t try out different MySQL… thread_cache_size = 32 query_cache_size = 0 … single test on a larger files (same test…

Filed Under: MySQL
« Older Posts
Newer Posts »