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]
