Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Bucharest
    Posts
    37

    Unanswered: temporary tables

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    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
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •