… involving the McAfee MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL has traditionally… test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data structures that, the plugin authors say… lines generated by the plugin with this configuration: {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”0“,”user”:”debian-sys…
Comment: How to Monitor MySQL with Percona's Nagios Plugins
May 20, 2013 By 11 Comments
… great post, i was trying to implement a pmp-check-mysql-status plugin for server uptime is small, as it will notify… these parameters -x Uptime -c 5 and my output is CRIT Uptime = 4951 | Uptime=4951;;5;0; so how can i change it…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… “MySQL Network” commercial subscription product was announced in what later evolved into “MySQL Enterprise,” and MySQL 5.0 is finally available as GA with version 5.0.20a… MySQL 5.1 is in development (5.1.9) 2007… Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA version. The MySQL Enterprise model is changed… now MySQL…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
…release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities…of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…plugin… As part of the standard MySQL 5.6 GA distribution, there is a memcached plugin included in the base plugin directory (/usr/lib64/mysql/plugin…(‘Core’, ‘Libmemcached’, $frontendOpts, $memcacheOpts); $timer->start(); for ($i = 0; $i < 100000; $i++) { $cache->save(new Object(), “key_$i”); }…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… MySQL Sunny Bains, Senior Principal Software Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5…, Chief Evangelist for MariaDB for Monty Program Topic: “MariaDB 10.0 & What’s New With the Project” Sergei Petrunia, Optimizer Developer… Plugins: What’s New?” The Percona Live MySQL Conference includes a Diamond Sponsor Keynote panel on Wednesday morning on the “Impact of MySQL 5…
Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
April 11, 2013 By 2 Comments
… MySQL version choose correct binary # MySQL 5.0.* – xtrabackup_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB plugin – xtrabackup # MariaDB 5.1.* – xtrabackup # MariaDB 5.2.* – xtrabackup # MariaDB 5.3.* – xtrabackup # Percona Server 5.0…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0 –num-threads…/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD… #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…, trust me. So Galera 0.8 comes with many nice features: Works with MySQL 5.1 and MariaDB 5.1. The latest is more… add support for Percona XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems… of MySQL/Galera is that it is based on standard InnoDB 5.1 instead of InnoDB-plugin. Standard InnoDB is seriously behind InnoDB-plugin…
Post: 5.0.87-build20 Percona binaries
November 18, 2009 By 3 Comments
…: The build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To be compatible with… changed to
