Hi Friends, we have Intel Xeon Quad Core PowerEdge T100 processor (OS - CentOS),8GB RAM,160 Gb HDD with 10 GB free (now).we are accessing mysql from windows machine.its very very slow in process.through our ILUGC discussion i changed max_connection value from 100 into 500(it solves too many connection error). then is there any other changes needed?
On Thu, Aug 27, 2009 at 9:25 PM, Karanbir Singh <mail-li...@karan.org>wrote: > On 08/27/2009 01:41 PM, Ramkumar wrote: > >> I changed max_connection value into 500.Then when i >> login >> through MYSQL Administrator and try to see threads.That shows number of >> sleeping threads.How can i rectify this sleeping threads.Then these >> threads >> will affect MYSQL DataBase's performance?.Thanks in advance again... >> > > consider using connection pools, if you can. I think almost any and every > mysql connection library would/should support that by now. > > -- > Karanbir Singh : http://www.karan.org/ : 2522...@icq > > _______________________________________________ > To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with "unsubscribe > <password> <address>" > in the subject or body of the message. > http://www.ae.iitm.ac.in/mailman/listinfo/ilugc > -- www.opennetguru.com _______________________________________________ To unsubscribe, email ilugc-requ...@ae.iitm.ac.in with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc