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...
by Peter Zaitsev | May 22, 2007 | Insight for DBAs
I have not had a serious Innodb corruptions for a while, typically even if it happened it was some simple table related corruption which was easy to fix on table level. In couple of cases during last year when it was more than that we had backups and binary logs which...
by Peter Zaitsev | May 22, 2007 | Insight for DBAs
We have certain type of the table corrupting with Innodb, as it is limited to only one particular index on one particular table type it is likely to be Innodb bug but Heikki currently could not find what could be causing it. Happily as we have data stored in many...
by Peter Zaitsev | May 21, 2007 | Insight for DBAs
I generally find MySQL Sever sufficiently tested, meaning at least minor version upgrades rarely cause the problems. Of course it is not perfect and I remember number of big issues when some releases could not be used due to behavior changes in them and when something...
by Peter Zaitsev | May 17, 2007 | Percona Events
As you probably know MySQL is Running AdSense Ads on PlanetMySQL.org for last few months. When the project was just started it was Ad free. I’m curious If MySQL Really ask syndicated Blog owners if they would allow that or if they just hope if someone does not...
by Peter Zaitsev | May 14, 2007 | Insight for DBAs
I promised to write little articles about all storage engines which sessions I attended during MySQL Users Conference but I did not get too far yet, too busy. So today it is time for PBXT. I was very interested about session about PBXT because this is storage engine...
by Peter Zaitsev | May 9, 2007 | Insight for DBAs
I had the interesting customer case today which made me to do a bit research on the problem. You can create merge table over MyISAM tables which contain primary key and global uniqueness would not be enforced in this case, this is as far as most people will think...
by Peter Zaitsev | May 9, 2007 | Insight for DBAs
Today seems to be Innodb day in our Blog, but well this is the question which pops ups quite frequently in Innodb talks and during consulting engagements. It is well known to get better performance you should normally set innodb_log_file_size large. We however usually...
by Peter Zaitsev | May 9, 2007 | Percona Events
It might look like it is too late to write about stuff happened at Users Conference but I’m just starting find bits of time from processing accumulated backlog. The Theme of this Users Conference was surely Storage Engines both looking at number of third party...
by Peter Zaitsev | May 4, 2007 | Insight for DBAs
I’ve seen Windows Blue Screen of Death, stalled boot process or simply application error dialog on many big information screens in shops, airports and other places as well in other systems such as cache machines, airport self checking systems or photo print...
