Re: Remote mysql too slow

2012-04-09 Thread Noel Butler
On Mon, 2012-04-09 at 06:14 -0500, Johnny Withers wrote: > right speed and duplex. It seems that every new server I get now has > to have the speed and duplex explicitly set instead of auto negotiate. > Many of the cisco switches are notorious for this. signature.asc Description: This is a

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
On Mon, 09 Apr 2012 13:17:55 +0200 Reindl Harald wrote: > > > Am 09.04.2012 13:05, schrieb J. Bakshi: > > I have reset these two now > > > > ` ` ` ` > > key_buffer_size=200M > > innodb_buffer_pool_size=4G > > [!!] InnoDB data size / buffer pool: 3.6G/8.0M > > there did go something terrible

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
Am 09.04.2012 13:05, schrieb J. Bakshi: > I have reset these two now > > ` ` ` ` > key_buffer_size=200M > innodb_buffer_pool_size=4G [!!] InnoDB data size / buffer pool: 3.6G/8.0M there did go something terrible wrong what is the mysqld log saying at startup? waht about post your complete my.

Re: Remote mysql too slow

2012-04-09 Thread Johnny Withers
You may want to ensure the nic is connected to the network at the right speed and duplex. It seems that every new server I get now has to have the speed and duplex explicitly set instead of auto negotiate. Sent from my iPad On Apr 9, 2012, at 4:00 AM, "J. Bakshi" wrote: > > Hello, > > I have be

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
On Mon, 09 Apr 2012 12:06:42 +0200 Reindl Harald wrote: > > > Am 09.04.2012 11:56, schrieb J. Bakshi: > > On Mon, 09 Apr 2012 11:47:01 +0200 > > Reindl Harald wrote: > > > >> > >> > >> Am 09.04.2012 10:57, schrieb J. Bakshi: > >>> > >>> Hello, > >>> > >>> I have been provided a muscular l

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
Am 09.04.2012 11:56, schrieb J. Bakshi: > On Mon, 09 Apr 2012 11:47:01 +0200 > Reindl Harald wrote: > >> >> >> Am 09.04.2012 10:57, schrieb J. Bakshi: >>> >>> Hello, >>> >>> I have been provided a muscular linux server to use as a Mysql server >>> in our organization. The server is located

Re: Remote mysql too slow

2012-04-09 Thread J. Bakshi
On Mon, 09 Apr 2012 11:47:01 +0200 Reindl Harald wrote: > > > Am 09.04.2012 10:57, schrieb 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

Re: Remote mysql too slow

2012-04-09 Thread Reindl Harald
Am 09.04.2012 10:57, schrieb 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 runnin

Remote mysql too slow

2012-04-09 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 re