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]
