By JortK on February 19, 2010
As I wrote about 2 years ago the feature of Innodb to store copy of master’s position in Slave’s Innodb tablespace got broken. There is a lot of discussions at the corresponding bug report while outcome of the fix remained uncertain for me (the bug is market duplicate while the bugs it seems to be [...]
Posted in MySQL | Tagged innodb, MySQL, performance
By JortK on February 11, 2010
I’m running in this misconception second time in a week or so, so it is time to blog about it. How blobs are stored in Innodb ? This depends on 3 factors. Blob size; Full row size and Innodb row format. But before we look into how BLOBs are really stored lets see what misconception [...]
Posted in MySQL | Tagged blob, innodb, MySQL, storage
By JortK on January 21, 2010
Read the complete article on the MySQL Performance Blog
Posted in MySQL | Tagged backup, compress, innodb, MySQL
By JortK on January 9, 2010
Some great articles on how to improve the performance of your MySQL Server: Optimize slow queries with mk-query-digest Use delayed flushing table_cache negative scalability How innodb_open_files affect performance Use of table_cache Thanks to MySQLPerformanceblog.com!
Posted in MySQL | Tagged flushing, innodb, MySQL, performance, sql
By JortK on December 22, 2008
Because I’m running a project which has a relative large database (tables with 70.000.000 records in them), I wanted to know which was faster in performance, MyISAM or InnoDB. Currently I’m using MyISAM, and I’m running into some performance and stability issues. First, I’ve created a table with a few columns:
Posted in MySQL | Tagged benchmark, database, innodb, myisam, MySQL, performance, sql, storage engines