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...
by Andrew Aksyonoff | Mar 27, 2007 | Insight for Developers
by Peter Zaitsev | Mar 27, 2007 | Insight for Developers
One may think changing PHP session handler from file based to database driven is fully transparent. In many cases it is, sometimes however it may cause some unexpected problems as happened to one of our customers. If you use file based sessions PHP will lock session...
by Peter Zaitsev | Mar 26, 2007 | Insight for Developers
Working with various projects using MySQL I observe a lot of problems are coming from very simple fact – product is designed containing features which developers do not know how to implement effectively. In many companies you would see “waterfall”...
by Peter Zaitsev | Mar 23, 2007 | Insight for DBAs
During last couple of months I had number of consulting projects with MySQL Query Cache being source of serious problems. One would see queries both for MyISAM and Innodb tables mysteriously stalling for few seconds with “NULL” in State column. These could...
by Peter Zaitsev | Mar 19, 2007 | Percona Events
I’ve already wrote we do not generally do a lot of on-site onsite consulting, but as I’m anyway going to be speaking at MySQL Users Conference anyway it may be good time for some onsite jobs. In fact I have already scheduled visits on Friday, Monday and...
by Peter Zaitsev | Mar 18, 2007 | Percona Events
Few days ago MySQL released MySQL 5.0.37 which I would call first real Community Version, because unlike previous versions which were released from the same source tree as Enterprise MySQL this one has some community features added, which is great. Also over last half...
by Peter Zaitsev | Mar 15, 2007 | Insight for DBAs
Reading last few days worth of planet MySQL and commenting on some entries as you can see. The post by Oli catches my attention. There is also PDF with more details available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow...
by Peter Zaitsev | Mar 15, 2007 | Insight for DBAs
Looking at post by Konstantin Osipov we should finally get Query Cache working with prepared statements in MySQL 5.1 The interesting thing Konstantin notes it just took few days to fix it – I believe MySQL Support Team alone spent much more times explaining...
by Peter Zaitsev | Mar 15, 2007 | Percona Events
We’d like to test few things in regards to MySQL and Innodb scalability with multiple CPUs but we seems to be short of boxes right now, all stuff we have access to is in production right now which makes it not good for benchmark. Could anyone lend us access to...
