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,