MySQL performance
Installation and Configuration
White Agency"]
Don't know about the sql server being on the same switch but it's in the same data centre ! All our other sites across the other servers are running fast; a couple of these servers are in a different data centre to the sql server and we have no latency issues with them.
We run a separate sql server for security and maintenance reasons. Easier to look after 1 rather than 5! It's specifically built as an SQL server by the hosting company ( and looked after by them ) who have a lot more experience than we do !
I've shown the site to other developers who are not familiar with it and they can't see a problem with the speed. I think because of the low score from the performance check it just got me wondering if there was a problem when in fact there isn't.
Cheers
Dave
heres what i want you to do
login through ssh as root
type perl mysqltuner.pl copy and post the results here
if that says not found
paste this command
wget http:
wget https:
perl mysqltuner.pl
1 line at a time paste 1st line hit enter wait to complete then 2nd etc then 3rd the third will give you the tuner output and suggestions
after you do that ill give you tuneup suggestions i might need a couple other things fter i see the results'
like total number of tables etc
repeat the runs every 48 hours
in a week you should see a real improvement
