MySQL Forums
Forum List  »  Performance

Re: 1135 Can't create a new thread (errno 11)...
Posted by: Rick James
Date: December 17, 2011 10:57AM

Is mysqlslap runnng on the same machine as the server? If so, it is competing for resources.

In my opinion, this is unreasonably high:
> --max_connections=6000

This sounds dangerously low:
> stack size (kbytes, -s) 90000

If you have over 1000 threads connected to one server, you have something else wrong.

> --concurrency=1200 --number-of-queries=1
I suspect Max_used_connections was nowhere near 1200. The queries probably came an went so fast that they were not all there at the same time. I suspect that STATUS value gives you a more accurate estimate of the concurrency mysqlslap actually achieved.

Check GLOBAL STATUS LIKE '%timeout%';

Options: ReplyQuote

Written By
Re: 1135 Can't create a new thread (errno 11)...
December 17, 2011 10:57AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.