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

Re: Mysql too slow over the LAN

2002-05-21 Thread Gelu Gogancea
valon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 6:46 PM Subject: Mysql too slow over the LAN > > Hello, > > I have built an application that connects to a mysql > database located on a remote server in our LAN. > > When running th

Mysql too slow over the LAN

2002-05-21 Thread Avalon
Hello, I have built an application that connects to a mysql database located on a remote server in our LAN. When running the application locally on the server and I open the main window (it as several forms and does a lot of queries to fill the fields, etc.) it takes about 2 to 3 seconds to

Re: MySQL too slow....

2001-06-08 Thread Sommai Fongnamthip
ot;Muhammad Asif" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Thursday, June 07, 2001 1:00 PM >Subject: Re: MySQL too slow > > > > Muhammad Asif wrote: > > > > > > i have a table with 1 records in MS Access and > > > M

Re: MySQL too slow....

2001-06-08 Thread Sommai Fongnamthip
If you use Delphi or VB, VC, there are some API program that let you access MySQL direct. Not worry about ODBC. Sommai Fongnamthip At 01:00 7/6/2001 -0700, Van wrote: >Muhammad Asif wrote: > > > > i have a table with 1 records in MS Access and > > MySQL with no index in either database. >

Re: MySQL too slow

2001-06-07 Thread Jeremy Zawodny
On Thu, Jun 07, 2001 at 12:56:24PM +0500, Muhammad Asif wrote: > > i have MSAccess table with 1 records without any index > i import same table in MySQL without any index > > When i access data from this table through ODBC in ColdFusion: > > Data from Access took 14 Sec and > Data from MySQL

Re: MySQL too slow....

2001-06-07 Thread WCBaker
L PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 2:19 AM Subject: Re: MySQL too slow > I want to use MySQL in web based > applications. Can u tell what other way i can go except ODBC > if i have to query the database(MySQL) through some scripting > languag

Re: MySQL too slow....

2001-06-07 Thread Hasan Niyaz
> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 2:19 PM Subject: Re: MySQL too slow > I want to use MySQL in web based > applications. Can u tell what other way i can go except ODBC > if i have to query the database(MySQL) through some sc

RE: MySQL too slow....

2001-06-07 Thread Simon Green
How about PhP? Simon -Original Message- From: Muhammad Asif [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 10:19 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL too slow I want to use MySQL in web based applications. Can u tell what other way i can go except ODBC if i

Re: MySQL too slow....

2001-06-07 Thread Van
Muhammad Asif wrote: > > I want to use MySQL in web based > applications. Can u tell what other way i can go except ODBC > if i have to query the database(MySQL) through some scripting > language(ASP,ColdFusion,JSP,Servlet) and have to display results in a web > browser... > > Thx in advance for

Re: MySQL too slow....

2001-06-07 Thread Muhammad Asif
- From: "Van" <[EMAIL PROTECTED]> To: "Muhammad Asif" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 1:00 PM Subject: Re: MySQL too slow > Muhammad Asif wrote: > > > > i have a table with 1 records in MS

Re: MySQL too slow....

2001-06-07 Thread Van
Muhammad Asif wrote: > > i have a table with 1 records in MS Access and > MySQL with no index in either database. > I query both tables from ColdFusion using ODBC datasources and > > Data from Access took 13sec to display while > Date from MySQL took 23sec to come up > > MySQL seems to be

MySQL too slow

2001-06-07 Thread Muhammad Asif
i have MSAccess table with 1 records without any index i import same table in MySQL without any index When i access data from this table through ODBC in ColdFusion: Data from Access took 14 Sec and Data from MySQL took 24 Sec MySQL seems to be halfway back?? Does this the case realy?? C

MySQL too slow....

2001-06-07 Thread Muhammad Asif
i have a table with 1 records in MS Access and MySQL with no index in either database. I query both tables from ColdFusion using ODBC datasources and Data from Access took 13sec to display while Date from MySQL took 23sec to come up MySQL seems to be half way slow should i use index