[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: Help with MySQL connections PLEASE....
From:       "PeterWR" <pwr () post4 ! tele ! dk>
Date:       2004-03-26 6:57:14
Message-ID: 001401c412ff$94283540$d37542c0 () WDWORK3
[Download RAW message or body]

Hi,

my experience with "long query" (of course depending of complexity) is often
caused by missign index in the tables.

Best regards
Peter

----- Original Message ----- 
From: "Dwight Ian" <meimdwight@yahoo.com>
To: "Armando" <dijital@shaw.ca>
Cc: <win32@lists.mysql.com>
Sent: Friday, March 26, 2004 7:51 AM
Subject: RE: Help with MySQL connections PLEASE....


>
> Yes, but not always, sometimes it even cuts the result like for example im
querying a big table of 100 recors that has 4 columns of texts, sometimes it
cuts the result at the last and it will print mysql connection error.
>
> Im using a Pentium 3 800 MHz, 256 MB RAM.
>
>
> Armando <dijital@shaw.ca> wrote:
> Strange. I doubt the problem is related to memory or resources if your
> project is losing it's connection to mysql. Honestly I can't think of
> what would cause this. Does it happen when you are directly on the
> server as well, or is it only when you are coming in through a terminal
> client?
>
> -----Original Message-----
> From: Dwight Ian [mailto:meimdwight@yahoo.com]
> Sent: Thursday, March 25, 2004 6:31 PM
> To: Armando
> Cc: win32@lists.mysql.com
> Subject: RE: Help with MySQL connections PLEASE....
>
>
>
> "A long time" - means about 30 seconds (executing a query), but
> sometimes also when Im using the application for a long time-more 30
> minutes, it sometimes display a Mysql error saying that it cannot
> connect even though the query is short and the record set for the query
> is small.
>
>
>
>
> Armando wrote:When you say 'a long time' how long is
> it exactly before you get this time out error? And are these errors in
> the HTML interface?
>
> -----Original Message-----
> From: Dwight Ian [mailto:meimdwight@yahoo.com]
> Sent: Wednesday, March 24, 2004 7:25 PM
> To: win32@lists.mysql.com
> Subject: Help with MySQL connections PLEASE....
>
>
> win32@lists.mysql.com
>
> Good day to you all :) Hi, I have been using mysql for sometime now and
> i know the basics of it.My computer (server) is equipped with Apache
> 1.3.29, Php 4.3.4 and Mysql 4.0.13 I have a project and it consist of 85
> tables and is type InnoDB for foreign key checks and stuff. My question
> is... when i access my project (in the server) from a terminal client,
> so i first log in and do things like add, delete and update the tables
> through the html interface, and it works but when a query takes a long
> time because these tables contains a lot of data, more often than not i
> will get an error in MYSQL stating that it has lost connection. What
> maybe the reason for this?, is it due to memory or low resources?, or do
> i have to set some things in mysql configuration ? help is very well
> appreciated.Thanks :)
>
>
>
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Finance Tax Center - File online. File on time.


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=mysql-win32@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]