Portal Home > Knowledgebase > Articles Database > MySQL Threads_created over than 40000
MySQL Threads_created over than 40000
| Posted by linux2man, 05-29-2007, 10:19 AM |
| Hello everybody;
MySQL Threads_created over than 40000 on server, !!!
Server still running but some times connecting error occurred Specs:-
----------
O.S: Centos 4.4
MySQL : 5.0.27-log
my.cnf "I removed comments":-
|
| Posted by Steven, 05-29-2007, 10:40 AM |
| we need to see the output of the following during a high load time
mysqladmin status
mysqladmin processlist
|
| Posted by linux2man, 05-29-2007, 10:53 AM |
| load time will be after 3 hrs for now out put status is :-
mysqladmin status
mysqladmin processlist
http://www.linuxman.host.sk/proclist.txt
|
| Posted by feedsfarm, 05-31-2007, 06:10 AM |
| thread_cache_size = 500
Seems very high, try 64 to 128
How much RAM has this system got? Try increase memory available for temporary tables, so that less disk based operations occur:
max_heap_table_size = 64M
tmp_table_size = 64M
|
| Posted by crux_op, 05-31-2007, 10:17 AM |
| Are you using persistent connections? If your script doesn't let go of the connection on termination, you can quickly run out of threads to use when you receive a lot of traffic.
|
Add to Favourites 
Print this Article
Also Read
