We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM scalability question. This time working on the customer system we figured out that box with 1 CPU Core [...]
Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
Many Open Source software solutions use database per user (or set of tables per user) which starts to cause problems if it is used on massive scale (blog hosting, forum hosting etc), resulting of hundreds of thousands if not millions of tables per server which can become really inefficient. It is especially inefficient with Innodb [...]
InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
If you like to compile MySQL from sources by yourself, for different needs, like debugging, testing etc, you probably can face this issue. What I usually do to fast compile and test is
1 2 3 | ./configure --prefix=/dir/to/mysql make make install |
and then, for example, load the dump of InnoDB from previous version:
1 | mysql testdatabase < dump.sql |
I bet you will not notice all your [...]
Pitfalls of converting to InnoDB
February 25, 2007 By 16 Comments
We often recommend to our clients to convert their current database from MyISAM tables to InnoDB. The transfer by itself in most cases is almost plain, however the application can be broken by new unexpected errors 1205 (ER_LOCK_WAIT_TIMEOUT) Lock wait timeout expired. Transaction was rolled back. 1213 (ER_LOCK_DEADLOCK) Transaction deadlock. You should rerun the transaction.
