… additional benefit is that SchemaSpy is command-line driven and builds the html after each run, so I find it convenient to… package Creating a mysql.properties file While not explicitly required, I prefer to create this once so that the command line is… need to provide a hint or not. Running SchemaSpy (with Foreign Keys) When you run schemaSpy without a metadata file, you will…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can …these were basic tests (just a few mysqlslap runs with increasing levels of concurrency), but initially, … – audit_record_cmds : This is the list of commands you want written to the log (all …
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2 percona]# mysqladmin ping mysqld is alive [root..." /etc/sysconfig/cman And create the cluster, perform the following command on one server only: [root@percona1 ~]# ccs -f /etc/cluster… maintenance mode… but crm command is not present any more 
It’s still possible to find the command install crmsh (crm shell…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… corruption. MySQL provides the handy RESET SLAVE command. But as we’ll see, its behavior has changed along with the MySQL versions and… are reset to default values. This means that if you run START SLAVE (or if it’s done automatically, for instance… affected (0,04 sec) mysql> show slave status\G Empty set (0,00 sec) Very good! The command does work as expected without…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… slow logs are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it… from stdin Percona Playback now supports the –query-log-stdin command-line option for accepting a never-ending stream of queries to playback. Read-only playback Using the –session-init-query command-line option, we set the option innodb_fake_changes to…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… how to setup and run this benchmark, can be found here. We decided to run this benchmark for MySQL Server 5.5.30…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… password= -D maxid1=100000001 -c config/MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… certain versions of MySQL that have critical bugs. Version check will warn you about these if your system is running them. What… the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is… received mini overhauls in 2.2 to make their run-related options (–run-time, –interval, –iterations) standard. If you hadn’t noticed…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
…) * Memcached graphs were broken when the wrong arguments for nc command are passed (bug 1155712) * ss_get_by_ssh.php didn… (bug 1050537) * ss_get_by_ssh.php didn’t timeout commands that hang (bug 1160611) * pmp-check-file-privs didn’t… error on directory permissions issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state (bug…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5… not work with server datadir if the server isn’t running and logs were in a separate directory. Bug fixed #1174314…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… was simply a matter of installing two RPMs and running a couple of commands to enable vCache on the PCIe flash card… but vCache stats have to be retrieved by running the vgc-vcache-monitor command. Personally, I prefer “cat /proc/something” but I…
