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

Limit MySQL processes runtime?

Jun 25, 2002, 7:42 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 25, 2002, 7:42 AM
Post #1 of 10
Views: 9336
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 25, 2002, 8:15 AM
Paul
Veteran (19537 posts)
Jun 25, 2002, 8:15 AM
Post #2 of 10
Views: 9072
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 (18441 posts)
Andy's avatar
Jun 25, 2002, 8:17 AM
Post #3 of 10
Views: 9114
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 26, 2002, 9:36 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 26, 2002, 9:36 AM
Post #4 of 10
Views: 9096
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 26, 2002, 9:44 AM
Paul
Veteran (19537 posts)
Jun 26, 2002, 9:44 AM
Post #5 of 10
Views: 8980
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 (18441 posts)
Andy's avatar
Jun 26, 2002, 9:47 AM
Post #6 of 10
Views: 9059
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 26, 2002, 10:09 AM
Paul
Veteran (19537 posts)
Jun 26, 2002, 10:09 AM
Post #7 of 10
Views: 9025
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 (18441 posts)
Andy's avatar
Jun 26, 2002, 10:14 AM
Post #8 of 10
Views: 9044
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 27, 2002, 11:09 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 27, 2002, 11:09 AM
Post #9 of 10
Views: 9027
Shortcut
Quote Reply
Re: [Andy] Limit MySQL processes runtime? In reply to
Anyone?

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jun 27, 2002, 11:46 AM
Paul
Veteran (19537 posts)
Jun 27, 2002, 11:46 AM
Post #10 of 10
Views: 8912
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