J. Bakshi wrote:
> Karl E. Jorgensen wrote:
> > J. Bakshi wrote:
> > > 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.
That does sound big and muscular and should do a good job of providing
database services.
> > > The BIG hitch is; when we connect with this box the web sites become too slow.
Unfortunately subjective descriptions such as "too slow" are not
useful descriptions. One person's very fast is another person's too
slow. Objective benchmark data is needed in order to make forward
progress. Also when you change something to improve the performance
if you don't know how much you changed things you might actually make
something worse without knowing it.
The other suggestions that people gave you were good. They were
better than anything I could suggest about mysql specifically. But
for performance tuning in general I strongly recommend that you use or
create a benchmark that illustrates the type of operation you are
trying to optimize. Benchmarks are best when they can be shared with
other people so that they can recreate your environment. It might be
useful to create a benchmark using synthetic data (created fake data)
so that others can share your environment and recreate it.
Then collect data on that benchmark. Then make performance tuning
changes. Then run the benchmarkmark again and determine if your
change improved things and if so by how much.
> > > 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 ?
Please show us data that tells us how slow is slow and how fast is
fast.
I am not a mysql performance expert. I won't be able to help too
much. Sorry. But I can tell you that if you don't have actual data
on the existing performance then you also won't know if you have
improved it or if you have made it worse or if you haven't changed
anything. Benchmarking when performance tuning is critically
important.
> # free -m
> total used free shared buffers cached
> Mem: 7986 7913 73 0 224 6133
> -/+ buffers/cache: 1554 6431
> Swap: 3813 0 3813
Shows 8G of ram. Good. Shows no swap used. Also good. (But not
necessarily bad if some swap is used. So if you see some swap being
used that isn't necessarily a problem.)