View Single Post

   
  #1 (permalink)  
Old 03-17-2008, 06:13 AM
howa
 
Posts: n/a
Default Low priority SELECT statement

Hello,

I have several stuffs running on a single server, sometimes if I
issued a SLOW query, it will eat up all the server resources.

However, I don't mind the query to be slow, I just want it is issued
with low priority status, is it possible? Or the only way is to start
the mysqld with low priority? (but I only want that select statement
to be running as low priority...)

Thanks.
Howard
Reply With Quote