Re: remote mysql is too slow

2012-04-13 Thread Karl E. Jorgensen
On Wed, Apr 11, 2012 at 09:23:09PM +0100, Bob Proulx wrote: > Karl E. Jorgensen wrote: > > Bob Proulx wrote: > > > But at some point the daemon is going to need to write a file to disk. > > > That data will get cached at that time. Or are you saying that mysql > > > is using or should using O_DIRE

Re: remote mysql is too slow

2012-04-11 Thread Bob Proulx
Karl E. Jorgensen wrote: > Bob Proulx wrote: > > But at some point the daemon is going to need to write a file to disk. > > That data will get cached at that time. Or are you saying that mysql > > is using or should using O_DIRECT and avoid the cache explicitly? > > No - although that might help

Re: remote mysql is too slow

2012-04-11 Thread Karl E. Jorgensen
On Wed, Apr 11, 2012 at 07:18:18AM +0100, Bob Proulx wrote: > Karl E. Jorgensen wrote: > > Jumping back in (late) in this thread... > > Bob Proulx wrote: > > > > # free -m > > > > total used free sharedbuffers > > > > cached > > > > Mem: 7986 791

Re: remote mysql is too slow

2012-04-10 Thread Bob Proulx
Karl E. Jorgensen wrote: > Jumping back in (late) in this thread... > Bob Proulx wrote: > > > # free -m > > > total used free sharedbuffers cached > > > Mem: 7986 7913 73 0224 6133 > > > -/+ buffers/cache: 1554

Re: remote mysql is too slow

2012-04-10 Thread J. Bakshi
On Tue, 10 Apr 2012 12:24:47 +0100 "Karl E. Jorgensen" wrote: > > > > > > # free -m > > > total used free sharedbuffers cached > > > Mem: 7986 7913 73 0224 6133 > > > -/+ buffers/cache: 1554 6431 > >

Re: remote mysql is too slow

2012-04-10 Thread Karl E. Jorgensen
Jumping back in (late) in this thread... On Mon, 2012-04-09 at 19:51 +0100, Bob Proulx wrote: > 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 jus

Re: remote mysql is too slow

2012-04-09 Thread Bob Proulx
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 > > > pr

Re: remote mysql is too slow

2012-04-09 Thread Joe
On Mon, 9 Apr 2012 12:36:30 +0530 "J. Bakshi" wrote: > ` > > Is it possible to suggest something to tweak the server / mysql to get > a fast remote mysql box ? > Almost certainly, but it's more likely that people who use mysql very intensively will be better able to hel

Re: remote mysql is too slow

2012-04-09 Thread J. Bakshi
On Thu, 05 Apr 2012 11:36:38 +0100 "Karl E. Jorgensen" wrote: > Hi > > On Thu, 2012-04-05 at 08:13 +0100, J. Bakshi wrote: > > > Hello, > > > > 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 > > an

Re: remote mysql is too slow

2012-04-05 Thread Chris Davies
2012/4/5 J. Bakshi : > I have been provided a muscular linux server to use as a Mysql server > in our organization. [...] > The BIG hitch is; when we connect with this box the web sites become > too slow. Is this in direct comparison to some other database or server, or is it more of a black and

Re: remote mysql is too slow

2012-04-05 Thread Karl E. Jorgensen
Hi On Thu, 2012-04-05 at 08:13 +0100, J. Bakshi wrote: > Hello, > > 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

Re: remote mysql is too slow

2012-04-05 Thread Juan Sierra Pons
2012/4/5 J. Bakshi : > Hello, > > 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,

remote mysql is too slow

2012-04-05 Thread J. Bakshi
Hello, 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