June 19, 2013

Post: How We Got Here

April 9, 2012 By 6 Comments

… the best selection of speakers and topics ever at any MySQL conference, bar none. Attendees will hear from people who use MySQL in production systems and know how to operate it and develop against it. These are the people who are uniquely qualified to talk about how MySQL works in practice…

Filed Under: Events and Announcements, MySQL

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

… The second server has been online practically forever, and that’s why its …What else? Maybe this physical I/O operation is randomly positioned, which is a… about InnoDB tuning? What is the best way to choose an innodb_buffer…to your IO system’s capabilities. MySQL doesn’t have good instrumentation for…

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

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… want to know what the operating parameters are. Can we suggest … you what we think is best for you, which is our…virtual size, and there’s practically nothing else running (this is…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…

Filed Under: Insight for Developers Tagged With:

Post: EuroOSCON 2006 - High Performance FullText Search

September 22, 2006 By 4 Comments

…, Marten, Lars, Russell and ex MySQL guys such as Zak. We had good chat. There was MySQL Best Practices BOF on the conference which surprisingly attracted very few people – there were more MySQL current and ex employees… we might soon end up with main function of Mobile operators to be provide connectivity than anything else which surely will…

Filed Under: Events and Announcements Tagged With: ,

Post: MongoDB Approach to Availability

April 30, 2010 By 2 Comments

…in MySQL space. First I think MongoDB is best compared no to MySQL Server but MySQL…MySQL Cluster without replication, MongoDB is practically the same. Second – if we look at Replication Sets we find them very similar to MySQL…. In fact using MySQL Replication for failover we’re operating with kind of…

Filed Under: Cloud and NoSQL, MySQL Tagged With: ,

Post: The Optimization That (Often) Isn't: Index Merge Intersection

December 14, 2012 By 6 Comments

… had single-column indexes on them, MySQL could sometimes make use of the … that are included in this merge operation and then perform a set intersection … a problem) but probably not the best way to go for a permanent … involved have good selectivity (a good practice in general, to be sure). As …

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: Percona's Commitments to MySQL Users

November 5, 2010 By 10 Comments

… years. This era is over. MySQL has never progressed so rapidly towards…customers’ goals. And we think the best way to do that is …open-source company. We do not practice dual-licensing. We hold nothing back…Chief Performance Architect Tom Basil, Chief Operating Officer Bill Schuler, Vice President of…

Filed Under: Events and Announcements, MySQL Tagged With: ,

Post: Tom Basil (formerly MySQL's Director of Support) Joins Percona

December 4, 2008 By 13 Comments

…new Chief Operating Officer! It is Tom Basil, who was Employee #11 at MySQL and led …at MySQL in the first place. We’re building our business organically, focusing on our customers’ practical needs…We have a distributed workforce of some of the best and brightest performance gurus in the world. Values…

Filed Under: Events and Announcements Tagged With:

Post: MySQL Replication vs DRBD Battles

April 28, 2008 By 12 Comments

… (more, more) using of MySQL and DRBD as a high availability practice. I personally think DRBD … of operation to work. This is not to mention other things you can do with MySQL Replication…best of both worlds. But currently – You can’t have it all The state of High Availability Solutions for MySQL…

Filed Under: Insight for DBAs Tagged With:

Post: Upcoming Webinar on Index Design

October 1, 2012 By 2 Comments

The proper tools and techniques for designing indexes in MySQL is a broad subject, which causes grief for many developers … an overview of the best practices and procedures for you to build index design into your development and operations work.  Please register for…

Filed Under: Events and Announcements, Insight for DBAs, Insight for Developers
« Older Posts
Newer Posts »