hello guys

i am working on a php application that uses mysql, and first it initialise some temporary tables in the database and then fills them with default values.

ex.
CREATE TEMPORARY TABLE IF NOT EXISTS `tmp_table1`
...
TYPE=InnoDB;

INSERT INTO `tmp_table` ... VALUES ...

i have to mention that the script uses mysql_pconnect()
mysql.connect_timeout = -1
mysql.max_persistent Unlimited
mysql.allow_persistent On
mysql.max_links Unlimited

mysql connect timeout = 5
mysql wait timeout = 28800

when i execute the script the temporary tables are ok, after i make some INSERT and UPDATE statements on the temporary tables, and i idle couple of seconds it shows me the message:

Table 'database1.tmp_table1' doesn't exist

I don't know what settings i have missed, or misunderstood, so my tmp tables timeout very quickly. Please help.

Thanks

Serban

I thinks that the problem is that you use a temporary table with innodb so each thread will access only to there temporary table
You may myisam instead