…problem of logging failed connection attempts has been discussed on a previous post in our blog. Starting with 5.1…5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL… increasing levels of concurrency), but initially, I…type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5…problem originally reported as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
…MySQL performance starting with certain concurrency as the low point. For example, MySQL 5…thread execution is what is going to happen — many batch jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5…problem with looking at performance at just high-concurrency…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…5.5.30-30.2 — New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread…problem originally reported as upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent….ac was incompatible with automake 1.12. Bug fixed #1099387 (…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
…*2 for thread_concurrency Don’t try it. The problems with thread_concurrency are two: 1- It’s deprecated and removed on 5.6.1 http://bugs.mysql.com/bug.php?id=55001 2- It only works on old Solaris versions < 9 The idea of thread_concurrency…/kernel_mutex-problem-cont-or-triple-your-throughput/ http://www.mysqlperformanceblog.com/2010/05/24/tuning-innodb-concurrency-tickets/ innodb_thread_concurrency places a…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
…. Important fixes are: – InnoDB IO threads – Adaptive checkpointing – Buffer pool mutex split …MySQL-5.1.43 vs percona-5.1.43. The results made for TPCE configuration with 2000 customers and 300 tradedays and 16 concurrent…( not Primary Keys), so it hits problems in InnoDB rw-lock implementations …
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…quick check into the problem using SysBench. It…concurrency compared to single thread ? Note Sysbench is simple enough it does not take advantage of any of new MySQL 5…threads=1 –oltp-read-only=on –init-rng=on –max-requests=0 –max-time=300 run For single thread MySQL 5.5 is 11% faster than MySQL 5…
Post: kernel_mutex problem. Or double throughput with single variable
December 2, 2011 By 17 Comments
Problem with kernel_mutex in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5.6 there are some fixes that suppose to provide a solution, but MySQL 5…_thread_concurrency and also bind mysqld to less CPUs, and also it is interesting to see if MySQL 5.6.3 really fixes this problem…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…to enter the queue. The scalability problems with multiple CPUs is well known…thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency limits number of threads…innodb_thread_concurrency setting. if you have innodb_flush_logs_at_trx_commit=1 …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…problem fixed soon ? Yes indeed there is patch out where already which may come in MySQL 5.2 or even MySQL 5.1…concurrency in many cases can be removed for READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1…
