Gossamer Forum
(Advanced Search)
for
Home : General : Internet Technologies :

Limit MySQL processes runtime?

Jun 25, 2002, 7:42 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Jun 25, 2002, 7:42 AM
Post #1 of 10
Views: 1557
Shortcut
Quote Reply
Limit MySQL processes runtime?
I'm sure this must be possible...but I'm not sure how. What would I need to do to limit each mySQL process to say 2 mins? At the moment something on my server is not closing them...so they are staying open for literally days, before I re-start MySQL and get rid them all Frown

Thanks

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
Jun 25, 2002, 8:15 AM
Paul
Veteran (19537 posts)
Jun 25, 2002, 8:15 AM
Post #2 of 10
Views: 1534
Shortcut
Quote Reply
Re: [Andy] Limit MySQL processes runtime? In reply to
>>
At the moment something on my server is not closing them
<<

Yeah your scripts probably ;)
Jun 25, 2002, 8:17 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Jun 25, 2002, 8:17 AM
Post #3 of 10
Views: 1532
Shortcut
Quote Reply
Re: [Paul] Limit MySQL processes runtime? In reply to
Nope..not them. I added print's after each of them, to check if there were more openings than closing..but there is not. I think it may be AdCycle Frown

Anyway..thats not the point. I still need to make MySQL connections time out after 2 mins :(

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
Jun 26, 2002, 9:36 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Jun 26, 2002, 9:36 AM
Post #4 of 10
Views: 1506
Shortcut
Quote Reply
Re: [Andy] Limit MySQL processes runtime? In reply to
Anyone got an intelligent answer to my question? Unsure

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
Jun 26, 2002, 9:44 AM
Paul
Veteran (19537 posts)
Jun 26, 2002, 9:44 AM
Post #5 of 10
Views: 1505
Shortcut
Quote Reply
Re: [Andy] Limit MySQL processes runtime? In reply to
What do you mean by limiting the "process"...do you mean the database handle or the script process or the mysql process?
Jun 26, 2002, 9:47 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Jun 26, 2002, 9:47 AM
Post #6 of 10
Views: 1503
Shortcut
Quote Reply
Re: [Paul] Limit MySQL processes runtime? In reply to
Well, on Tier1Host.nets servers, they have a 'timeout' limit on mySQL processes. I want to be able to limit this to say 60-120 seconds.

Thanks

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
Jun 26, 2002, 10:09 AM
Paul
Veteran (19537 posts)
Jun 26, 2002, 10:09 AM
Post #7 of 10
Views: 1500
Shortcut
Quote Reply
Re: [Andy] Limit MySQL processes runtime? In reply to
Hmm but dumps of decent size databases may take longer than that so it would just keep chopping it.

Use "mysqladmin variables" to see a list of the variables that you can set and the values actually being used by the running server.
Jun 26, 2002, 10:14 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Jun 26, 2002, 10:14 AM
Post #8 of 10
Views: 1497
Shortcut
Quote Reply
Re: [Paul] Limit MySQL processes runtime? In reply to
>>>Use "mysqladmin variables" to see a list of the variables that you can set and the values actually being used by the running server. <<<

I'm not sure what you mean. Would I type: 'mysqladm in variables' at shell, or are you refering to a program that does it? Unimpressed

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
Jun 27, 2002, 11:09 AM
Andy
Veteran / Moderator (17364 posts)
Andy's avatar
Jun 27, 2002, 11:09 AM
Post #9 of 10
Views: 1483
Shortcut
Quote Reply
Re: [Andy] Limit MySQL processes runtime? In reply to
Anyone?

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
Jun 27, 2002, 11:46 AM
Paul
Veteran (19537 posts)
Jun 27, 2002, 11:46 AM
Post #10 of 10
Views: 1481
Shortcut
Quote Reply
Re: [Andy] Limit MySQL processes runtime? In reply to
 
shell> mysqladmin variables.

wait_timeout.

You'll probably find oodles of info at mysql.com or on google if you search for it.

Thats more to do with mysql connections rather than processes so it depends what you want.

Last edited by:

Paul: Jun 27, 2002, 11:48 AM