Category Archives: yves

Filtering by table is now possible with WaffleGrid

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 on Filtering by table is now possible with WaffleGrid

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

What’s up with WaffleGrid?

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!!

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 on Counting down the days before UC Time!!

Heterogeneous replication with NDB cluster

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 on Heterogeneous replication with NDB cluster

MySQL High availability with VCS cluster

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 on MySQL High availability with VCS cluster

Social networking type queries with NDB (part 3)

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 on Social networking type queries with NDB (part 3)

Upcoming webinar on NDB Cluster 7.0 new features

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 on Upcoming webinar on NDB Cluster 7.0 new features

vmplot.sh, a useful tool for MySQL performance tuning

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 on vmplot.sh, a useful tool for MySQL performance tuning

Efficient sequences with MySQL

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