June 18, 2013

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

June 18, 2013 By Leave a Comment

Percona XtraDB Cluster (PXC) was released over a year ago and since then there has been tremendous interest and adoption.  There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such the need …

Filed Under: Events and Announcements, Percona XtraDB Cluster 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: ,

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… reception at the famed Paddy’s Bar and Grill sponsored by Tag1 Consulting featuring great networking possibilities and free drinks for… join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL University and would…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Post: Call for papers: Percona Live London

June 14, 2013 By Leave a Comment

… step up and volunteer to present your unique insights into MySQL and MySQL-related technologies either as a keynote, tutorial or breakout… sponsors. This is the showcase event for Europe’s growing MySQL community of developers, business managers, technology evangelists, DBAs and entrepreneurs…

Filed Under: MySQL, Percona Live Tagged With:

Comment: Converting Character Sets

June 12, 2013 By 22 Comments

… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For… to store as many characters as the original column.” [followed by a complete explanation of why TEXT coverts to MEDIUMTEXT] Maybe…

Filed Under: Insight for Developers Tagged With: , ,

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

June 17, 2013 By Leave a Comment

… the cluster with node1 and node2 in its gcomm:// (since by this time node1, node2 are up). After this, a subsequent… (which means the donor is blocked for a shorter while). By using Xtrabackup for SST, you also get its benefits like…. As referenced in that post, you can refer a post by Peter Boros (“Percona XtraDB Cluster reference architecture with HaProxy”) for…

Filed Under: MySQL, Percona XtraDB Cluster, 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:

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

… have few distinct values (e.g status, gender, group_id with only 10 groups per 10M records), then you don’t want…

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

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.

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Comment: Impact of logging on MySQL’s performance

June 11, 2013 By 8 Comments

… not pro-actively. I’ve actually see worse performance caused by slow query turned on, especially for very large (but not… when needed, and that’s why it’s turned off by default.

Filed Under: Benchmarks
« Older Posts