In the last episode (Dec 30), Matt Sturtz said: > Hello, Jeremy, et al-- Thanks for the reply before... Further questions: > >> Is it possible to set either set the priority ('nice') of the > >> Slave thread down so it doesn't do that? > > > > The slave thread only? No, not really. You could nice MySQL when > > you start it up. But I'm not sure how much effect (positive or > > negative) that'd have. > > When I run "show [full] processlist", there's an "Id" column, but it > doesn't corrospond with the Unix PID of the process (on OS's that use > a seperate PID for each thread-- like Linux does)... Is there any > way to(easilly) figure out which PID is handling the slave thread, so > that I might re-nice it after it's already been started up?
That probably won't help you, since I doubt you're CPU-bound. Most likely your slave thread is monopolizing the disk I/O. You could try manually stopping and starting the thread by sending it SIGSTOP and SIGCONT signals. Alternating the two every 5 seconds will give you a 50% slowdown. I don't know how LinuxThreads is going to like having threads messes with like that though. You can probably also do SLAVE STOP / SLAVE START and get the same effect. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php