var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: temporary tables
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.
CREATE TEMPORARY TABLE IF NOT EXISTS `tmp_table1`
INSERT INTO `tmp_table` ... VALUES ...
i have to mention that the script uses mysql_pconnect()
mysql.connect_timeout = -1
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.
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