Category Archives: mysql

You know you have really screwed up when …

You crash MySQL/Innodb and you trace the error to a function that says: “This function checks the consistency of an index page when we do not know the index. This is also resilient so that this should never crash even … Continue reading

Posted in innodb internals, Matt, mysql, Waffle Grid | Comments Off on You know you have really screwed up when …

Waffle Grid Like Features in EnterpriseDB

Yves pointed this out to me: http://www.internetnews.com/software/article.php/3825426/ “Moving beyond just providing Oracle compatibility, EnterpriseDB is adding new scalability features to their database. One of them is a feature called ‘”Infinite Cache,” which is based on the open source memcached application. … Continue reading

Posted in mysql, performance, Waffle Grid | Comments Off on Waffle Grid Like Features in EnterpriseDB

Testing Waffle

So Ronald Bradford has been getting some EC2 AMI’s setup for Waffle the last couple of days. Really he is the first person to work with us on testing out the 0.5 cream release. It’s funny but when you are … Continue reading

Posted in Matt, mysql, Waffle Grid | 1 Comment

MyISAM with key_buffer larger than 4 GB

In many applications, MyISAM can be used successfully if the proportion of write operations is only a small fraction of the read operations. As the tables grow, the 4 GB limitation in the key_buffer size caused performance issues and other … Continue reading

Posted in mysql, performance, yves | 5 Comments

5 Minute DBA MyISAM Example Config Files

I have been asked this numerous times ever since I posted my InnoDB sample configuration files, Do I have sample configuration parameters for a MyISAM setup? We are seeing less and less people use MyISAM, but it is still popular … Continue reading

Posted in 5 minute dba, Matt, mysql | 4 Comments

Leaving Sun/MySQL but not the community

I thought I would put out a quick note about this right now, I am going to be leaving Sun next week. I do have some plans which will start to materialize over the next few weeks and months so … Continue reading

Posted in Matt, mysql, personal | 2 Comments

WaffleGrid: Cream Benchmarks, stable and delivering a 3x boost

Lets get down to how the latest version of Waffle Grid performs. Starting off simple lets look at the difference between the wafflegrid modes. As mentioned before the LRU mode is the “classic” Waffle Grid setup. A page is put … Continue reading

Posted in benchmark, Matt, mysql, performance, Waffle Grid | Comments Off on WaffleGrid: Cream Benchmarks, stable and delivering a 3x boost

WaffleGrid: 0.5 Cream Release

I wanted to let everyone know that we are releasing Waffle Grid 0.5 code named Cream. This release fixes the nasty secondary index bug that plagued the butter release. I have been running tests on this code base for about … Continue reading

Posted in Matt, mysql, performance, Waffle Grid | 1 Comment

Be Wary of Large Log File Sizes

As some people have mentioned here and here Increasing the innodb log file size can lead to nice increases in performance. This is a trick we often deploy with clients so their is not anything really new here. However their … Continue reading

Posted in 5 minute dba, Common Mistakes, Matt, mysql, performance | 1 Comment

Waffle: Progress and a Rearchtecture?

So I spent several hours over the last few days on the Secondary index bug. Out of frustration I decided to try and bypass the LRU concept all together and try going to a true secondary page cache. In standard … Continue reading

Posted in benchmark, innodb internals, linux, Matt, mysql, Waffle Grid | 1 Comment