Posts have something to do with hardware issues
In this blog post, we’ll look at the performance hit from the Spectre bug fix on Ubuntu.
Recently we measured the performance penalty from the Meltdown fix on Ubuntu servers. It turned out to be negligible.
Today, Ubuntu made a Spectre bug fix on Ubuntu available, shipped in kernel 4.4.0-112. As with the Meltdown fix, we […]
In this blog post, we examine the recent revelations about CPU security vulnerabilities.
The beginning of the new year also brings to light fresh and new CPU security vulnerabilities. Today’s big offenders originate on the hardware side – more specifically, the CPU. The reported hardware kernel bugs allow for direct access to data held in the […]
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. […]
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 performance […]
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:
Shell
./sysbench –num-threads=2 –test=oltp –oltp-test-mode=complex –oltp-table-size=100000 –oltp-distinct-ranges=0 –oltp-order-ranges=0 –oltp-sum-ranges=0 –oltp-simple-ranges=0 –oltp-point-selects=0 –oltp-range-size=0 –mysql-table-engine=innodb […]
Read moreOne typical question which frequently pops up is whenever it is better to use hardware upgrade or optimize software more. I already wrote about it, for example here.
Today I’ll look at the same topic from the consultants view. When consultant should suggest hardware upgrade and when it is not in a simple […]
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 ?
(more…)
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 […]
Read moreThis article is not meant to malign hosting providers, but I want to point out something you should be aware of if you’re getting someone else to build and host your servers for you.
Most hosting providers — even the big names — continue to install 32-bit GNU/Linux operating systems on 64-bit hardware. This […]
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 […]
