… 10M records), then you don‘t want to use this. Please see “Highly selective columns only” section for examples where it doesn’t work well for…
Comment: Sphinx search performance optimization: attribute-based filters
June 13, 2013 By 11 Comments
Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26
June 18, 2013 By Leave a Comment
… easier to find folks with PXC in production and such the need for more advanced talks has arisen. As such, I wanted to… 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 commonly ask about. You can register…
Comment: Call for papers: Percona Live London
June 18, 2013 By Leave a Comment
… with us of their upcoming live performances. If you‘re in the mood to enjoy a live performance while eating, drinking or… watching the show, this is the place to begin your search. At TicTune you can search for upcoming local live performances. These… more. With an easy-to-use interface, search within distance, date, or by type or genre of shows you are interested in.
Post: Call for papers: Percona Live London
June 14, 2013 By Leave a Comment
… MySQL Conference and Expo in Santa Clara, you know it was a rare opportunity to learn from some of the most accomplished… depth. These stories are gold! And you owe it to the MySQL community to share them. Don’t worry about being fancy. Some of the most popular talks have been on simple topics done well. Many people come to…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
… hostname – should be known in advance (the node itself needn’t be up), which may not be feasible in a cloud… the node. You can also look this PLMCE talk for HAProxy deployment strategies with PXC. To conclude, it is interesting to note that… should be. We would like to hear from you about your architectural setup around PXC – any challenges you faced (and horror stories if…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
June 18, 2013 By 29 Comments
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: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
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 change innodb_log_file_size safely
June 13, 2013 By 17 Comments
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
Comment: Data mart or data warehouse?
June 17, 2013 By 14 Comments
Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.
Comment: How to calculate a good InnoDB log file size
June 14, 2013 By 38 Comments
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.
