… the Percona Server results to stabilize, for MySQL 5.5.8 we have regular dips (3 times per hour) from 24900 NOTPM… innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=8…_threads=8 innodb_io_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… unique fixes such as different innodb_thread_concurrency handling and other optimization. Should we take Innodb from MySQL 5.4 and merry it… apart Innodb derivatives, like XtraDB there are 3 innodb versions around. There is MySQL 5.0 version which did not get significant… format, compression and fast index build. Innodb plugin 1.0.3 got some Google changes for CPU scalability but not IO…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 320 MySQL thread id 30899… tries to limit thread concurrency allowing only innodb_thread_concurrency threads to run inside Innodb kernel at the same time. If thread is not runniing inside…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover… to the beginning of the stripe element. 3. 1M alignment in partition table but no …performance up to 15% in case of 8 threads running concurrently. Because the customer was running a …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql… –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache=512…, 4, 16, 64, 128, 256 concurrent threads. 3. For each thread perform a warm-up run (…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… of MySQL server in the read-only workloads. For my testing i chose following allocators: lockless, jemalloc-2.2.5, jemalloc-3… based on new malloc with increasing concurrency demonstrate notable drops – almost two times at high threads. In the same time glibc-2… are very similar to lockless/jemalloc-3.0/tcmalloc. For POINT_SELECT test with increasing concurrency we have two allocators that handle…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
…you see running 2-4 threads concurrently we get result by 30% worse than with 1 thread, although it’s … symbols) 723200 9.8142 libpthread-2.3.4.so pthread_mutex_unlock 237062 3.2171 mysqld key_cache_read …at 4 concurrent threads. So there is still work to do in addition to fixes done in later MySQL 5….
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
…can see in the case of the very high concurrency and notable amount of the small/medium allocations, … impact on MySQL performance after version 3.2.0 (see raw results below) so I used jemalloc-3.1….jemalloc-3.1.0 # Set 3 – 5.5.30pre-jemalloc-3.2.0 # Set 4 – 5.5.30pre-jemalloc-3.3.0 # # Threads …
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (… of CPU’s*2 for thread_concurrency thread_concurrency = 16 set-variable=max_connections=2000 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…, not just for new connections as in MySQL. This is very helpful for measurement as …verbosity=full: # Time: 111229 3:11:26 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id: 1 Schema: test Last…digest. # Query 4: 0.12 QPS, 0.00x concurrency, ID 0xA766EE8F7AB39063 at byte 4001761 # This item …
