SprMan wrote:
I run a Toaster Mail server with virtual domains. The users
authenticate against a MySql 3..23.58 db. We have been having an
ongoing issue with login’s just "hanging" via both http (webmail)
and IMAP (client based.) After over two months of troubleshooting, I
have discovered the following, and am able to reproduce it;
When "show processlist" is <100 the server is fine...logins
cruise right through. When "show processlist" is >100 the
authentication hangs both via webmail and IMAP.
The only "100" setting I can find with "show variables" is
"delayed_insert_limit" but I’m not sure if changing that is going
to help.
Please help. This is a production box that I’m SO close to fixing!
I suggest you run a "top" from shell, to see where the bottle neck
is: memory, cpu, or disk (iowait).
I suspect it would be the iowait, and it would relate to indecis not
kept in ram. If you have enough ram, you can force the key indecis to
be kept in ram increasing your performance many fold.
The key_buffer needs to be as big as your indecis combined.
Also do a delayed key write=ALL
http://dev.mysql.com/doc/mysql/en/MyISAM_start.html
--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL:
http://www.dbForumz.com/mySQL-100-pr...ict125245.html
Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbForumz.com/eform.php?p=418169