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

Jan 7, 2005, 4:35 AM

Andy

Veteran / Moderator (17297 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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Jan 7, 2005, 3:17 PM

Alex

Administrator (9386 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 (17297 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 (9386 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 (17297 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 (9386 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 (17297 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