by Peter Zaitsev | Jul 4, 2007 | Insight for DBAs
I’ve read through Top 5 (or more) wishes posted by number of MySQL employees as well as by a lot of community members. It was great to see so wide coverage as people with different backgrounds wish different things – Developers have some wishes to ease...
by Peter Zaitsev | Jul 3, 2007 | Percona Events
Vadim and me will be speaking on OSCON 2007, taking place in Portland,OR July 23-27. Our talk will be about Open Source Transactional Storage Engines meaning Innodb, Falcon, Solid and PBXT. We’ll look into architecture of these storage engines as well as compare...
by Peter Zaitsev | Jul 1, 2007 | Insight for Developers
On many web sites you would see a counter how many time given object – blog post, forum thread, image, movie etc was viewed. This is sometimes handy feature but it can be rather expensive from performance point of view. The nasty thing with counters as they are...
by Peter Zaitsev | Jun 29, 2007 | Insight for DBAs
About a week ago Marten send me email pointing to his article published on Jays Blog (Come on Marten, it is time for you to get your own blog). I should have replied much earlier but only found time to do that now. So here is my list 1. Be Pluggable Unlike many...
by Peter Zaitsev | Jun 26, 2007 | Insight for DBAs
I ran into pretty interesting behavior today. We needed to dump and reload large database and we had pretty good IO subsystem so we started number of mysqldump processes in parallel. Unlike in other case when we did load in parallel, dump in parallel did not increase...
by Peter Zaitsev | Jun 25, 2007 | Insight for DBAs
One may think one may use MySQL Slow query log to log all slow queries to catch problematic queries or for audit purposes. In fact however not all the queries are logged. I already mentioned mysql slave queries are not logged to slow query log and it looks like I was...
by Peter Zaitsev | Jun 18, 2007 | Insight for Developers
I prefer to use Integers for joins whenever possible and today I worked with client which used character keys, in my opinion without a big need. I told them this is suboptimal but was challenged with rightful question about the difference. I did not know so I decided...
by Peter Zaitsev | Jun 16, 2007 | Insight for Developers
Just found this little handy feature today: mysql> insert into c select rand()*1000, sha1(rand()) from c; Query aborted by Ctrl+C ERROR 1317 (70100): Query execution was interrupted 123 mysql> insert into c select rand()*1000, sha1(rand()) from c;Query aborted...
by Peter Zaitsev | Jun 16, 2007 | Insight for DBAs
I filed the following bug today. Basically it looks like in certain conditions Innodb may be started twice in the parallel on the same data files which can hurt database badly. It is true it does not seems to be 100% repeatable but I’ve seen it multiple times in...
by Peter Zaitsev | Jun 15, 2007 | Hardware and Storage
In the previous post I mentioned not all architectures and solutions work for Commodity People, and people seems to agree with me. Number of vendors would claim they are in Commodity Software or Hardware business but few would probably mention they are doing it for...
by Peter Zaitsev | Jun 12, 2007 | Hardware and Storage
Just found this wonderful summary of articles by Jeremy and wanted to give some of my thoughts on the topic. First lets speak about death of the RAID. I think this is far from the case especially if you consider Software RAID here. For many workloads you would like to...
by Peter Zaitsev | Jun 12, 2007 | Insight for Developers
To be honest I’m not a big fan of Stored Procedures, at least not in the form they are currently implemented in MySQL 5.0 Only SQL as a Language Which is ancient ugly for algorithmic programming and slow. It is also forces you to use a lot of foreign constructs...
by Peter Zaitsev | Jun 6, 2007 | Insight for DBAs
This week I already had two serious performance regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often see for simple queries due to generally fatter code. The problem in...
by Vadim Tkachenko | Jun 6, 2007 | Insight for DBAs
Just short message that patch enables microsecond resolution in slow-log (see more https://www.percona.com/blog/2006/09/06/slow-query-log-analyzes-tools/) for 5.0.37 is available here: www.percona.com/blog/files/patches/patch.slow-micro.5.0.37.diff The patch for...
by Peter Zaitsev | May 31, 2007 | Insight for DBAs
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions. We rarely would use this feature as it is incompatible with our slow query analyses patch and tools Fixing this is not trivial while staying...
by Peter Zaitsev | May 28, 2007 | Insight for DBAs
Reading this slashdot article today and two CIO magazine articles linked from it. Such discussions started at right place at right time always attract a lot of flamers and can be fun to read. What hit me this time is quality of the articles in CIO magazine. If this is...
by Peter Zaitsev | May 24, 2007 | Insight for DBAs
I had this question asked many times during last week, and there is really no easy answer. There are just way too many variables to consider especially while loading large schemas with a lot of different table structures. So which variables affect the load speed:...
by Peter Zaitsev | May 24, 2007 | Insight for DBAs
As I wrote we had been recovering corrupted Innodb Tablespace and it is finally done now. As this was over than 1TB worth of data we really tried to avoid dumping the data and find some other way to recovery. Examining Innodb page content and crash information we...
by Peter Zaitsev | May 24, 2007 | Percona Events
The consulting load keeps increasing so we’re looking for some help. This job would be perfect for someone interested in high performance and scaling with decent knowledge of MySQL and eagerness to learn more. We do encourage people from all countries to...
by Peter Zaitsev | May 22, 2007 | Insight for DBAs
Dealing with dumping and recovery of large and partially corrupted database I’ve got couple of feature ideas for mysqldump or similar tool and appropriate import tool Dump in parallel single thread dump is not efficient of course especially on systems with...
