… specific problem of logging failed connection attempts has been discussed on a previous post in our blog. Starting with 5.1, the new… for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data structures that, the… by the plugin: – audit_record_cmds : This is the list of commands you want written to the log (all the lists in…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…of metadata files. Installation of SchemaSpy and Dependencies Download the latest copy of SchemaSpy jar file (5.0.0 at time of…mysql.properties file While not explicitly required, I prefer to create this once so that the command…A to parent table: 1.0″ encoding=”UTF-8″?>
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… kinds of data corruption. MySQL provides the handy RESET SLAVE command. But as we’ll see, its behavior has changed along with the MySQL… short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5 and 5.6, run… supported from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1. RESET…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these (or any) system… updated since. Now that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server… the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
… in the 2.1 series. Bugs Fixed: Using Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client introduced… detection did not work correctly for latest Percona Server and MySQL 5.1 releases which could cause innobackupex to fail. Bugs fixed #1181092…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… another layer of protection to the backups. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… has 10M ids(after load of data size of datadir ~10GB). We used …MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing_method=keep_average innodb_flush_neighbor_pages=none command…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL… are delivered in the form of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB… were broken when the wrong arguments for nc command are passed (bug 1155712) * ss_get_…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…MySQL table? Well.. I tried a few things before I settled on the following (perl) program (accepts command line parameter of number of… gone from MySQL 5.6, it’s replaced by the following set of defines …1)-3*2=1017 which is exactly the same as what I can create. That’s right folks, in MySQL 5…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
… Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup for MySQL. After…
