…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 30 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: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
… used. To some extent, MySQL 5….speed up this query (it did), but it might also negatively impact other queries which were benefitting from this optimization (it did that, too). Effective for quick testing (e.g., to…query-by-query basis, so there’s no need to go mucking about with server…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… a particular query. Or, maybe …simple but powerful way to profile MySQL memory usage;…speed rather than debugging). If the binaries you have are stripped, you have a few options to…test the procedure below and see what output you get. Once you’re all set with debug symbols, shutdown your mysqld server…
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 74 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…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
…query – SELECT c FROM sbtest WHERE id=N. Test workload with this query allows to generate significant load and check server… these allocators that should help to speed up allocation,purging of the dirty… decreasing performance in workloads with MySQL. # Test: POINT_SELECT:throughput, QPS # # Set 1 …
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server…speed was almost 10 millions of rows per second (this is on rather outdated CPU I used for testing…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
…testing writing to many files and seeing how this affects sequential read performance. I was very interested to…. Not all queries are going to be affected same… $i 10000000; mysql -e’drop database test1′; mysql -e’create database… server configuration. Going to 10000 tables however insert speed dropped…
