Throttling mysql command line

Inizio della pagina
Allegati:
Messaggio come e-mail
+ (text/plain)
Delete this message
Reply to this message
Autore: Eric Cope
Data:  
To: Main PLUG discussion list
Oggetto: Throttling mysql command line
Hello all,
I have a nightly script that executes a mysql batch file that takes
approximately 8 minutes to run. Unfortunately it makes my web server
unresponsive for all 8 minutes. I've tried ionice and nice to lower
the priority, but it still seems to consume all resources. The weird
thing is "top" and "iostat" look like nothing is running. Any ideas?

Its mysql 5.1.x

Thanks,
Eric
---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss