May 18, 2013

Is your MySQL buffer pool warm? Make it sweat!

April 16, 2013 By 6 Comments

Today’s blog post diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you to Kyle Oppenheim at Groupon for contributing to this project and post. We’ll be posting Part 2 on Thursday. I’ll be at the Percona Live MySQL Conference and [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software Tagged With: , , , , , , ,

MySQL Workshops: Chicago & London this April

March 15, 2013 By Leave a Comment

Percona will be in Chicago and London the week of April 8th delivering two 2-day MySQL workshops. For our MPB readers, we are offering a 15% discount. Just use MPB15A when purchasing your tickets to one or both MySQL workshops. Scaling and Optimization for MySQL on Monday & Tuesday, April 8 & 9 This MySQL workshop [...]

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

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

This is part 2 in a 3 part series. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that the one of two things [...]

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

Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

February 25, 2013 By 10 Comments

There are many reasons for wanting a small MySQL database server: You’re a uni student who wants to learn the SQL language better and needs a mini-testbox You’re a Windows user who wants to play around with Percona Server on Linux You’re a corporate application developer who wants a small SQL development & test box [...]

Filed Under: Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , ,

Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 9 Comments

One of the most common causes of a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I will cover how Sphinx attributes (which are normally used for filtering) work, when they are a good idea to use and what to do when they are not, but [...]

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

Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be cached — system files, binary log, FRM files, MySQL [...]

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

Quickly finding unused indexes (and estimating their size)

December 5, 2012 By 2 Comments

I had a customer recently who needed to reduce their database size on disk quickly without a lot of messy schema redesign and application recoding.  They didn’t want to drop any actual data, and their index usage was fairly high, so we decided to look for unused indexes that could be removed. Collecting data It’s [...]

Filed Under: Insight for DBAs, MySQL, Percona Software

devops webinar – follow up Q&A

November 6, 2012 By 5 Comments

First I wanted to thanks all the attendees and for the nice comments I got. As promised during the webinar, these are the answers of the questions you asked. Q: Does Percona provide plugin for cacti? A: Yes we do. They are part of Percona Monitoring Plugins. You can see some examples here. Q: What [...]

Filed Under: MySQL

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

Announcing Percona Server 5.6 Alpha

August 14, 2012 By 2 Comments

We are very happy to announce our first alpha of Percona Server 5.6. Based on MySQL 5.6.5 and all the improvements contained within, this is the first step towards a full Percona Server 5.6 release. Binaries are available to download from our downloads site here: http://www.percona.com/downloads/Percona-Server-5.6/Percona-Server-5.6.5-alpha60.0/ We will post binaries to our EXPERIMENTAL repositories later, we’re [...]

Filed Under: Percona Software
« Older Posts