Thread: MySql priority
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 06:59 AM
Ben Clewett
 
Posts: n/a
Default MySql priority

Sorry if this has been asked many times before...

I have 5 MySql systems running on a single server.

I want one to run with maximum priority, the other four to run with minimum.

Can this me archived using something as simple as 'nice':

# nice -10 mysqld --defaults-file=his_priorty
# nice 10 mysqld --defaults-file=low_priorty_1
# nice 10 mysqld --defaults-file=low_priorty_2
# nice 10 mysqld --defaults-file=low_priorty_3
# nice 10 mysqld --defaults-file=low_priorty_4

Or is there a better way that people use?

Thanks in advance...

Ben
Reply With Quote