Category Archives: performance

Speaking @ Percona Live in London Next Week!

Posted on October 22, 2011 by Matthew Yonkovit

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

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

Posted on March 29, 2010 by Matthew Yonkovit

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

Posted on March 29, 2010 by Matthew Yonkovit

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

Posted on July 10, 2009 by Matthew Yonkovit

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

Waffle Grid Like Features in EnterpriseDB

Posted on June 18, 2009 by Matthew Yonkovit

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

MyISAM with key_buffer larger than 4 GB

Posted on June 11, 2009 by Yves Trudeau

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

Posted on June 7, 2009 by Matthew Yonkovit

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

WaffleGrid: 0.5 Cream Release

Posted on June 6, 2009 by Matthew Yonkovit

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

Posted on June 2, 2009 by Matthew Yonkovit

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

Posted on May 21, 2009 by Matthew Yonkovit

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