… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… this socket and process the audit records as you wish. Performance-wise, I did basic tests on the VM I was… with increasing levels of concurrency), but initially, I would think the advantage of the plugin is its flexibility, and not its performance…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May…_faster And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the… low because recovery took a long time, you can consider increasing the file size.”
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…, we are seeing the increasing independence of the ecosystem of MySQL-related products and services from MySQL itself – both in terms …Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, …
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
…. This time I want to target an opposite question: why MySQL performance at low concurrency is important for you. I decided to… posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer… how they are affected and how the system scales with increasing concurrency in effect. Second, there are many cases in which…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 5.6.11 spent in LRU_scan. I tried to increase innodb_lru_scan_depth variable to 8k,16k,32k but… second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack … that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls …cause flow control on your cluster. The cost of increasing the fc_limit Keeping the fc_limit small …
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
…their database server, leading to degraded application performance, and sometimes even short moments of downtime…. to correlate most load peaks with temporary increases in user activity, so it became … regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… transactions for this workload are: $ID=monotonically increasing ID $K=rand(0,10000) // distributed by … and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so…repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB…
