EmergencyEMERGENCY? Get 24/7 Help Now!

Using NVMe Command Line Tools to Check NVMe Flash Health

 | February 9, 2017 |  Posted In: Hardware and Storage, Insight for DBAs, MongoDB, MySQL

NVME

In this blog post, I’ll look at the types of NVMe flash health information you can get from using the NVMe command line tools. Checking SATA-based drive health is easy. Whether it’s an SSD or older spinning drive, you can use the smartctl command to get a wealth of information about the device’s performance and health. […]

Read More

How to improve InnoDB performance by 55% for write-bound loads

 | May 23, 2014 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL, Percona Live

Update: do not do this, this has been proven to corrupt data!   During April’s Percona Live MySQL Conference and Expo 2014, I attended a talk on MySQL 5.7 performance an scalability given by Dimitri Kravtchuk, the Oracle MySQL benchmark specialist. He mentioned at some point that the InnoDB double write buffer was a real […]

Read More

Beware: ext3 and sync-binlog do not play well together

 | January 21, 2009 |  Posted In: Hardware and Storage

One of our customers reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system with RAID and BBU were expected to have much better performance. The problem could be repeated with SysBench as follows:

Read More

Scaling to 256-way the Sun way

 | November 11, 2008 | 

As you may have recently seen there are some articles about scaling MySQL one 256-way system. I though wow did they really make it work, considering how many bottlenecks remain in MySQL. What article really tells us ?

Read More

128GB or RAM finally got cheap

 | August 4, 2008 |  Posted In: Hardware and Storage

I did not usually go to “Elite” servers on Dell web site but looking at customers system today I went to check Dell Poweredge R900. This monster takes up to 4 Quad Core CPUs and has 32 memory slots, which allows to get 128GB of memory with 4GB of memory chips. This means upgrade to […]

Read More

T2000 CPU Performance – Watch out

 | May 1, 2008 | 

Sun is aggressively pushing T2000 as Scalable MySQL Platforms, and indeed it is Scalable in terms of high concurrency workloads – it is able to execute a lot of concurrent threads and so speed gain from 1 thread to say 32 thread will be significant. But thing a lot of people miss is – Being […]

Read More

MySQL Performance on Memory Appliance

 | March 31, 2008 |  Posted In: Benchmarks

Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had a chance to do some benchmarks on my own. 2*Quad Core Xeon […]

Read More

Big Iron for tests anyone ?

 | March 20, 2008 | 

MySQL Users Conference is coming and with it my presentation about Innodb Scalability limits. We did bunch of tests but we surely could get benefit of some extra hardware for testing, so if you could provide us with dedicated remote access for benchmarks it would be great. Here is what we’re looking for in particular: […]

Read More