Forwarding a post on behalf of Nagananda... From: Naganand [mailto:[EMAIL PROTECTED] Sent: 12 November,2007 04:00 PM To: '[EMAIL PROTECTED]' Subject: Hi all, Greetings from Grameen Koota! We have an issue on our live server. Can anybody help us! We have 44 branches running live on the server and most of them do data entry using low speed internet connections. The connection is sometime strong and sometime week and breaking. It so happens that sometimes mysql on our database server overshoots the number of users which is currently defined as 150 [though the number of branches are only 44 + another 10 users max] and the server hangs and stops responding. If I increase the users limit then the server starts responding slowly. Also sometimes the branches load reports and there is a connection breakage inbetween. Then the users reconnect and reload the reports. But in the server the old queries does not end and mysql hangs. We need to restart mysql or kill the queries 1 by 1 and then the server works faster. Can anybody help us know why does the no. of users go out of limit? And why do the queries hang instead of ending when the user is disconnected from the net? Regards, Naganand AGM [Information Technology Department] Grameen Koota, Avalahalli, Anjanapura Post Bangalore- 560062 Email: [EMAIL PROTECTED] [EMAIL PROTECTED] Phone: 080-28436838, Mob: 9341940803 Website: www.grameenkoota.org
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/
