Preventing runaway mysqld process

[David Hane]

Hi all,

I would like give users the ability to experiment with complex queries but
I'm worried about them creating queries that will bog down the server.

Does anyone have any ideas for preventing a runaway process?

I'd like to empower my users AND keep my server online :-)

Thanks!

[steve]

Re: Preventing runaway mysqld process

"David Hane" wrote:[color=blue]
> Hi all,
>
> I would like give users the ability to experiment with complex[/color]
queries[color=blue]
> but
> I’m worried about them creating queries that will bog down the
> server.
>
> Does anyone have any ideas for preventing a runaway process?
>
> I’d like to empower my users AND keep my server online
>
> Thanks![/color]

Look at long_query_time in startup parameters

http://dev.mysql.com/doc/mysql/en/Server_options.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-Preven...ict155240.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=524873