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