Re: Temp table on multiple connections

2008-06-08 Thread Omni Adams
On Fri, Jun 6, 2008 at 9:25 PM, TUT - LightSpeed [EMAIL PROTECTED] wrote: Actually they are 2 connection to 2 different databases on 2 different hosts. I wanted rquery results from db1 to be in a temporary table to be used in db2. I can go around it with some php code to create the table in

Re: Why open-files-limit smaller than table_cache?

2008-06-08 Thread Eric Bergen
Hi, It's true that MyISAM keeps two files descriptors open per open table but this is MyISAM specific. An open table in MySQL isn't a one to one mapping to file descriptors, it's simply a c++ object. It's up to the storage engine how it manages file descriptors. Engines can use worker threads