mysql optimisation

a lot of our customers use mysql for their php dynamic sites, but im finding mysql has quite a bit of load as it forks for every connection...

my question to you wisdomic (is that even a word?) people is how do you optimise your mysql ? either during installation or the config files, or with table optimisation (im more looking at the former 2 as each user designs their tables differently)

would it work quicker if i ran a second instance of mysql on a different ip/port on a different disk so as to allow both disks to spin at once?

thanks in advance

Slidey

 

 

 

 

Top