Monthly Archives: January 2009

Logging all the queries with MySQL 5.0

Posted on January 28, 2009 by Yves Trudeau

With MySQL 5.1, getting and analyzing all the queries hitting the database is very easy even if you don’t have access to the MySQL enterprise Monitor.  You can either activate the general log or, my favourite option, activate the slow … Continue reading →

Posted in mysql, performance, script, yves | 4 Comments

Webinars & Conference Sessions oh my…

Posted on January 24, 2009 by Matthew Yonkovit

Lots of news… We will be giving a Webinar on Waffle Grid on Febuarary 17th , if you want to know more you can find more details  here …  Also as mentioned previously We will also be talking about Waffle … Continue reading →

Posted in mysql, Waffle Grid | Comments Off

e1000 InterruptThrottleRate

Posted on January 23, 2009 by Yves Trudeau

The e1000 Nic is very common and can be found in many servers.  During my last NBD cluster engagement, on a set of 5 Dell 1950 servers equipped with a quad e1000 Nic, we were trying to tune cluster performance … Continue reading →

Posted in linux, mysql, NDB Cluster, yves | 5 Comments

NDB Cluster and Max_rows

Posted on January 19, 2009 by Yves Trudeau

Just before Christmas, I was working with a client that needed to insert more than a billion rows into a NDB table. The cluster was big, 14 nodes, and after a few hundred millions rows, we got the following error: … Continue reading →

Posted in mysql, NDB Cluster, yves | 3 Comments

Waffle Latency Stats

Posted on January 14, 2009 by Matthew Yonkovit

At the hotel tonight playing around with adding some more stats for Waffle Grid.  I added memcached latency stats to the show innodb status: ——— MEMCACHED ——— Memcached puts    184434 Memcached hits    458 Memcached misses  183976 Memcached Get Total Latency … Continue reading →

Posted in mysql, Waffle Grid | Comments Off

We need to rid the world of “DBAs”

Posted on January 14, 2009 by Matthew Yonkovit

This may come as a complete shock based on the title of my website… but I have come to the conclusion that all DBA’s should be eliminated from all companies hierarchies. WHAT? Yep I do not think any company should … Continue reading →

Posted in mysql, oracle, rant, sql server | 3 Comments

A Word about Simple MySQL Problem Detection and Benchmarking

Posted on January 13, 2009 by Matthew Yonkovit

One of the services we (Sun/MySQL) offer is a Performance Tuning and Optimization consulting package. These consulting engagements generally take several different forms as each client has a specific need that must be resolved. But there is a commonality between … Continue reading →

Posted in Common Mistakes, mysql, performance, rant | Comments Off

Exciting, Fun, and Fast …

Posted on January 12, 2009 by Matthew Yonkovit

Some good news.  I have been able to secure some additional hardware for testing over the next few months.  First up I received a pair of Dolphin interconnect cards which I will be putting through the paces sooner rather then … Continue reading →

Posted in hardware, mysql, Waffle Grid | Comments Off

About FragmentLogFileSize and NoOfFragmentLogFiles

Posted on January 12, 2009 by Yves Trudeau

I was recently involved with a client that has to deal with a very large dataset  in MySQL NDB cluster.  The schema was very simple, a few (one or two) key columns and a large varbinary column.   The cluster was … Continue reading →

Posted in mysql, NDB Cluster, yves | 2 Comments