… solution for randomly choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY RAND() solution… some more tips: Check out upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL community at our…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer…, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server, of course, cannot risk to block…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… the update, see bellow how to perform this action [root@percona1 percona]# yum update -y [root@percona1 percona]# cat /etc/redhat-release CentOS…:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql): Slave…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… this socket and process the audit records as you wish. Performance-wise, I did basic tests on the VM I was… advantage of the plugin is its flexibility, and not its performance, which seems to be on par with having the general… that I mentioned had to be extracted due to this Percona Server version not being included in the binary. And here…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
…” width=”300″] Peter Zaitsev leads a track at the inaugural Percona MySQL University event in Raleigh, N.C. on Jan. 29… such it is a very natural place for our next Percona MySQL University event scheduled for June 17. We run this… our own Daniel Nichter, who recently moved to the area. Percona MySQL University is a daylong, free, fast-paced and very…
Comment: Performance Schema overhead
June 12, 2013 By 22 Comments
Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering 
Thanks for sharing.
Comment: Minimizing Downtime from Lengthy AWS Outages
June 12, 2013 By 7 Comments
Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.
Comment: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
… re-actively not pro-actively. I’ve actually see worse performance caused by slow query turned on, especially for very large…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
… the existing mysql data dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re planning to switch back from Percona Server 2) here is the list of compared features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3) we’re not planning to release the windows versions of Percona…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… have to export databases from mysql and import them in Percona server or can I use mysql data directory? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS for my servers but i develop apps in windows, do you think percona will release windows version as well? Thanks
