by Peter Zaitsev | May 13, 2008 | Percona Events
As you know we love to analyze performance of various MySQL features, benchmark, compare, analyze things and post our findings on MySQL Performance Blog. However recently we got too busy with serving out customers and the backlog of things to take a look and write...
by Peter Zaitsev | May 1, 2008 | Insight for DBAs
In the previous post I mentioned a way I use to preload Clustered Index (data) for Innodb tables. Though I thought this topic would benefit from a bit more information. But lest first start with feature request for Innodb Team: All ways I mention here are hacks and...
by Peter Zaitsev | May 1, 2008 | Insight for DBAs
Recently I was working with the customer who need quick warmup – to get Innodb table fetched in memory as fast as possible to get good in memory access performance. To do it I run the query: “SELECT count(*) FROM tbl WHERE non_idx_col=0” I use this...
by Peter Zaitsev | May 1, 2008 | Uncategorized
Sun is aggressively pushing T2000 as Scalable MySQL Platforms, and indeed it is Scalable in terms of high concurrency workloads – it is able to execute a lot of concurrent threads and so speed gain from 1 thread to say 32 thread will be significant. But thing a...
by Peter Zaitsev | Apr 30, 2008 | Percona Events
People frequently ask me if the fact we keep information public can hurt our consulting business ? Lets keep aside for the moment amount of new business publishing this information brings to us but think it also have significant negative effect because people find...
by Peter Zaitsev | Apr 30, 2008 | Percona Events
If you’ve missed our presentations on MySQL Users Conference you can catch up now by taking a look at the slides, which are now published in presentations section of our company web site. You can also find a lot of old presentations in the same location. Enjoy...
by Peter Zaitsev | Apr 28, 2008 | Insight for DBAs
Well these days we see a lot of post for and against (more, more) using of MySQL and DRBD as a high availability practice. I personally think DRBD has its place but there are far more cases when other techniques would work much better for variety of reasons. First let...
by Baron Schwartz | Apr 28, 2008 | Insight for Developers
In my post on estimating query completion time, I wrote about how I measured the performance on a join between a few tables in a typical star schema data warehousing scenario. In short, a query that could take several days to run with one join order takes an hour with...
by Peter Zaitsev | Apr 26, 2008 | Hardware and Storage
Let us talk few more about disks. You might have read my previous post and Matt’s Reply and it looks like there are few more things to clarify and explain. Before I get to main topic of the article lets comment on IO vs Disk question. If you look at Disk Based...
by Peter Zaitsev | Apr 25, 2008 | Hardware and Storage
I read very nice post by Matt today and it has many good insights though I can’t say I agree on all points. First there is a lot of people out where which put it as disk is everything. Remember Paul Tuckfield saying “You should ask how many disks they have...
by Peter Zaitsev | Apr 24, 2008 | Percona Events
Friday after MySQL Users Conference we had a smaller meeting at Google campus to talk about MySQL architecture mainly focusing on storage engine vendors and other extension areas. It was very interesting to see all these storage engine interface extensions which are...
by Maciej Dobrzanski | Apr 24, 2008 | Percona Software
A few weeks ago I was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW...
by Peter Zaitsev | Apr 23, 2008 | Insight for Developers
Sometimes you have the task of storing multiple of boolean values (yes/now or something similar) in the table and if you get many columns and many rows you may want to store them as efficient way as possible. For MyISAM tables you could use BIT(1) fields which get...
by Peter Zaitsev | Apr 23, 2008 | Percona Events
If you’re following PlanetMySQL you’ve already seen Baron’s post about MySQL Conference which many of us just have returned from. It was great event as well as 5 conferences I’ve been before that, though however it more and more becomes MySQL...
by Alexey Kovyrin | Apr 23, 2008 | Benchmarks, Insight for DBAs
In one of his recent posts Vadim already gave some information about possible benefits from using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could be useful for large warehousing tasks. One...
by Vadim Tkachenko | Apr 23, 2008 | Insight for DBAs
New features of InnoDB – compression format and fast index creation sound so promising so I spent some time to research time and sizes on data we have on our production. The schema of one of shards is CREATE TABLE `article87` ( `id` bigint(20) unsigned NOT NULL,...
by Baron Schwartz | Apr 22, 2008 | Insight for DBAs
Have you ever run a query in MySQL and wondered how long it’ll take to complete? Many people have had this experience. It’s not a big deal until the query has been running for an hour. Or a day and a half. Just when IS that query going to finish, anyway?...
by Vadim Tkachenko | Apr 20, 2008 | Insight for DBAs
It seems there is interesting problem with compatibility of MySQL binaries and binaries of third-party plugins. I personally found and there is confirmation from InnoDB team that current InnoDB-plugin binaries do not work with lastest 5.1.24-rc binaries. It was very...
by Maciej Dobrzanski | Apr 20, 2008 | Percona Software
For a couple of months there have been no updates to our msl patch, however recently I managed some time to change this. The functionality was extended a little bit and what’s even more important the patch is available for all the recent MySQL releases. To remind...
by Peter Zaitsev | Apr 18, 2008 | Insight for Developers
MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as VARBINARY but I think it is not enough 🙂 I would also like to see type HEXCHAR which would be able to store hex strings, such as those returned as MD5() and...
