by Peter Zaitsev | Nov 8, 2008 | Insight for Developers
I had an interesting tuning case few days ago. The system serving high traffic using Innodb tables would be stalling every so often causing even very simple queries both reads and writes taking long time to complete, with progress almost paused (dropping from...
by Peter Zaitsev | Nov 7, 2008 | Percona Events
We have finally found the time to update out presentation pages – we’ve added the presentation on MySQL Scaling by Sharding and Replication as well as Russian Language presentations I’ve given at HighLoad++ conference back in October. Innodb...
by Maciej Dobrzanski | Nov 7, 2008 | Insight for DBAs
Occasionally there is a need to see what queries reach MySQL. The database provides several ways to share that information with you. One is called general log activated with --log 1 --log (or --general-log 1 --general-log in MySQL 5.1+) start-up parameter. The log...
by Maciej Dobrzanski | Nov 6, 2008 | Insight for DBAs
Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem...
by Piotr Biel | Nov 5, 2008 | Insight for Developers
Today was epoch day in American history. Maybe even most important day this year, but it’s not what I’d like to write about here. What does it mean for US citizens and all other people around the world? We know, but what does it mean for us – IT...
by Piotr Biel | Nov 3, 2008 | Insight for DBAs
Some time ago I get brand new IBM POWER6 server as the replacement for “old” P5 used to host Oracle database. Because we planed to use advanced virtualization with VIOS + LPAR/DLPAR I conceived the idea to use one spare partition for MySQL tests. Because I...
by Peter Zaitsev | Nov 2, 2008 | Percona Events
OpenSQLCamp is coming close and it is your last change to register. I’m very excited about this event as it looks to be marketing free community gathering, having much fewer attendees but many of them are well known MySQL Professionals. Besides hopefully in...
by Vadim Tkachenko | Nov 1, 2008 | Percona Events
This is a fantastic addition to the Percona team. Congratulations.
by Maciej Dobrzanski | Oct 31, 2008 | Insight for DBAs
When running InnoDB you are able to dig into the engine internals, look at various gauges and counters, see past deadlocks and the list of all open transactions. This is in your reach with one simple command — SHOW ENGINE InnoDB STATUS 1 SHOW ENGINE InnoDB...
by Baron Schwartz | Oct 31, 2008 | Benchmarks, Insight for DBAs
This is a fun question I’ve been wanting to test for some time. How much overhead does a trivial WHERE clause add to a MySQL query? To find out, I set my InnoDB buffer pool to 256MB and created a table that’s large enough to test, but small enough to...
by Peter Zaitsev | Oct 27, 2008 | Percona Events
November 3rd, I’m speaking at San Francisco MySQL Meetup – The talk will be about Scaling MySQL driven Web Sites by Sharding and Replication. This is Free event and you’re surely most welcome to join. At this point I see there are some 70 people...
by Vadim Tkachenko | Oct 25, 2008 | Percona Software
Google patches V1 contain interesting patch to mirror binary log on slave. Although Google is preparing GlobalTransactionId patch, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for: Backup of binary logs in real...
by Ryan Lowe | Oct 21, 2008 | Uncategorized
We have written before about the importance of using numeric types as keys, but maybe you’ve inherited a schema that you can’t change or have chosen string types as keys for a specific reason. Either way, the character sets used on joined columns can have...
by Vadim Tkachenko | Oct 20, 2008 | Percona Software
There is patch from Google to improve SMP performance , but for some workloads it showed for us reverse scalability. E.g. update_key benchmark from sysbench. There are also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442) ThreadsStandard...
by Baron Schwartz | Oct 13, 2008 | Percona Software
Percona’s patches are now available to a wider audience via OurDelta, a community effort to provide builds with features (Percona patches, Google patches, etc) and storage engines (PBXT, Sphinx, etc) that aren’t in the main MySQL server. Arjen Lentz is...
by Peter Zaitsev | Oct 10, 2008 | Percona Events
I guess many of you know us and so our company for MySQL related services. It is true this is majority of our business at this point but it is far from everything. Our goal in reality is to help people to build and operate quality systems, typically web sites, which...
by Baron Schwartz | Oct 8, 2008 | Insight for DBAs
The trouble with slave lag is that you often can’t see it coming. Especially if the slave’s load is pretty uniform, a slave that’s at 90% of its capacity to keep up with the master can be indistinguishable from one that’s at 5% of its capacity....
by Baron Schwartz | Oct 1, 2008 | Percona Events
Although we haven’t announced any new members in a while, the Percona team has continued to grow steadily behind the scenes. Our hiring policy is to have a few months’ provisional period to ensure the absolute highest quality of service and consistency of...
by Ewen Fortune | Sep 29, 2008 | Insight for DBAs
Recently I was tasked with investigating slippage between master and slave in a standard replication setup. The client was using Maatkit’s mk-table-checksum to check his slave data was indeed a fair copy of that of the master. mk-table-checksum...
by Vadim Tkachenko | Sep 28, 2008 | Insight for DBAs
Ever wonder what is stored in InnoDB buffer pool at the moment ? It is not so hard actually – we made a short patch for MySQL 5.0 which show innodb buffer pool content mysql> select * from information_schema.INNODB_BUFFER_POOL_CONTENT;...
