…debian-sys-maint”,”host”:”localhost”,”cmd”:”Connect“,”query”:”Connect“} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user…localhost”,”cmd”:”Connect“,”query”:”Connect“} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s …
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…_size=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible that mysqld… dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads…. Thread pool Percona Playback added a connection pool option via –dispatcher-plugin-thread-pool that will allow connection …
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… MySQL database servers. This feature introduces new –thread-pool-threads-count option, which can be used to specify the number of threads in the thread pool dispatcher plugin. Bugs fixed: Percona Playback for MySQL now shows error when it’s unable to connect to the MySQL…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped… which caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state (bug 1089506) Update note: Cacti… Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A new tarball is available from downloads…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped… which caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… point. For example, MySQL 5.6 DBA and Developer Guide has a number of graphs starting with 32 connections at the low… baseline that offers the best response times (MySQL server does not use multiple threads to execute query in parallel at this point…-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…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… a chart with top mutexes for each server at 64 threads: For MySQL 5.5.30 top mutex is &doublewrite->mutex: trx0sys…_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open…
