sysbench | Scriptable database and system performance benchmark

by akopytov C Version: 1.0.20 License: GPL-2.0

X-Ray Key Features Code Snippets Community Discussions(7)Vulnerabilities Install Support

kandi X-RAY | sysbench Summary

sysbench is a C library typically used in Programming Style applications. sysbench has no bugs, it has no vulnerabilities, it has a Strong Copyleft License and it has medium support. You can download it from GitHub.

sysbench is a scriptable multi-threaded benchmark tool based on LuaJIT. It is most frequently used for database benchmarks, but can also be used to create arbitrarily complex workloads that do not involve a database server.

Support

Quality

Security

License

Reuse

Support

sysbench has a medium active ecosystem.

It has 5191 star(s) with 985 fork(s). There are 180 watchers for this library.

It had no major release in the last 12 months.

There are 130 open issues and 237 have been closed. On average issues are closed in 109 days. There are 30 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of sysbench is 1.0.20

Quality

sysbench has 0 bugs and 0 code smells.

Security

sysbench has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

sysbench code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

sysbench is licensed under the GPL-2.0 License. This license is Strong Copyleft.

Strong Copyleft licenses enforce sharing, and you can use them when creating open source projects.

Reuse

sysbench releases are available to install and integrate.

Installation instructions, examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of sysbench

Get all kandi verified functions for this library.

sysbench Key Features

No Key Features are available at this moment for sysbench.

sysbench Examples and Code Snippets

No Code Snippets are available at this moment for sysbench.

Community Discussions

Trending Discussions on sysbench

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

Error running a docker image, unable to locate package

Error making a job on a kubernetes cluster

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

Sysbench test Mysql but no disk read

Why is a Core i5-6600 faster at non-square matrix multiplication than a Core i9-9960X?

How could database have worse benchmark results on faster disk?

QUESTION

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

Asked 2022-Mar-18 at 17:07

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 dumped)).

...

ANSWER

Answered 2022-Mar-18 at 17:07

In order to emulate argv from main the strings pointed to by argv[n] to must be writable, which is not the case in your code where argv[n] point to string literals which cannot be written to.

Writing into a string literal is formally undefined behaviour in C, but on modern desktop platforms it typically triggers a seg fault.

And *tmp = '\0'; is actually writing into a string.

This should do the job, although I'm not entirely sure because I can't check it here easily.

Source https://stackoverflow.com/questions/71530342

QUESTION

Error running a docker image, unable to locate package

Asked 2021-Mar-11 at 20:55

I have this Dockerfile:

...

ANSWER

Answered 2021-Mar-11 at 18:23

There is a reported bug about sysbench on aarch, ( which is the target arm processor that rpi uses). Try to follow the suggestion in: https://github.com/akopytov/sysbench/issues/298

Source https://stackoverflow.com/questions/66588118

QUESTION

Error making a job on a kubernetes cluster

Asked 2021-Mar-05 at 21:32

I'm trying to make a job that runs sysbench on a pod. First I make the job with the next yaml:

...

ANSWER

Answered 2021-Mar-05 at 21:32

You're trying to run a linux/amd64 image on an ARM-based system: essentially, the error is saying that doesn't understand how to run instructions since binary and processor are speaking different languages.

You have to find a compatible Docker image for your architecture.

Source https://stackoverflow.com/questions/66497699

QUESTION

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

Asked 2021-Jan-20 at 11:43

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 Storage engine explicitly.

Need some help on this.

...

ANSWER

Answered 2021-Jan-09 at 11:58

I have a set of scripts that I use to automate benchmarking with NDB Cluster. They are available from the MySQL website and contains both the scripts to automate Sysbench execution and a sysbench version integrated with those scripts.

This blog provides a manual into how to use those scripts. http://mikaelronstrom.blogspot.com/2018/08/manual-for-benchmark-toolset-dbt2.html

The script run_oltp.sh contains the setup of the execution of the sysbench program if you want to use sysbench on your own.

Source https://stackoverflow.com/questions/65594204

QUESTION

Sysbench test Mysql but no disk read

Asked 2020-Nov-01 at 05:46

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 disk but in buffer and no auto update into disk?

Thank you so much!

...

ANSWER

Answered 2020-Nov-01 at 05:46

where is the mysql running ?? I dont know about iotop and what its measuring but even tiny sysbench runs generate enormous IO. it could be a user issue maybe, perhaps mysql is generating io under a different user and not getting picked up.

Source https://stackoverflow.com/questions/63386978

QUESTION

Why is a Core i5-6600 faster at non-square matrix multiplication than a Core i9-9960X?

Asked 2020-May-19 at 09:13

The following minimal benchmark rebuilds single-threaded code with -O3 -march=native on each machine, multiplying matrices that are either square or highly non-square (one dimension = 2).

...

ANSWER

Answered 2020-May-19 at 09:13

As suggested by Peter Cordes in his comment, it seems to boil down to memory throughput.

Results of mbw 1000 show it:

i5-6600:

Source https://stackoverflow.com/questions/61832173

QUESTION

How could database have worse benchmark results on faster disk?

Asked 2020-Jan-06 at 17:03

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 https://dzone.com/articles/iops-benchmarking-disk-io-aws-vs-digitalocean

In summary:

DO --

READ: bw=218MiB/s (229MB/s), 218MiB/s-218MiB/s (229MB/s-229MB/s), io=3070MiB (3219MB), run=14060-14060msec

WRITE: bw=72.0MiB/s (76.5MB/s), 72.0MiB/s-72.0MiB/s (76.5MB/s-76.5MB/s), io=1026MiB (1076MB), run=14060-14060msec

EC2 --

READ: bw=9015KiB/s (9232kB/s), 9015KiB/s-9015KiB/s (9232kB/s-9232kB/s), io=3070MiB (3219MB), run=348703-348703msec

WRITE: bw=3013KiB/s (3085kB/s), 3013KiB/s-3013KiB/s (3085kB/s-3085kB/s), io=1026MiB (1076MB), run=348703-348703msec

which shows DO disk more than 10 times faster than the EBS of EC2

However, sysbench following https://severalnines.com/database-blog/how-benchmark-postgresql-performance-using-sysbench is showing DO slower than EC2 (using Postgres 11 default configuration, read-write test on oltp_legacy/oltp.lua )

DO --

transactions: 14704 (243.87 per sec.)

Latency (ms):

min: 9.06

avg: 261.77

max: 2114.04

95th percentile: 383.33

EC2 --

transactions: 20298 (336.91 per sec.)

Latency (ms):

min: 5.85

avg: 189.47

max: 961.27

95th percentile: 215.44

What could be the explanation?

...

ANSWER

Answered 2020-Jan-06 at 16:12

Sequential bandwidth and latency / iops are independent parameters.

Some workloads (like DBs) depend on latency for lots of small IOs. Or throughput for lots of small IO operations, iops (IOs per second).

Source https://stackoverflow.com/questions/59615125

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install sysbench

The above will build sysbench with MySQL support by default. If you have MySQL headers and libraries in non-standard locations (and no mysql_config can be found in the PATH), you can specify them explicitly with --with-mysql-includes and --with-mysql-libs options to ./configure. To compile sysbench without MySQL support, use --without-mysql. If no database drivers are available database-related scripts will not work, but other benchmarks will be functional.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: