2 questions: 1. Are you sure that client or someone between client and MySQl server doesn't close connection? Because > the client have still the result of the query on the screen
is not a proof that connection is still active. 2. How do you link your msaccess application with MySQL server? Are you sure that your application or someone between doesn't use connections pool? Mikhail. ----- Original Message ----- From: "Massimo Petrini" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 22, 2004 1:35 PM Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 > 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_AlzateIntervalli(Lotto CHAR(10) NOT NULL,Indice > CHAR(3) NOT NULL,NMisura SMALLINT NOT NULL,IndiceIntv CHAR(1) NOT > NULL,ValMin REAL NULL,ValMax REAL NULL, PRIMARY KEY (Lotto, Indice, NMisura, > IndiceIntv)); > > The statement sql is lunched from the client to the server; it create a > temporary table used only from the client creator. > Is 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 Windows W2000 and NT4 > > > > > no; because the client have still the result of the query on the screen > > and > > > on the server the thread is still existent in sleep mode. > > > > could you explain in details what is your system configuration? > > what is the client of MySQL server? > > > > > > ----- Original Message ----- > > From: "Massimo 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 on the screen > > and > > > on the server the thread is still existent in sleep mode. > > > > > > ----- Original Message ----- > > > From: "Mikhail Entaltsev" <[EMAIL PROTECTED]> > > > To: "Massimo Petrini" <[EMAIL PROTECTED]>; > > <[EMAIL 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 were created by this > > > client. > > > > > > > > Best regards, > > > > Mikhail. > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Massimo Petrini" <[EMAIL PROTECTED]> > > > > To: <[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 > > > > > drops the table. My.ini in as follow. Which is the parameter to > > correct > > > > the > > > > > problem ? > > > > > Tks > > > > > > > > > > Massimi > > > > > ----------------- > > > > > # Example mysql config file. > > > > > # Copy this file to c:\my.cnf to set global options > > > > > # > > > > > # One can use all long options that the program supports. > > > > > # Run the program with --help to get a list of available options > > > > > > > > > > # This will be passed to all mysql clients > > > > > [client] > > > > > #password=my_password > > > > > port=3306 > > > > > #socket=MySQL > > > > > > > > > > # Here is entries for some specific programs > > > > > # The following values assume you have at least 32M ram > > > > > > > > > > # The MySQL server > > > > > [mysqld] > > > > > port=3306 > > > > > #socket=MySQL > > > > > skip-locking > > > > > set-variable=key_buffer=16K > > > > > set-variable=max_allowed_packet=16M > > > > > set-variable=thread_stack=64K > > > > > set-variable=table_cache=4 > > > > > set-variable=sort_buffer=1024K > > > > > set-variable=net_buffer_length=2K > > > > > > > > > > > > > > > > > > > > #PER REPLICA > > > > > server-id=19 > > > > > master-host=pissarro > > > > > report-host=pissarro > > > > > master-user=root > > > > > #skip-slave-start > > > > > replicate-wild-ignore-table=OMTWRK.WRK_% > > > > > replicate-wild-ignore-table=omtwrk.wrk_% > > > > > set-variable=slave-net-timeout=172800 > > > > > > > > > > > > > > > # Uncomment the following if you want to log updates > > > > > #log-bin > > > > > > > > > > # Uncomment the following rows if you move the MySQL distribution to > > > > another > > > > > # location > > > > > basedir=C:\mysql\ > > > > > #datadir=C:\AnnaNoBck\DATI\MySQL\data\ > > > > > datadir=D:\applicaz\mysql\Data\ > > > > > > > > > > # > > > > > log-error=d:\applicaz\mysql\data\mysql.err > > > > > > > > > > # Uncomment the following if you are NOT using BDB tables > > > > > skip-bdb > > > > > > > > > > # Uncomment the following if you are using Innobase tables > > > > > innodb_data_file_path=\InnoData\HymnOMT:10M:autoextend > > > > > > > > > > #innodb_data_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB > > > > > #innodb_log_group_home_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog > > > > > #innodb_log_arch_dir=C:\AnnaNoBck\DATI\MySQL\InnoDB\InnoLog > > > > > > > > > > innodb_data_home_dir=D:\applicaz\mysql\InnoDB > > > > > innodb_log_group_home_dir=D:\applicaz\mysql\InnoDB\InnoLog > > > > > innodb_log_arch_dir=D:\applicaz\mysql\InnoDB\InnoLog > > > > > > > > > > set-variable=innodb_mirrored_log_groups=1 > > > > > set-variable=innodb_log_files_in_group=3 > > > > > set-variable=innodb_log_file_size=5M > > > > > set-variable=innodb_log_buffer_size=8M > > > > > innodb_flush_log_at_trx_commit=1 > > > > > innodb_log_archive=0 > > > > > set-variable=innodb_buffer_pool_size=16M > > > > > set-variable=innodb_additional_mem_pool_size=10M > > > > > set-variable=innodb_file_io_threads=4 > > > > > set-variable=innodb_lock_wait_timeout=50 > > > > > default-table-type=innodb > > > > > > > > > > #solo >=4.0.14 permette di mantenere alla definizione di > > max_binlog_size > > > > la > > > > > dimensione del file di relay > > > > > #set-variable=max_relay_log_size=0 > > > > > > > > > > [mysqldump] > > > > > quick > > > > > set-variable=max_allowed_packet=16M > > > > > > > > > > [mysql] > > > > > no-auto-rehash > > > > > # Remove the next comment character if you are not familiar with SQL > > > > > #safe-updates > > > > > > > > > > [isamchk] > > > > > set-variable=key_buffer=8M > > > > > set-variable=sort_buffer=8M > > > > > > > > > > [myisamchk] > > > > > set-variable=key_buffer=8M > > > > > set-variable=sort_buffer=8M > > > > > > > > > > [mysqlhotcopy] > > > > > interactive-timeout > > > > > > > > > > [WinMySQLAdmin] > > > > > Server=C:/mysql/bin/mysqld-max-nt.exe > > > > > QueryInterval=10 > > > > > > > > > > --------------------------------------------------------- > > > > > Massimo Petrini > > > > > c/o Omt spa > > > > > Via Ferrero 67/a > > > > > 10090 Cascine Vica (TO) > > > > > Tel. +39 011 9505334 > > > > > Fax +39 011 9575474 > > > > > E-mail [EMAIL PROTECTED] > > > > > > > > > > > > > > > -- > > > > > MySQL General Mailing List > > > > > For list archives: http://lists.mysql.com/mysql > > > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
