mysqlslap: Could not create thread

While using mysqlslap I am getting this error when I use -u root -p –create-schema=test --query="SELECT * FROM users" --concurrency=383 --iterations=1

My max connections in my.cnf is a lot higher than this 383, is there another setting I need to change or something in a different file that will allow me to have more connections. Anything 381 and lower works fine and 382 gives me the error mysqlslap: mysql_init() failed ERROR :

3 Replies

That's not much of an error message. Anything in the logs?

im actually seeing nothing in /var/log/mysql/error.log

Is it a limitation of mysqlslap? Can you run two tests with –concurrency=381 at the same time?

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct