Hi!
I did a order on selection today, and Mysql complaint that SQL_tabøe wa full. Hovever
I messed up a simple join on 3200 records...
Tha fact is that at least the previos Mysql adition is configured for small footprint
etc. Mysql have made 3 samples of configs we can use, on there site somwhere.
There is an article on how to optimise Mysql on weberdev.com or devshed.com.
I am moving my Mysql over on a new box, giving it more ram and are to change the
config.
Bjarne
----- Original Message -----
From: "Leon Atkinson" <[EMAIL PROTECTED]>
To: "FreeTrade" <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 11:48 PM
Subject: Re: [FreeTrade] Invoice missing
> > In the example above in effect i remove the order method but i never
> tested on
> > FreeTrade module.
> >
> > It's very strange that in 6 month (or more) i never had this problem and
> now i have
> > this problem on all 3 sites ...bah!
>
> Whenever you do an ORDER-BY clause in MySQL, it creates a temporary table to
> do the sorting on. By default temporary tables are done in memory, and the
> available memory is relatively limited. It's possible that between versions
> of MySQL that memory size was changed, but in any event you'd run into this
> problem eventually, I think. One way to combat it is to tweak the settings
> for MySQL, which are in a file called my.cfg. (It doesn't have to exist,
> and I think it isn't there by default. You'll have to check the docs.).
>
> Another way to deal with it is to force the temporary table to disk. This
> can be done on a per-query basis with a special mysql command. It's
> something like SQL_BIG_TABLES=1 or something. (Aren't we using this in
> FreeTrade already? It seems like we added that.)
>
> ---
> Leon Atkinson <http://www.leonatkinson.com/>
>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
