I am currently having difficulties tracking down a problem. We have two servers, one of which has mySQL installed (3.23.40). Domains on either server can opt to have a mySQL database, and there are a number of Dbs set up. We have a relatively low number of maximum connections allowed, and some users are getting an error because this limit is being reached.
It appears to be down to one domain and their database, but I cannot see why it is happening. This is what we have: Server1 without mySQL Server2 with mySQL and phpMyAdmin Among around 150 domains on Server1 are two particular domains, which I'll call Domain1 and Domain2. Domain1 has a Db on Server 2 and has a number of scripts using php. Domain2 does not have a Db and does not use php. If I go to phpMyAdmin on Server2 and select "show processes" this is the sort of thing I get: Id User Host db Command Time State Info 3009 Domain1User Domain2 Domain1Db Sleep 284 NULL 3010 Domain1User Domain2 Domain1Db Sleep 266 NULL 3013 Domain1User Domain2 Domain1Db Sleep 242 NULL 3015 Domain1User Domain2 Domain1Db Sleep 217 NULL 3016 Domain1User Domain2 Domain1Db Sleep 182 NULL 3017 Domain1User Domain2 Domain1Db Sleep 170 NULL 3018 Domain1User Domain2 Domain1Db Sleep 135 NULL 3019 Domain1User Domain2 Domain1Db Sleep 123 NULL 3022 Domain1User Domain2 Domain1Db Sleep 46 NULL 3023 Domain1User Domain2 Domain1Db Sleep 13 NULL 3024 Domain1User Domain2 Domain1Db Sleep 10 NULL 3028 root localhost mysql Query 0 NULL SHOW PROCESSLIST My questions are: Why is Domain2 being shown as the host for these processes (the server name is something entirely different)? What could Domain1 have in their scripts that would be causing this (Their main script is phpNuke)? How do I increase the number of maximum users? How do I reduce the length of time a connection will be kept open and allowed to sleep? Thanks for any help offered (and apologies for anyone for whom the above table is way out of line) Brian --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
