July 28, 2014

Percona Server and XtraBackup weekly news, February 5th

I decided to try a series of blog posts keeping people informed about what’s happening in Percona Server and Percona XtraBackup once a week. I’ll try to digest things, but it turns out to be hard — I want to provide details and links for everything, but then it isn’t really a digest anymore, so […]

MySQL Meetup in Charlotte,NC second attempt

I was going to visit Charlotte,NC and talk on MySQL Meetup in January but weather did not cooperate. I’m trying again and I hope this time I’m more lucky. As such I’m speaking on MySQL Meetup in Charlotte,NC 8th of February. If you’re interested in Scaling applications which use MySQL you will enjoy the talk […]

Fixing MySQL with a comment in the config file

A customer called with an emergency issue: A server that normally runs many MySQL instances wouldn’t start them up. Not only would it not start all of them, it wouldn’t even start the first one. The multiple instances were started through the mysql_multi init script. Perhaps you already know what was wrong!

Performance problem with Innodb and DROP TABLE

I’ve been working with an application which does a lot of CREATE and DROP table for Innodb tables and we’ve discovered DROP TABLE can take a lot of time and when it happens a lot of other threads stall in “Opening Tables” State. Also contrary to my initial suspect benchmarking create/drop table was CPU bound […]

How InnoDB handles REDO logging

Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain another important mechanism that affects both response time and throughput – The transaction log.

Upcoming Webinar “Managing Big Data with Percona Server, XtraBackup and Tungsten”

On February 10, We will be giving a webinar “Managing Big Data with Percona Server, XtraBackup and Tungsten”. This is joint Continuent and Percona Webinar with full description: Big data is a big problem for growing SaaS businesses and large web applications. In this webinar, we’ll teach you how to set up Percona Server, XtraBackup, […]

Percona Live: Less than 25 tickets remain

We’re down to less than 25 tickets remaining for Percona Live.  If you are planning on attending, it might be a good idea to purchase your ticket(s) as soon as possible – we are expecting to sell out.

Logging MySQL queries from the client instead of the server

The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case of Percona Server, a great deal of additional performance and other diagnostic information. But the execution time recorded in the log is the time the query took […]

Sample datasets for benchmarking and testing

Sometimes you just need some data to test and stress things. But randomly generated data is awful — it doesn’t have realistic distributions, and it isn’t easy to understand whether your results are meaningful and correct. Real or quasi-real data is best. Whether you’re looking for a couple of megabytes or many terabytes, the following […]