remote mysql is too slow
I have been provided a muscular linux server to use as a Mysql server
in our organization. The server is located just beside the web server
and within the same network. This dedicated server has 8GB RAM, i5 processors
and running mysql as service. No apache, php ..... nothing. All resources are
dedicated to mysql only.
Mysql version - mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64)
The BIG hitch is; when we connect with this box the web sites become too slow.
I have added the following at my.cnf under [mysqld] section
` ` ` ` `
` ` ` ` ` `
The sql connection becomes little faster but still it is considerably
slow; specially with such a muscular dedicated linx box just for Mysql.
Is there anything else which I can add/configure to make the network latecy
small or any such mechanism to make the query fast ?
The server has very little load as observer from top and iostat
even during peak hours.