Category Archives: linux

The early end of the MiniWheatFS project for tmpfs with MySQL!!!

I am happy to say that I found a kernel level way to join a ramdisk (actually not a tmpfs strictly speaking) with a normal file system. This cut my motivation for the MiniWheatFS project by 99.999%. I recall that … Continue reading

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

Testing Performance on a Texas Memory System RAMSAN-500 pt3

This is part 3 in my RAMSan Series. While I am confident the read-only test was a reasonably good test ( I just needed to push more ), my mixed load test was marred by issues.  It was really a … Continue reading

Posted in benchmark, hardware, linux, Matt, mysql, performance, raid | Comments Off on Testing Performance on a Texas Memory System RAMSAN-500 pt3

Testing Performance on a Texas Memory System RAMSAN-500 pt2

This is part 2 of My RAMSan Series. In my normal suite of benchmarks I typically run dbt2 & sysbench oltp benchmarks next…  and I did run then, but to be honest they just weren’t that interesting.  They showed an … Continue reading

Posted in hardware, linux, mysql, performance, raid | Comments Off on Testing Performance on a Texas Memory System RAMSAN-500 pt2

Testing Performance on a Texas Memory System RAMSAN-500

Well its about time I posted this:)  This is part 1 of 3 in my Ramsan series. For those who have paid attention to my blog, know I love talking  IO!  I also love performance.  Absolutely love it.  Love disk, … Continue reading

Posted in hardware, linux, mysql, performance, raid | 7 Comments

5 Minute Linux Admin/DBA – What OS tools to use to monitor your database server

A very special 5 minute DBA post here, we are crossing over… sys admin & dba oh my! I tend to always look first at the OS, and then move over to looking at what is going on inside the … Continue reading

Posted in 5 minute dba, linux, mysql | 3 Comments

Introducing MiniWheatFS

It is well known that MySQL can use a lot of temporary files and that, using a ramdisk (tmpfs on Linux) can improve performance drastically as Matt has shown here. The problem with tmpfs is its limited size. You need … Continue reading

Posted in linux, mysql, performance, yves | 3 Comments

Linux Swappiness

Have you ever been upset by the Linux tendancy to swap… Especially when trying to allocate a large InnoDB buffer pool.. Look at the following output: yves@yves-laptop:~$ free total used free shared buffers cached Mem: 2041888 1991096 50792 0 52 … Continue reading

Posted in linux, mysql, NDB Cluster, performance, yves | 3 Comments

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

24 Hour DBT2 run on the Intel X-25M SSD

Following up on my previous post Peter asked if he could see a 24 hour run on the Intel drive…  took me a few days because I am doing some testing on a few other things, but I kicked a … Continue reading

Posted in hardware, linux, mysql, performance | 10 Comments

CPU Affinity for Interrupts

Thought I would throw this out here so I remember it, and it maybe useful for someone else.  During a session here at Sun’s CEC conference one of the presenter was talking about setting CPU affinity for hardware interrupts.  This … Continue reading

Posted in hardware, linux, mysql, performance | 2 Comments