Performance of separate application and database servers vs all-in-one

We are migrating an existing application that requires a decent database setup. We've run a simple mysqlslap test on two server configurations - combined app & db server, separate app & 2 db...

Docker container IO performance

I am trying to investigate the IO performance overhead of docker so I created a mysql docker container on a specific machine and I ran the sysbench mysql benchmark to measure IO performance....

Upgrade to a faster server but MySQL server is getting slower

Due to our business expansion, we decided to upgrade our web application + database server, we had : CPU : Intel(R) Xeon(R) CPU E3-1245 V2 @ 3.40GHz (8 cores) RAM : 32 GB HDD : 2*3 TB in RAID...

Benchmarking Mysql cluster using sysbench

When benchmarking a mysql clustering using sysbench, do you have to install sysbench on every machine in the cluster to benchmark the cluster performance? Is there a way to install sysbench on one...

Poor HDFS performances: "Slow BlockReceiver write packet to mirror"

I'd like to submit a strange behavior while instanciating another new Hadoop cluster, on a new hardware stack. Once everything got installed, as soon as we try to perform any I/O operation on...

Maxscale lost connection

I'm currently testing Maxscale with a Galera Cluster of 3 nodes in Read/Write Split mode. By default, Maxscale defines one node as a master and the other as slaves (my configuration says 100% of...

Unusual sysbench results Raspberry Pi

I have 2 raspberry pi's that I wanted to benchmark for load balancing purpose. Raspberry pi Model B v1.1 - running Raspbian Jessie Raspberry pi Model B+ v1.2 - running Raspbian Jessie I...

Linux: CPU benchmark requiring longer time and different CPU utilization levels

For my research I need a CPU benchmark to do some experiments on my Ubuntu laptop (Ubuntu 15.10, Memory 7.7 GiB, Intel Core i7-4500U CPU @ 1.80HGz x 4, 64bit). In an ideal world, I would like to...

Scripts and Dockerfile

I am trying to run a mysql benchmark (sysbench) inside my docker container. The script works well and performs the benchmark while running in the host terminal but when I try to run it inside a...

Galera is 3x slower than standalone with durable settings, high CPU idle

I am evaluating the Galera Cluster and I can't explain myself the testing results. When comparing a single-node Galera with a standalone MariaDB 10.1.20, I have noticed a suspiciously big...

fio benchmark configuration

I'm doing some I/O tests with different benchmarks and I want to compare the results; in detail, I'm using sysbench and fio and doing random read/write tests. With sysbench i have a read/write...

Linux-based (Docker + LXC) container benchmarking

I'm trying to do some benchmarking tests and then compare the results between LXC and Docker. So far I've come across some tools that help with what I need, i.e. sysbench, apache -ab, and netperf...

Failure to create a job in kubernetes due to error

When creating a Job in kubernetes 1.6, the following error occurs: Error from server (BadRequest): error when creating "job.yaml": Job in version "v1" cannot be handled as a Job: [pos 217]:...

Sysbench:which value should I look at for CPU benchmarking?

sysbench version: 1.0.7 OS: macOS 10.11.6 No matter where I ran sysbench cpu run I get very similar results like the following. sysbench 1.0.7 (using bundled LuaJIT 2.1.0-beta2) Running the test...

Cannot Find oltp test on sysbench

I'm trying to run benchmark on mySQL database using sysbench. However, it says it cannot find built-in test oltp. Detail: I've installed mySQL, and sysbench on my local machine. Also, I've created...

MySQL 5.7 3x slower than 5.5 for same test suite

I recently upgraded my machine from: i7-860 (12GB RAM, 120GB SSD) running Ubuntu 14.04 and MySQL 5.5 (OLD) To a new machine: i7-7560U (16GB RAM, 512GB SSD) running Ubuntu 16.04 and MySQL 5.7...

sysbench connect error - MySQL 8

This sysbench test fails even though my other mysql 8 clients connect just fine from this same bash session to MySQL 8. I have checked the following: sestatus : is disabled permissions is fine on...

How to run two commands, but with a delay on the second command without stopping the first command?

I'm trying to do the following (on a Raspberry Pi 3 with Raspbian OS): start a benchmark (sysbench) then run some monitoring tools (iostat and mpstat) after some delay, say 5s, as a warm-up...

MySQL 8.0 Group by Performance

To compare MySQL 5.7 and 8.0 I created a table using sysbench. And I tried the test. The performance of the server is exactly the same As a result, oltp_point_select showed almost similar...

Docker resource limit switch --cpus=1 is causing a large performance loss in MySQL

I have MySQL (5.7) running in a Docker (18.03.1-ce) container and I'm benchmarking it using Sysbench (1.0.15). When I run Docker with --cpus=1 to limit the cpu utilization of the container, I get...

How to get better performance for local SSD disk on GKE?

I'm running a sysbench OLTP benchmark with TiDB on GKE local SSD disk. But I'm getting poor performance compared to GKE persistent SSD disk. How can I get the expected IOPS performance on GKE...

Benchmark MySQL with batch insert on multiple threads within same table

I want to test high-intensive write between InnoDB and MyRock engine of the MySQL database. For this purpose, I use sysbench to benchmark. My requirements are: multiple threads concurrency write...

Performance Comparison: mysql:5.7 vs mysql/mysql-server:5.7 docker builds

I have tried to decide between mysql:5.7 and mysql/mysql-server:5.7 Docker images using sysbench tests. The results are copied below. Is there a reason that mysql:5.7 seems to be faster...

How to use variable value for shell command in python?

I have one shell command that uses some argument that is being invoked from Python script : cmd = 'sysbench --test=cpu --cpu-max-prime=20000 --num-threads=2 run > cpu_sysbench.txt' Now I wanted...

How to change the read/write ratio of sysbench oltp_read_write script

I'm using the sysbench(1.1.0) to test the performance of MySQL, and I want to test the scene that read:write is 95%:5%. Are there any parameters to change the read/write ratio?

How could database have worse benchmark results on faster disk?

I'm benchmarking comparable (2vCPU, 2G RAM) server (Ubuntu 18.04) from DigitalOcean (DO) and AWS EC2 (t3a.small). The disk benchmark (fio) goes inline with the results of...

Sysbench on Azure MySQL - SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query

I am having trouble with running sysbench on Azure DB for MySQL. I have a sysbench server on a Azure VM which I am using to connect to Azure MySQL server through remote host. I have used this same...

The CPU cache performance of the macOS virtual machine is about 50% less than the host machine

I built a macOS virtual machine and an ubuntu virtual machine on the same host. The configuration of the two virtual machines is almost the same. But when I using sysbench to test the performance...

Convert sysbench cumulative summary to csv

I'm trying to create graphs with sysbench cumulative output, so that I can compare results of different benchmarks. So far have been able to generate csv files with intermediate statistics using...

New AWS EC2 EBS gp3 volumes are slow

Running sysbench against volumes I'm finding the gp3 volumes are much slower. Even when I provision a volume with 16000IOPS after waiting for optimization I'm getting a cap at 1000 IOPS when...