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]

"David Hane" wrote:

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!

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