SEO

#1 (**permalink**) 03-17-2008, 06:13 AM

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

#2 (**permalink**) 03-17-2008, 07:35 AM

On Mar 13, 3:50 pm, howa <howac...@gmail.com> wrote:
> 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

I dont think so, but have a look at this:
http://dev.mysql.com/doc/refman/5.1/...ect-speed.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Low priority SELECT statement