May 22, 2013

Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

I presented a webinar this week to give an overview of several Full Text Search solutions and compare their performance.  Even if you missed the webinar, you can register for it, and you’ll be emailed a link to the recording. During my webinar, a number of attendees asked some good questions.  Here are their questions and my [...]

Filed Under: Events and Announcements, Insight for Developers, MySQL

Webinar for Full Text Search Throwdown

August 21, 2012 By 1 Comment

Tomorrow, August 22 at 10:00am PDT, I’ll present a webinar called Full Text Search Throwdown.  This is a no-nonsense performance comparison of solutions for full text indexing for MySQL applications, including: LIKE predicates and regular expressions MyISAM FULLTEXT indexes InnoDB FULLTEXT indexes Apache Solr Sphinx Search Trigraphs I’ll compare the performance for building indexes and querying [...]

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Testing Intel SSD 520

May 1, 2012 By 8 Comments

Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB into my hands. In this post I show the results of raw IO performance of this card.

Filed Under: Benchmarks, Hardware and Storage, MySQL

How to Monitor MySQL with Percona’s Nagios Plugins

February 22, 2012 By 11 Comments

In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended purpose. I want to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed with [...]

Filed Under: Insight for DBAs, MySQL

Preventing MySQL Emergencies Webinar

January 24, 2012 By Leave a Comment

On the 25th of January at 10 am PST, I will present a webinar on preventing MySQL emergencies titled “Preventing Downtime in Production MySQL Servers”. The material I will present is based on in-depth research done by Percona across many production servers.  We analyzed more than 150 emergency cases and categorized our findings to help [...]

Filed Under: Events and Announcements, MySQL

Which Linux distribution for a MySQL database server? A specific point of view.

December 8, 2011 By 38 Comments

One of the more common questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means I should advise something that is stable, reliable, easy to manage and has plenty of resources available online. It should also allow running MySQL without too [...]

Filed Under: Insight for DBAs, MySQL

Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December

November 17, 2011 By 6 Comments

My friends at Sphinx Technologies have finally released new beta of Sphinx – Sphinx 2.0.2. It includes about 6 months of development and includes over 30 new features and tons of bug fixes. I’m happy to see how Sphinx 2.0 is shaping up a lot of rough corners are being polished and I’m hopeful we [...]

Filed Under: Cloud and NoSQL, MySQL

Clustrix benchmarks under tpcc-mysql workload

October 26, 2011 By 9 Comments

I’ve been working with Clustrix team for long time on the evaluation of Clustrix product, and this is the report on performance characteristics of Clustrix under tpcc-mysql workload. I tested tpcc 5000W (~500GB of data in InnoDB) on Clustrix systems with 3, 6, 9-nodes and also, to have base for comparison, ran the same workload [...]

Filed Under: Benchmarks, Hardware and Storage, MySQL

Disaster: MySQL 5.5 Flushing

September 18, 2011 By 27 Comments

We raised topic of problems with flushing in InnoDB several times, some links: InnoDB Flushing theory and solutions MySQL 5.5.8 in search of stability This was not often recurring problem so far, however in my recent experiments, I observe it in very simple sysbench workload on hardware which can be considered as typical nowadays.

Filed Under: Benchmarks, Hardware and Storage, MySQL

Percona’s Sessions at the O’Reilly MySQL Conference and Expo

April 7, 2011 By Leave a Comment

I just realized that we haven’t blogged a list of our sessions at the O’Reilly MySQL Conference and Expo (#mysqlconf) yet. Here is a hopefully complete list.

Filed Under: Events and Announcements, MySQL
« Older Posts
Newer Posts »