Multi threading with mysql Server version: 5.1.49-3 (Debian)

I just configured one debian myql server which will work as master for a high load database.

becasue there would be 3 instances. I configured mysqld_multi with 3 different port.

and it willb e innodb database,.

now few things i want to discuss for the performance

(1) data1, data2  ( for  data directry ) in a different "Array 10" partition
2) innodb_buffer_pool_size= 16GB for each database
3) innodb_thread_concurrency=16

now  :

(a)is there any disadvantages of mysqld_multi for high end database ??  ( i did not see an y thing documentation for this so i belived it will be same)
(b) is there any variables to tell mysql to use multi procesosr ?? ( although, it set to us innodb_thread_concurrency=16)

other then

query_cache_size,table_cache,tmp_table_size,thread_cache is there any thing else to increase performance of innodb database ?

i will use mysql_tuner later on .. but i looking for extra advise .. to see what i am missing ..

LVL 29
Who is Participating?
wesly_chenConnect With a Mentor Commented:
1. innodb_buffer_pool_size 70-80% of memory is a safe bet.
2. Run those two scripts after your MySQL server run for certain time (two weeks or one month at least)

   Those two scripts will analyze your MySQL db data read/write, connection, cache hit ... and give you some suggestion. MySQL db tuning vary from data type and usage. So those parameters such as uery_cache_size,table_cache,tmp_table_size,thread_cache are based on your actual usage to adjust/tune.

3. MySQL_multi doesn't change the performance, it just allows one database daemon listen to multiple ports.

4. By default, MySQL is multi-thread which use all the available processors.

Check those articles for performance tuning:
InnoDB Performance Tuning Tips

MySQL Innodb Performance Tuning For Disk-Bound Workloads On CMT Servers

Innodb Performance Optimization Basics
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.