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
0
votes
1 answer

What is measured by changing the `file-block-size` parameter in sysbench fileio test?

I was trying to measure the system performance with sysbench fileio test. However, I'm not sure what am I playing with when I change that file-block-size parameter. Previously I thought it was the file system block size, but then I looked at the…
ada liu
  • 7
  • 3
0
votes
1 answer

Have Sysbench memory rndrd/rndwr tests eliminate the affect of cache?

In short, my question is: Should Sysbench eliminate the effect of cache when measuring the memory read/write performance, similar to how the effect of memory is eliminated when measuring the disk performance? If the answer is no, does that mean…
ada liu
  • 7
  • 3
0
votes
2 answers

Are sysbench threads similar to thread_pool_size?

I tested a mysql cluster using sysbench to figure out a sweet spot to set maximum threads to. In my endevours I came across the threads option in sysbench. --threads=N I also came across the thread_pool_size in Mysql Thread pool…
Amix
  • 1
  • 1
0
votes
0 answers

testing cpu with sysbench across platforms

I am trying to write a simple bash script to test a system/machine regarding cpu performance, adjusted to core count. I opted for sysbench, since it seemed easy. However, I dont know how to properly interpret the results. Should I look at events per…
Stat.Enthus
  • 335
  • 1
  • 12
0
votes
1 answer

How to solve segmentation fault in change main function inputs with C code?

I want the following code, which is related to the Sysbench tool (https://github.com/akopytov/sysbench), to change from the following code to the next code, but I get an error with just this small change (Segmentation fault (core…
Zahra Heydari
  • 55
  • 1
  • 4
0
votes
2 answers

How to test performance of MySQL NDB cluster(NDB storage engine) using SYSBENCH?

I want to test the performance of my NDB cluster. I am thinking of using sysbench. Are there any particular configuration changes required to make it work with the NDB cluster? Is there any flag that I need to use during runtime to mention the…
himanshu
  • 175
  • 3
  • 12
0
votes
1 answer

Sysbench test Mysql but no disk read

When I use sysbench to test mysql, I use iotop to monitor io and I find only have DiSH WRITE speed, the DISK READ speed is always 0. Then I use free -h and I find that buffer/cache increase, does it mean that sysbench's test data is not write in…
xiaoqiang yu
  • 15
  • 4
0
votes
0 answers

sysbench Fileio Test FATAL: Failed to write file! errno = 28 (No space left on device)

I'm having a problem with sysbench. It worked fine with 3 other platform. I have an imx8 with 4GB of RAM do sysbench fileio --file-total-size=16G prepare Set Directory Genric/Specific and platform sysbench fileio --file-total-size=16G…
Spearitch502
  • 3
  • 5
0
votes
0 answers

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 poor performance in terms of Transactions Per Second…
Justin Elkow
  • 2,833
  • 6
  • 28
  • 60
0
votes
1 answer

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 /mnt/optane2, the sock file is there. made sure I…
FrankO
  • 11
  • 2
0
votes
1 answer

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 installed sysbench on both systems and ran: sysbench…
Enzime
  • 37
  • 5
-1
votes
1 answer

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 of my two VMs, I found that the memory Read/Write…
Mark Smith
  • 61
  • 4
1
2