by Peter Zaitsev | Mar 26, 2008 | Percona Events
As you may have seen from his blog, Baron Schwartz is joining our consulting company – Percona in less than a week. This is exciting news for us as Baron is renowned MySQL community member, blogger, co-author of High Performance MySQL second edition book, author...
by Peter Zaitsev | Mar 26, 2008 | Percona Events
Reading Martens interview we see the quite: “As soon as the deal closed we immediately secured a big deal with a major European national police agency,” said Mickos, now SVP database products at Sun. “Key to them choosing MySQL was that we are now...
by Peter Zaitsev | Mar 25, 2008 | Percona Events
MySQL made some tasks from their internal task tracking tool – Worklog a while back. I just have not look at it besides checking Maria related tasks until couple of days ago as Jay announced new Forge going live. Check it out – there are a lot of nice...
by Vadim Tkachenko | Mar 25, 2008 | Benchmarks
Last week I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is a lot of new changes in optimizer, which should affect execution plan of TPC-H queries. In reality only two queries...
by Peter Zaitsev | Mar 21, 2008 | Benchmarks
Few days ago I wrote about testing writing to many files and seeing how this affects sequential read performance. I was very interested to see how it shows itself with real tables so I’ve got the script and ran tests for MyISAM and Innodb tables on ext3...
by Peter Zaitsev | Mar 21, 2008 | Percona Events
During the recent days we had few announcements of people leaving Sun/MySQL – few days ago I’ve seen announcement by Ronald Bradford and now I see Antony Curtis followed. I know bunch of other guys which are considering to leave or stay. I do not...
by Peter Zaitsev | Mar 20, 2008 | Uncategorized
MySQL Users Conference is coming and with it my presentation about Innodb Scalability limits. We did bunch of tests but we surely could get benefit of some extra hardware for testing, so if you could provide us with dedicated remote access for benchmarks it would be...
by Peter Zaitsev | Mar 20, 2008 | Insight for DBAs
Commenting on my previous post on MySQL Query Cache Gerry pokes me as I’m all wrong and both comments and whitespace are fixed in MySQL 5.0. This was not what I remember seeing in production so I decided to do some tests on the matter: I did the test two ways....
by Peter Zaitsev | Mar 18, 2008 | Insight for DBAs
I’ve just been pointed to the nice tool which I was waiting for years to see. It is fincore – little perl script which allows you to see what pages of file are cached in OS memory. This is really cool. When it comes to MySQL it is very useful with MyISAM...
by Peter Zaitsev | Mar 18, 2008 | Hardware and Storage
Working on performance optimization project (not directly MySQL related) we did a test – creating 100 files writing 4K in the random file for some time and when checking the read speed on the files we end up with, compared to just writing the file sequentially...
by Peter Zaitsev | Mar 17, 2008 | Insight for DBAs
I posted a simple INFORMATION_SCHEMA query to find largest MySQL tables last month and it got a good response. Today I needed little modifications to that query to look into few more aspects of data sizes so here it goes: Find total number of tables, rows, total data...
by Peter Zaitsev | Mar 16, 2008 | Insight for DBAs
What MySQL honestly was never good at is giving good helpful error messages. Start with basics for example – The error message in case of syntax error gives you information about tokens near by but little details: mysql> select * from user oder by pwd; ERROR...
by Peter Zaitsev | Mar 14, 2008 | Insight for DBAs
For large number of online applications once you implemented proper sharding you can consider your scaling problems solved – by getting more and more hardware you can grow. As I recently wrote it however does not mean it is the most optimal way by itself to do...
by Peter Zaitsev | Mar 13, 2008 | Insight for Developers
I think every person responsible for Development or Operations of growing application sooner or later have to decide on couple few questions on how to tackle application performance. These questions are: Should we Optimize Application or get more Hardware ? Should we...
by Martin.FarachColton | Mar 11, 2008 | MySQL
I’ve been waving my hands about lower bounds. Well, sometimes I haven’t been waving my hands, because the lower bounds are tight. But in other cases (lenient insertions, range queries), the lower bounds are very far from what we’re used to. So now,...
by Peter Zaitsev | Mar 7, 2008 | Insight for Developers
Doing performance analyzes today I wanted to count how many hits come to the pages which get more than couple of visits per day. We had SQL logs in the database so It was pretty simple query: select sum(cnt) from (select count(*) cnt from performance_log_080306 group...
by Peter Zaitsev | Mar 6, 2008 | Insight for Developers
Andrew Aksenoff is pretty slow with release numbers for Sphinx. By MySQL Users Conference 2007 Sphinx version 0.9.7 was released and today we had just 0.9.8-rc1 announced This minor change in version number corresponds to about double source size (looking at download...
by Peter Zaitsev | Mar 5, 2008 | Benchmarks, Hardware and Storage
I’m often asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write some simple steps you can take to get a good feeling about it, it is not perfect but usually can tell you quite a lot of what...
by Peter Zaitsev | Mar 5, 2008 | Hardware and Storage
Implementing MySQL database in 24/7 environments we typically hope for uniform component performance, or at least would like to be able to control it. Typically this is indeed the case, for example CPU will perform with same performance day and night (unless system...
by Martin.FarachColton | Mar 4, 2008 | MySQL
Sorry for the delay, now on to range queries and lenient updates. Let’s call them queries and updates, for short. So far, I’ve shown that B-trees (and any of a number of other data structures) are very far from the “tight bound.” I’ll say...
