| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Tim Fountain | Date: | July 12 2003 4:54pm |
| Subject: | Stopping MySQL taking down a server? | ||
| View as plain text | |||
This may be a silly question but what can be done to stop
load-intensive MySQL processes taking down a server? Things like
adding fulltext indexes to very large tables, or selects on very large
(multi-million-row) tables just completely kill the box until they
complete.
I don't mind how long these things take but the box shouldn't become
unresponsive while they are running.
--
Tim Fountain
http://www.tfountain.co.uk/
| Thread | ||
|---|---|---|
| • Stopping MySQL taking down a server? | Tim Fountain | 12 Jul |
| • Re: Stopping MySQL taking down a server? | Dan Nelson | 12 Jul |
| • Re: Stopping MySQL taking down a server? | Andreas D. Landmark | 14 Jul |
| • Re: Stopping MySQL taking down a server? | Michael Conlen | 16 Jul |