…this post. Auditing user activity in MySQL has traditionally been challenging. Most …concurrency), but initially, I would think the advantage of the plugin is its flexibility, and not its performance…Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… promised more low concurrency SSB tests when Peter blogged about the importance of performance at low concurrency. The …with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) …=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption…allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under very… (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona… if found. Bug fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…in InnoDB high-concurrent workloads. Bugs fixed …
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… look as though single-thread performance is no more a concern. I believe it still is! First, performance at concurrency of 1 serves as an important baseline that offers the best response times (MySQL server does not use multiple threads to…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…because e.g. for 1024 concurrent threads each SELECT has to …threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance… –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…MySQL 5.5 basically kills throughput on high concurrency. The picture changes dramatically when the read-only optimization in MySQL…drop in throughput starting from 256 threads. But Percona Server’s scalability…are going to blog about other MySQL performance improvements introduced in our latest …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…in InnoDB high-concurrent workloads. Bugs fixed …
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… queries or simple transactions but high concurrency with complex transactions as well — items like the thread pool offering far more sanity and… far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this…
