June 19, 2013

Comment: Percona XtraBackup 2.1.3 for MySQL available for download

… Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=52428800 read_buffer_size=131072 max_used… may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the…

Comment: Percona XtraBackup 2.1.2 for MySQL available for download

….1.1 and 2.1.2 version (see http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/10198-can-not-get…

Comment: Converting Character Sets

… *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a…

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

… pitfalls we typically see in our consulting practice. Please let me know if you plan on attending – and also feel free…

Post: Migrating between MySQL schemas with Percona Xtrabackup

… a different schema name on the same server.  It caught me off guard because I’d never really thought about it…

Post: Private, custom Percona MySQL Training

…) 271-5054, or via e-mail at sally.martinez@percona.com.

Post: MySQL Query Patterns, Optimized - Webinar questions followup

…, and especially to folks who asked the great questions.  I answered as many as we had time for  during the session, but here are all the questions with my complete answers: Q: Can you compare the use of subqueries/multiple joins…

Comment: Experiences with the McAfee MySQL Audit Plugin

Peter: The docs say these are offsets in the mysqld binary to some data structures. By looking at the offset extraction script it seems these are query_id, thread_id, main_security_ctx, command and lex from THD, and comment from LEX.

Comment: Is Synchronous Replication right for your app?

Jay – Yoshinori found one performance bug for semi-sync — http://bugs.mysql.com/bug.php?id=69341. Wonder if there are others.

Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available

Hi, I can’t find any 5.1 files in the yum repos. Have they been moved to a new location (for example, I’m checking repo.percona.com/centos/5/os/x86_64/ )? The apt repo seems to be okay though. Thanks!