June 18, 2013

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

June 18, 2013 By Leave a Comment

… of PXC, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production… talks has arisen. As such, I wanted to shift gears from the standard introductory talk and focus instead more on some… XtraDB Cluster Operations on June 26th 2013 from 10-11AM PDT.  Topics will include: Backups from the cluster Avoiding SST Flow Control…

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

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

June 17, 2013 By Leave a Comment

… of synchronous replication setup with high-availability guarantees like split-brain immunity. Nobody likes to debug async replication while its broken or…, and that is how it should be. We would like to hear from you about your architectural setup around PXC – any challenges…

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

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By 11 Comments

… in the article, this technique only works well for highly selective attributes. If attributes only have few distinct values (e.g… want to use this. Please see “Highly selective columns only” section for examples where it doesn’t work well for us too…

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

Comment: Sphinx search performance optimization: attribute-based filters

June 12, 2013 By 11 Comments

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

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

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

We’re less than a week away from Percona MySQL University at Portland, Oregon next Monday, June 17. … you love the ideal of Percona MySQL University and would like us to bring the event to your city, please let…

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

… Clara, you know it was a rare opportunity to learn from some of the most accomplished system architects and developers in… know in the comments section. I look forward to hearing from you!

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

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

… and see how easy it is?  ;-)  Generative grammars like SQL can produce an infinite variety of  queries. …Q: Doesn’t the primary key solution for random selection only work when the IDs for movies are… from what you specify in the query? The tuple comparison you’re referring to is this example: WHERE …

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

Comment: Open Source, the MySQL market (and TokuDB in particular)

May 20, 2013 By 13 Comments

… enhanced them to the point where a migration was virtually a rewrite. (Today moving from MySQL to/from Oracle/MSSql/etc is even more… IEEE 754 Floating point standard). The Justice Department (and competitors like Control Data) filed suit to break up the monopolistic stranglehold…

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

Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)

June 11, 2013 By Leave a Comment

… is needed. As the application evolves, additional requirements will appear like hot backups, online schema changes, replication based high availability (which… its own caveats, but you can also gain a lot from write set replication. If the application gets really popular, sooner…

Filed Under: Events and Announcements, MySQL Tagged With: , ,
« Older Posts