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...
by Vadim Tkachenko | May 3, 2007 | Insight for DBAs
Today everybody writes about MySQL Conference & Expo and I am not an exclusion. I am under impression of count of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage...
by Peter Zaitsev | May 2, 2007 | Percona Events
I can’t write I’m just back from MySQL Users Conference both because I’m still in USA visiting customers and because it has ended almost a week ago but I was too busy to write anything about it or post my presentations. This was my 5th MySQL Users...
by Peter Zaitsev | Apr 20, 2007 | Percona Events
So I’m back from RIT2007 which took place April 16,17 in Moscow,Russia. The conference was well organized, while the conference center was a bit small for event – halls were jam packed during the breaks and there was limited sitting available for many...
by Peter Zaitsev | Apr 11, 2007 | Insight for Developers
I’ve got an interesting comment the other day saying “I’ve heard Jay Pipes saying indexes with cardinality lower than 30% are worthless, true?” That is interesting question and it has different answers depending on who is asking. A lot of...
by Peter Zaitsev | Apr 10, 2007 | Insight for Developers
Looking at how people are using COUNT(*) and COUNT(col) it looks like most of them think they are synonyms and just using what they happen to like, while there is substantial difference in performance and even query result. Lets look at the following series of...
by Vadim Tkachenko | Apr 8, 2007 | Benchmarks
The PBXT Storage Engine (http://www.primebase.com/xt/) is getting stable and we decided to benchmark it in different workloads. This time I tested only READ queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon...
by Peter Zaitsev | Apr 6, 2007 | Insight for DBAs
I just found post by Kevin, in which he criticizes Master-Master approach, finding Master with many slaves more optimal. There is surely room for master-N-slaves systems but I find Master-Master replication much better approach in many cases. Kevin Writes “It...
by Peter Zaitsev | Apr 6, 2007 | Insight for Developers
In many Search/Browse applications you would see main (fact) table which contains search fields and dimension tables which contain more information about facts and which need to be joined to get query result. If you’re executing count(*) queries for such result...
by Peter Zaitsev | Apr 5, 2007 | Insight for DBAs
The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some internal scripts to handle things as automatic fallback and slave cloning but no Open Source...
by Peter Zaitsev | Mar 29, 2007 | Percona Events
I’ve been invited to speak at RIT-2007 which stands for “Russian Internet Technologies” conference. It takes place 16-17 April in Moscow, Russia. It looks like this is going to be biggest Russian conference on Internet technologies so far with many...
by Peter Zaitsev | Mar 28, 2007 | Insight for DBAs
I just filed a bug regarding slow queries executed by replication thread are not being logged to the slow query log. This is not a big deal but it is ugly little gotcha which I think few people know about. It is especially bad if you’re using tools to analyze...
