Gossamer Forum: General: Databases and SQL: MySQL processes on a "database server"

Jan 7, 2005, 4:35 AM

Andy

Veteran / Moderator (18441 posts)

Jan 7, 2005, 4:35 AM

Post #1 of 7

Shortcut

MySQL processes on a "database server"

Hi,

I'm having some server woes :/

Basically, we have quite a beefy old server;

Memory : 1GB DDR RAM
Hard Drive 1 : 80GB EIDE
Operating System : Red Hat Enterprise Linux ES 3
Processor : Single AMD Athlon XP 3000+ 2.167 GHz

However, some of our MySQL processes just keep running and running, and eventually exausing the system (which causes it to crash, after several days).

Is there anywhere that I can set a timeout on mysql processes? i.e if a process runs for more than 1 hour, then kill it?

TIA

Andy (mod)
andy@ultranerds.co.uk

Jan 7, 2005, 3:17 PM

Alex

Administrator (9387 posts)

Jan 7, 2005, 3:17 PM

Post #2 of 7

Shortcut

Re: [Andy] MySQL processes on a "database server" In reply to

Try doing a `mysqladmin proc` to see what's taking so long, or turn on mysql's slow query log.

Cheers,

Alex
--
Gossamer Threads Inc.

Jan 8, 2005, 1:08 AM

Andy

Veteran / Moderator (18441 posts)

Jan 8, 2005, 1:08 AM

Post #3 of 7

Shortcut

Re: [Alex] MySQL processes on a "database server" In reply to

Hi Alex,

Thanks. That at least shows me that there are "sleeping" processes. Maybe a DB connection that doesn't get cut off correctly?

Code:

Thanks again.

Andy (mod)
andy@ultranerds.co.uk

Jan 8, 2005, 10:03 AM

Alex

Administrator (9387 posts)

Jan 8, 2005, 10:03 AM

Post #4 of 7

Shortcut

Re: [Andy] MySQL processes on a "database server" In reply to

That's normal if you are using mod_perl with Apache::DBI, or PHP's persistent connections. If it's php, make sure you have max_connections set in MySQL to at least the max number of apache children.

Cheers,

Alex
--
Gossamer Threads Inc.

Jan 10, 2005, 1:11 AM

Andy

Veteran / Moderator (18441 posts)

Jan 10, 2005, 1:11 AM

Post #5 of 7

Shortcut

Re: [Alex] MySQL processes on a "database server" In reply to

Hi,

Thanks for the reply... but should some of these processes be running for days on end? :/

AFAIK, these connections should not be the problem with PHP, as we use very little PHP on this server (its soley for the bigger sites, as a database server). I guess the next step, is to try and work out where these errors are coming from, and try to close the connections.

Fun fun... <G>

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 10, 2005, 8:13 AM

Alex

Administrator (9387 posts)

Jan 10, 2005, 8:13 AM

Post #6 of 7

Shortcut

Re: [Andy] MySQL processes on a "database server" In reply to

Quote:

but should some of these processes be running for days on end? :

Yes, if it's listed as 'sleeping', that's quite normal. For instance, if you are using persistent connections in php, then whenever an apache child connects to the database, it will keep a connection open for as long as it lives (which could well be a couple days).

Cheers,

Alex
--
Gossamer Threads Inc.

Jan 10, 2005, 8:16 AM

Andy

Veteran / Moderator (18441 posts)

Jan 10, 2005, 8:16 AM

Post #7 of 7

Shortcut

Re: [Alex] MySQL processes on a "database server" In reply to

Ah, I see

Its only got 1Gb of RAM ... do you think its worth upgrading to 1.5Gb? (thats the most we can have on this kind of machine :'().

TIA

Andy (mod)
andy@ultranerds.co.uk