SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:59 AM
| ||||
| ||||
 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      |
|
02-28-2008, 06:59 AM
| ||||
| ||||
| Re: MySql priority You may want to consider tuning the 'his-priority' server instance by giving it larger values for the following: temp_table_size query_cache_size query_cache_limit Ben Clewett <ben@clewett.org.uk> wrote: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=r..._dba@yahoo.com --------------------------------- Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. |
Linear Mode
