mos wrote:
At 12:05 PM 12/13/2004, you wrote:
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive,
and simple index searches that should be instant will wait and wait
and wait before responding.
I dont want one user to kill
At 12:05 PM 12/13/2004, you wrote:
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive, and
simple index searches that should be instant will wait and wait and wait
before responding.
I dont want one user to kill everybody else
Anybody know? Or am I dreaming about oracle features that are not in mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
matt_lists wrote:
Dathan Pattishall wrote:
From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outa
Dathan Pattishall wrote:
From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outage. If you
can't
Message-
From: matt_lists [mailto:[EMAIL PROTECTED]
Sent: Monday, December 13, 2004 10:05 AM
To: [EMAIL PROTECTED]
Subject: Limit drive usage per thread
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive, and
simple index searc
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive, and
simple index searches that should be instant will wait and wait and wait
before responding.
I dont want one user to kill everybody else
I'm adding a column to a large