Category Archives: yves

Filtering by table is now possible with WaffleGrid

Posted on July 9, 2009 by Yves Trudeau

Since I have been a home recently, I put some time correcting bugs in WaffleGrid and adding new features. Thanks to gdb, I have been able to understand a silly bug that was affecting WaffleGrid with sysbench but, weird enough, … Continue reading →

Posted in innodb internals, mysql, Waffle Grid, yves | 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

What’s up with WaffleGrid?

Posted on May 21, 2009 by Yves Trudeau

You probably haven’t noticed but I have not blogged since the UC. It is not because I am upset by the perspective of working for Oracle, I have simply been busy tracking down an issue we have with WaffleGrid. We … Continue reading →

Posted in mysql, Waffle Grid, yves | 6 Comments

Counting down the days before UC Time!!

Posted on April 18, 2009 by Matthew Yonkovit

One last reminder, we ( Yves and I ) will be appearing all over the place at the UC. Here is a quick run down of our schedule: Tuesday 10:50 am – 11:35 pm (Free MySQL Camp) I will be … Continue reading →

Posted in Matt, mysql, performance, Waffle Grid, yves | Tagged | Comments Off

Heterogeneous replication with NDB cluster

Posted on April 16, 2009 by Yves Trudeau

Recently, I was asked if it is possible to replicate an NDB cluster to a non-NDB MySQL database. So, I tried! I created the following table on the MySQL master: Create Table: CREATE TABLE `testrepl` ( `id` int(11) NOT NULL, … Continue reading →

Posted in mysql, NDB Cluster, yves | Comments Off

MySQL High availability with VCS cluster

Posted on April 8, 2009 by Yves Trudeau

At MySQL/Sun we do a lot of high availability setup using Heartbeat but recently I was involved, along with Harold Mayfield (a VCS expert), in project using Symantec VCS on Solaris. Of course, MySQL works perfectly well with VCS, here … Continue reading →

Posted in HA, mysql, yves | Comments Off

Social networking type queries with NDB (part 3)

Posted on April 2, 2009 by Yves Trudeau

In the previous 2 posts of this series, we basically talked about how to execute social networking type queries using SQL IN clause and how handle multiple columns IN clause. In this last post on the topic, I will introduce … Continue reading →

Posted in HA, mysql, NDB Cluster, yves | Comments Off

Upcoming webinar on NDB Cluster 7.0 new features

Posted on April 1, 2009 by Yves Trudeau

I just learned that there will be a Webinar “What’s New in the Next Generation of MySQL Cluster?”, April 30th. From what I know, the webinar is supposed to be at a good technical level, it is not a marketing … Continue reading →

Posted in mysql, NDB Cluster, yves | Comments Off

vmplot.sh, a useful tool for MySQL performance tuning

Posted on March 30, 2009 by Yves Trudeau

I don’t know if it is because of my science background, I am a physicist, I do like graphs, especially when I do performance tuning. With UNIX like operating systems, the vmstat command give you an easy way to grab … Continue reading →

Posted in benchmark, linux, mysql, performance, yves | Comments Off

Efficient sequences with MySQL

Posted on March 26, 2009 by Yves Trudeau

As you probably now if you reading this blog, MySQL does not support SQL sequences. Logically, it is very easy to implement something equivalent to a sequence using transaction with InnoDB with a simple 2 columns table, name and value. … Continue reading →

Posted in mysql, yves | 5 Comments