Stack Overflow
Stack Overflow

Questions tagged [sysbench]

SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load.

SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load.

The main features include

* file I/O performance
* scheduler performance
* memory allocation and transfer speed
* POSIX threads implementation performance
* database server performance (OLTP benchmark)
27 questions
9
votes
2 answers

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 database dbtest inside the mySQL. And then I…
Kyungsu Stanley Kim
  • 195
  • 1
  • 1
  • 10
8
votes
0 answers

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 the slaves). My intend is to check how Maxscale…
user494599
4
votes
1 answer

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 monitoring through Percona PMM, New Relic…
tippingpints
  • 49
  • 1
  • 2
2
votes
1 answer

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 to the same table. support batch insert (each insert…
Trần Kim Dự
  • 5,872
  • 12
  • 55
  • 107
2
votes
0 answers

Sysbench Memory Test

I have done memory test on my cloud instance with Sysbech utility. Using following command: sysbench --test=memory --memory-block-size=1K --memory-scope=global --memory-total-size=100G --memory-oper=write run During the Run: TOP command result I…
Mangesh
  • 31
  • 4
1
vote
1 answer

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 hooks in lua scripts. I'm not able to do the same with…
Gianluca
  • 21
  • 2
1
vote
0 answers

Is there major difference in underlying implementation of the following sysbench versions: 0.4.12 vs 1.0.17

I am using sysbench to profile the CPU performance of my two NXP IMX based devices. One is IMX6 and the other one is IMX8. I tried running the following command on both the devices. IMX8 :sysbench --num-threads=4 --validate=on --test=cpu…
HARSH PANDEY
  • 53
  • 7
1
vote
1 answer

MySQL 5.7 Docker version has lower transaction than the localhost version

My VM is Ubuntu 18.04 and I install 2 instances of MySQL 5.7. The first is installed in the localhost (port 3306), the second is installed via docker-compose (port 57306). The configurations cnf (which is from the default install of the localhost…
sutonium
  • 51
  • 4
1
vote
0 answers

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 sysbench server setup to benchmark another VM on…
Karthik Poojary
  • 11
  • 2
1
vote
1 answer

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?
Guoqing Ma
  • 41
  • 5
1
vote
0 answers

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 (transactions per sec (3395.53 per sec. vs 2963.84 per sec.)…
imriss
  • 1,815
  • 4
  • 31
  • 46
1
vote
3 answers

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 with following options: Number of threads:…
kimh
  • 719
  • 2
  • 9
  • 15
1
vote
0 answers

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 container I get an error as: FATAL: unable to connect…
Ranjan Dhar
  • 21
  • 4
1
vote
0 answers

What is the mean of NUM_LOADER_THREADS and NUM_WRITER_THREADS in sysbench-mongodb?

I use the sysbench-mongodb to test the performance of mongodb, and the tool has a config file named config.bash. In this file has two parameter: # total number of simultaneous insertion threads (for loader) # valid values : integer > 0 export…
Xiang Wang
  • 11
  • 2
0
votes
0 answers

The --config-file option does not work in sysbench 1.1.0

I have encountered an issue with sysbench 1.1.0 where the configuration parameters specified in the configuration file using the --config-file option are not taking effect. I have specified the following configuration…
keyao li
  • 1
1
2