Category Archives: performance

Speaking @ Percona Live in London Next Week!

A quick note, I am speaking at Percona live in London next week… its should be a rip roaring time. I have two topics I am speaking on. The first is on building a MySQL Data Access Layer with Ruby … Continue reading

Posted in Matt, mysql, NOSQL, performance | Comments Off on Speaking @ Percona Live in London Next Week!

More Debate, More Flame, More Choosing the correct tool for the job

You have to love all the debating going on over NOSQL -vs- SQL don’t you? With my UC session on choosing the right data storage tools ( does this sound better then SQL-vs-NoSQL?) I have been trying to stay current … Continue reading

Posted in benchmark, linux, Matt, mysql, NOSQL, performance | 1 Comment

New Benchmark I am working on that tests MYSQL -vs- NOSQL

I am giving a talk in a couple of weeks at the 2010 MySQL User Conference that will touch on use cases for NOSQL tools -vs- More relational tools, the talk is entitled “Choosing the Right Tools for the Job, … Continue reading

Posted in benchmark, linux, Matt, mysql, NOSQL, performance, Tokyo | 3 Comments

Huge Data -vs- The Database, how the industry is adapting in the face of the data explosion

Note This Article was actually written back in May after the UC at the request of Linux Magazine, through a series of events It went unpublished. Between then and now Jeremy ended up doing a great job covering most of … Continue reading

Posted in Matt, mysql, Other dbs, performance | Comments Off on Huge Data -vs- The Database, how the industry is adapting in the face of the data explosion

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

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

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

StorMan Adaptec Controller Cheatsheet

Not really a MySQL related topic, but so I do not forget later on and for those who end up working with the StorMan CLI to manage their controller cards I thought I would publish my quick down and dirty … Continue reading

Posted in hardware, linux, performance, raid | Comments Off on StorMan Adaptec Controller Cheatsheet