June 20, 2013

Post: What technologies are you running alongside MySQL?

June 19, 2013 By 3 Comments

… environments MySQL is not the only technology used to store in-process data. Quite frequently, especially with large-scale or complicated … and processing do you use alongside MySQL in your environment? Please feel free to elaborate in the comments about your use case and…

Filed Under: MySQL, Polls Tagged With: , , , , , , , , , , , , ,

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

June 18, 2013 By Leave a Comment

…, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such the need… some key questions/issues/pain-points for those with PXC in production already.   As such, I’m giving a webinar entitled… Flow Control What and How to Monitor Tuning best practices This webinar is not meant to necessarily be exhaustive, but to cover key topics…

Filed Under: Events and Announcements, Percona XtraDB Cluster Tagged With: , , , , , ,

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

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

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

June 17, 2013 By Leave a Comment

…In their setup they have automated this with a HAProxy in each AZ (Availability Zone) for the API server. To…in 5.5.31), looking for optimizations with HAProxy to account for high connection rates, and using pacemaker with PXC. The goal is to… and that is how it should be. We would like to hear from …

Filed Under: MySQL, Percona XtraDB Cluster, XtraDB Cluster Tagged With: , , , , , , , ,

Post: Call for papers: Percona Live London

June 14, 2013 By Leave a Comment

… you experienced while actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are… internals or explain how specific features work in depth. These stories are gold! And you owe it to the MySQL community to share them…

Filed Under: MySQL, Percona Live Tagged With:

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.

Filed Under: Insight for DBAs Tagged With: ,

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

Fabian, – please note that, as stated in the article, this technique only works well for highly selective … 10 groups per 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Comment: Percona Server 5.6.11-60.3 first Release Candidate now available

June 18, 2013 By 3 Comments

does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

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.

Filed Under: Insight for Developers, MySQL

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.

Filed Under: MySQL
« Older Posts