Quote:
Originally Posted by JamesM
Everyone's is different as per their need/system.
We use mysqltuner.pl for better performance.
|
+1 It will take at least a few days and multiple adjustments to tune things correctly. Sometimes the programs/scripts themselves make a big difference and if they are written poorly it can be impossible or impractical to optimize them without changing the source. It's a good idea to check what others say in regards to 'mysqltuner.pl' settings if you find it tells you to constantly increase a limit. Sometimes it makes sense to leave it because it's the application responsible and increasing it will only make the system worse.