by kuszmaul | Dec 5, 2008 | MySQL
I’d like to advertise my previous iiBench posting again (now that we are feeding into PlanetMySQL.)
by Baron Schwartz | Dec 4, 2008 | Percona Events
Percona has a new Chief Operating Officer! It is Tom Basil, who was Employee #11 at MySQL and led the Support organization there for almost eight years. He was the founding Director of Support at MySQL, and built it into a team of about 60 people all across the world....
by Peter Zaitsev | Dec 3, 2008 | Benchmarks
We’ve recently done benchmarks comparing different MySQL versions in terms of their CPU efficiently in TPC-C like Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent, though we do not...
by kuszmaul | Dec 3, 2008 | MySQL
At the recent OpenSQL Camp in Charlottesville, VA, Tokutek offered a challenge to the MySQL community – who can insert a billion rows into MySQL the fastest? We will post the results on our website and the winner gets a $100 Starbucks card, along with...
by Peter Zaitsev | Dec 1, 2008 | Percona Events
We have now published presentations from OpenSQLCamp at Percona Presentation pages Percona MySQL Patches is a great presentation to see Percona Patches for MySQL in action, showing how you can use them to get more understanding of your server load and improve server...
by Peter Zaitsev | Nov 28, 2008 | Insight for Developers
When doing performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The “average” is the evil of performance optimization and often as helpful as “average patient temperature in the hospital”. Lets set...
by Peter Zaitsev | Nov 28, 2008 | Percona Software
Working with number of hosting providers I always wonder how do they manage to keep things up given MySQL gives you so little ways to really restrict how much resources single user can consume. I have written over a year ago about 10+ ways to crash or overload MySQL...
by Baron Schwartz | Nov 26, 2008 | Insight for Developers
There are all sorts of different interfaces to memcached, but you don’t need any of them to make requests from the command line, because its protocol is so simple. Try this, assuming it’s running on the usual port on the local machine: echo stats | nc...
by Peter Zaitsev | Nov 26, 2008 | Insight for DBAs
Happy Thanksgiving and little holiday challenge for you. Say you have a trigger on the slave which you would like to work differently, depending on whenever update is executed via replication thread vs updating table locally ? This can be helpful for example for...
by Peter Zaitsev | Nov 26, 2008 | Insight for DBAs
I have written before – MyISAM Does Not Scale, or it does quite well – two main things stopping you is table locks and global mutex on the KeyCache. Table Locks are not the issue for Read Only workload and write intensive workloads can be dealt with by...
by Baron Schwartz | Nov 24, 2008 | Insight for Developers
Our customers or prospective customers often ask us how we do a performance audit (it’s our most popular service). I thought I should write a blog post that will both answer their question, so I can just reply “read all about it at this URL” and...
by Peter Zaitsev | Nov 24, 2008 | Insight for DBAs
INFORMATION_SCHEMA, in particular by favorite TABLES table is not only helpful to understand tables you have on the system, but I have also found it to be very helpful as a scripting language for variety of database administration tasks. It can be more straightforward...
by Baron Schwartz | Nov 21, 2008 | Insight for DBAs
Peter wrote a post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but the post actually kind of talks about a lot of things and then doesn’t tell you how to choose a good log file size! So I thought I’d clarify it a little....
by Vadim Tkachenko | Nov 19, 2008 | Percona Software
After some discussions on the OpenSQLCamp 2008 conference we decided to move our development to Launchpad, to be in stream with other MySQL related projects. We published our patches there https://code.launchpad.net/percona-patches, it is supposed to be main...
by Vadim Tkachenko | Nov 14, 2008 | Percona Software
We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes: | innodb_check_defrag.patch | Session status to check fragmentation of the last InnoDB scan | 1.0 | Percona <[email protected]> | GPL | The...
by Yasufumi Kinoshita | Nov 13, 2008 | Benchmarks, Percona Software
Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”. — limit of “amount” — As you know, buffer...
by Peter Zaitsev | Nov 12, 2008 | Benchmarks
As you likely have seen Sun has posted the new SpecJAppServer Results More information from Tom Daly can be found here These results are quite interesting for me as I worked on some of the previous SpecJAppServer Benchmarks several years ago while being employed by...
by Peter Zaitsev | Nov 11, 2008 | Uncategorized
As you may have recently seen there are some articles about scaling MySQL one 256-way system. I though wow did they really make it work, considering how many bottlenecks remain in MySQL. What article really tells us ? First the number 256 – this is not number of...
by Vadim Tkachenko | Nov 11, 2008 | Percona Software
After some pause we are going to announce bunch of patches we made and ported for last period. Ported patches (ported from Google V2 patch): – innodb_fsync_source.patch – Show information about callers of fsync, more info – innodb_io_tune.patch...
by Peter Zaitsev | Nov 10, 2008 | Insight for DBAs
For normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups daily....
