…, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks… objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also removed several options…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its… statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a… for MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed. Bug…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its… statements on an existing table could wait on a metadata lock instead of failing or returning immediately if there is a… for MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed. Bug…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…, and were not removed when incremental backups has been merged. Fixed by removing files corresponding to… dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from…would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps …, and were not removed when incremental backups has been merged. Fixed by removing files corresponding to … would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the… with the read-only optimization in MySQL 5.6 to achieve even better scalability while removing the read-only limitations. Let’s…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…Last_errno: 0 Killed: 0 # Query_time: 9.031233 Lock_time: 0.000086 Rows_sent: 0 Rows_examined: … found and returned up to the top level MySQL part for processing are counted the Rows_examined … after group by, distinct and aggregate functions are removed (A) – look at number of rows examined divided …
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA… least remove confusing message which leaves impression this thing works. Until this issue is fixed getting Crash Safe replication with MySQL is… do traditional and recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you have large amount…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
We made new binaries for MySQL 5.0.67 build 10 which include next fixes: We … | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to… TIME_MS column | 1.0 | Percona | GPL | | | innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron…
