June 19, 2013

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: 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…

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

… chef with PXC Finally, integration of HAProxy as a loadbalancer. To elucidate, their initial setup goes into bootstrapping the first node… a shorter while). By using Xtrabackup for SST, you also get its benefits like compression, parallel streaming, encryption, compact backups which…

Post: Call for papers: Percona Live London

… blank) in production? Are you managing multiple environments? Are you working with MySQL or its variants at the code level? Share… explain how specific features work in depth. These stories are gold! And you owe it to the MySQL community to share them. Don… 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

… note that, as stated in the article, this technique only works well for highly selective attributes. If attributes only have few… don’t want to use this. Please see “Highly selective columns only” section for examples where it doesn’t work well for…

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

… for more advanced talks has arisen. As such, I wanted to shift gears from the standard introductory talk and focus instead… from the cluster Avoiding SST Flow Control What and How to Monitor Tuning best practices This webinar is not meant to necessarily be exhaustive, but to cover key topics that administrators of PXC will…

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: 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.

Comment: How to change innodb_log_file_size safely

@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

… at percona.com. My apologies if we weren’t able to get to your question during the initial session, so I’ll address… you’ll get roughly 1.67x the throughput of a single port. [Don’t try more than 2; the additional work that… Percona position, and I will look forward to being able to retract them. MHA should work fine with 5.6 if you’re…