473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

100 processes...server hangs..??

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!
Jul 20 '05 #1
1 1663
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
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Guy | last post by:
Hi I've done some projects in python for my work which invole some test scripts etc. All quite basic stuff, I find python a good language to work in but have come up against a brick wall. I'm...
11
by: anuradha.k.r | last post by:
hi, i am writing a socket program in python,both client side and server side.I've written the client side which is working perfectly fine(checked it against server program written in C).but as for...
0
by: David H | last post by:
Background. I'm running on WinXP w/ MS Services for Unix installed (to give rsh/rlogin ability), both Python 2.3 and 2.4 version. In linux, I'm running RHEE with python2.3 version. The code...
3
by: Senthuran | last post by:
Hi, The SQL server 2000 Server hangs some times. It is not periodic. It is not specific in any queries, which are taking more time to execute. Because, it is occurring for different types of...
2
by: Andy Harrison | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Could anyone explain about the max_connections in postgres? We ran into the connection limit on one of our production servers. One reason is that we have...
0
by: Bob Allen | last post by:
I am having some issues from my programs that are using Process.GetProcesses() it is locking up the program and it will not error out or anything it just hangs there. Any ideas. This just happend...
9
by: Abhishek Srivastava | last post by:
Hello All, In IIS 6.0 We have a concept of worker processes and application pools. As I understand it, we can have multiple worker process per appliction pool. Each worker process is dedicated...
4
by: AN | last post by:
Greetings, We make an ASP.NET web application and we host it for our customers. We have provisioned hardware and hope to be able to service around 200 customers on this hardware. The web...
3
by: Richard Bell | last post by:
I'm working on a VB application that must run 24x7 for a LONG time, think 60 days of so. As part of what it does it must automate an instance of IE and navigate to many different URLs, think many...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.