Questions tagged [mysqlslap]
6 questions
2
votes
1 answer
MySQL Stress testing issues?
I had gone through MySQL High Performance book Chapter 2 for MySQL Bench marking and Profiling,I have some questions about benchmarking
How can we test an existing database and queries against it using sysbench tool?
Currently I am using mysqlslap…
Abdul Manaf
- 9,587
- 16
- 73
- 84
2
votes
0 answers
understanding mysqlslap concurrency
I have a RDS instance running in AWS. By default
max_connections=45
so I used mysqlslap to see how it works. I ran:
mysqlslap --concurrency=20 --host=deleteme.ckn5fsf3nwqp.ca-central-1.rds.amazonaws.com --user=deleteme --password…
1
vote
0 answers
Using Netscaler datastream and MySQL
I configured MySQL service on a netscaler 10.5. When I perform some MySQL benchmarks using mysqlslap, the first time it runs correctly, the 2nd time I have an error message:
When I run it the first time:
mysqlslap -hlb_mysql --concurrency=10…
Peter Vandenberghe
- 11
- 3
1
vote
2 answers
mysqlslap chokes on strings that contain ";" delimiter?
I'm having a problem passing preexisting files full of SQL statements into mysqlslap.
For example, I have a file named create.sql that contains my table structure (as dumped by mysqldump), with normal ; delimiting.
I also have a file called slap.sql…
Jeremy Wadhams
- 958
- 1
- 9
- 13
0
votes
1 answer
MySQL stress test tool, remote server preferred
For MySQL stress test there exists programs:
http://dev.mysql.com/doc/mysqltest/2.0/en/test-programs.html
Also mysqlslap exists: http://dev.mysql.com/doc/refman/5.5/en/mysqlslap.html
Is it possible to test remote server ?
With proper configuration…
trante
- 149
- 1
- 2
- 5
-1
votes
1 answer
MySQL slap with custom query
I want to conduct stress test on our MySQL DB. I have the list of queries i need to execute. I have tried using Apache JMeter for this but it is very time consuming. Is it possible to run mysqlslap with custom .sql file containing INSERT, UPDATE,…
Ruchit Rami
- 241
- 2
- 6
- 10