Monthly Archives: January 2009

Logging all the queries with MySQL 5.0

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…

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 on Webinars & Conference Sessions oh my…

e1000 InterruptThrottleRate

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

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

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 on Waffle Latency Stats

We need to rid the world of “DBAs”

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

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 on A Word about Simple MySQL Problem Detection and Benchmarking

Exciting, Fun, and Fast …

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 on Exciting, Fun, and Fast …

About FragmentLogFileSize and NoOfFragmentLogFiles

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