IL PROTECTED]>
Sent: Friday, January 23, 2004 6:20 PM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client
running xp
> Hi,
>
> 1) Try to reproduce the situation with pure myscl client (command-line
> client).
> 2) There is no any MySQL parameter that ch
.
- Original Message -
From: "Massimo Petrini" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 5:11 PM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client
running xp
> 1) yes, I am sure
Massimo Petrini wrote:
We have a server running NT4 with mysql 4.017 (with the my.ini as in
previuous mail). In the network the client (the single pc ) run msaccess
application linked to mysql database. In such case we use a temporary table,
created as follow
CREATE TEMPORARY TABLE wrk_AlzateInte
o: "Massimo Petrini" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, January 22, 2004 11:12 AM
> Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
>
>
> > > no; because the client have still the result of the query on the
scr
clear for you ?
Thanks
- Original Message -
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
To: "Massimo Petrini" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 11:12 AM
Subject: Re: temporary table in 4.0.17 on Windo
imo Petrini" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 11:08 AM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> no; because the client have still the result of the query
PROTECTED]>
Sent: Thursday, January 22, 2004 10:05 AM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> Hi Massimo,
>
> May be after some minutes of inactivity client closes connection to MySQL
> server?
> In this case MySQL deletes all temp tables that wer
lt;[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 7:30 AM
Subject: temporary table in 4.0.17 on Windows W2000 and NT4
> We have a problem to have "a long life" for the temporary table on innodb
> mode. We create the table, but after some minutes of inactivity the
sistem
> dr
We have a problem to have "a long life" for the temporary table on innodb
mode. We create the table, but after some minutes of inactivity the sistem
drops the table. My.ini in as follow. Which is the parameter to correct the
problem ?
Tks
Massimi
-
# Example mysql config file.
# C