August 21, 2014

When does Innodb Start Transaction ?

When does Innodb Start Transaction ? The answer looks obvious – when you issue “BEGIN” command. This is however wrong answer from engine point of you. Run “SHOW INNODB STATUS” and you will see “not started” status in transaction list. It is only when you read (or write) to INNODB table you can see transaction […]

Bad weather strikes Meetup in Charlotte,NC

Due to bad weather my flight to Charlotte was canceled today and the only time they could rebook me was the red eye on Friday to arrive on Saturday morning – later than I suppose to be back. As such we have to cancel MySQL Meetup which was scheduled for tomorrow. I hope I’ll be […]

Percona Server 5.1.54-12.5

Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version. Functionality Added or Changed Percona Server 5.1.54-12.5 is based on MySQL 5.1.54. New Features Added: None Other Changes: Added system variable innodb_log_block_size and new value “keep_average” to system variable adaptive_checkpoint in Improved InnoDB I/O Scalability. (Yasufumi Kinoshita) Added new value […]

How to Identify Bad Queries in MySQL

Finding bad queries is a big part of optimization. A scientific optimization process can be simplified to “can anything be improved for less than it costs not to improve it? – if not, we’re done.” In databases, we care most about the work the database is doing. That is, queries. There are other things we […]

Percona Server Fast-Restart White Paper Posted

I’ve posted a new white paper about the implementation and benefits of Percona Server’s fast-restart capabilities. Briefly, after shutting down and restarting or rebooting the server, it can be back to full performance in a couple of minutes. That’s minutes, not hours or days. This matters a lot for keeping uptime high and reducing hardware […]

Ultimate MySQL variable and status reference list

I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables, or look for content in the Percona documentation or forums. So I present to you what is now my newest Firefox toolbar bookmark: an option and […]

Upcoming Webinar on HA solutions for MySQL

On January 31st, I’ll be giving a webinar whose title is “Choosing a High-Availability Solution”. Although the subject is not new, we keep receiving many questions regarding HA and MySQL so we thought it would be a good idea to present a webinar on the topic. The content will be a revised version of the […]

High Rate insertion with MySQL and Innodb

I again work with the system which needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM and the system was built using multiple tables. Using multiple key caches was the good solution at that time and we could get over 200K of inserts/sec. […]

Announcing Percona Live: San Francisco February 16th

Today we’re announcing Percona Live – a one day event to be held at the Bently Reserve on February 16th in San Francisco.  Live is our way of showcasing some of the awesome work that has been going into MySQL recently – and the theme of this event is Beyond MySQL 5.1. Our first guest […]

Speaking on MySQL/PHP Meetup in Charlotte, NC

I’m speaking at MySQL/PHP Meetup at Charlotte,NC next week with topic being Scaling MySQL Applications. We will have a presentation probably for about an hour and the good amount of time for questions. So come prepared. Great thanks to Red Ventures, LLC for help organizing and sponsoring this event. I’m hearing there are going to […]