June 19, 2013

Comment: Call for papers: Percona Live London

… community of artists, venues, promoters, and members who come together to share with us of their upcoming live performances. If you’re in the mood to enjoy a live performance while eating, drinking or simply watching…, clubs, bars, theaters, festivals and much more. With an easy-to-use interface, search within distance, date, or by type or genre…

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

… of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and… for more advanced talks has arisen. As such, I wanted to shift gears from the standard introductory talk and focus instead… Flow Control What and How to Monitor Tuning best practices This webinar is not meant to necessarily be exhaustive, but to cover key topics…

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

I used to be recommended this blog via my cousin. I am not certain whether this put up is written by means of him as no one else know such exact about my trouble. You are incredible! Thank you!

Comment: Sphinx search performance optimization: attribute-based filters

… 10 groups per 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for examples…

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… of this post is to enumerate real-world usage of Percona XtraDB Cluster (PXC), and also to solicit use cases from the readers… for optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is to reduce the overhead of… scale more with less, and that is how it should be. We would like to hear from you about your architectural setup…

Post: Call for papers: Percona Live London

… us your war story: What have you experienced while actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank… or explain how specific features work in depth. These stories are gold! And you owe it to the MySQL community to share them… been on simple topics done well. Many people come to the conferences to learn — and we need content for MySQL newcomers as…

Comment: Sphinx search performance optimization: attribute-based filters

we use sphinx to our website where we have about 1200 tables each with hundreds of thousands of records, for we use sphinx… described here, but the search results have gone from milliseconds to more than 43 seconds

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572

Comment: Sample datasets for benchmarking and testing

the links here are useful and informative…

Comment: How to calculate a good InnoDB log file size

According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.