471,075 Members | 1,269 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Preventing runaway mysqld process

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!
Jul 20 '05 #1
1 2302
"David Hane" wrote:
Hi all,

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

Does anyone have any ideas for preventing a runaway process?

Id 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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Oliver Spiesshofer | last post: by
reply views Thread by Stephane Raimbault | last post: by
reply views Thread by Albert Rossi | last post: by
reply views Thread by Gary Cote | last post: by
3 posts views Thread by Paul | last post: by
4 posts views Thread by Matthew Groch | last post: by
4 posts views Thread by db2admin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.