Re: Temp table on multiple connections

[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 db2 but
 thought it could be easier just to use the temporary table created by the
 query on db1.


Even if the two servers are replicating temporary tables won't be available
on the second host. You might be able to use the federated engine to
accomplish what you're trying to do, but I doubt it.

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

[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 with their own descriptors or like the heap engine use none at
all. it's possible to have many more open tables than file
descriptors.

-Eric

On Mon, Jun 2, 2008 at 9:54 AM, Jean-Paul Bauer [EMAIL PROTECTED] wrote:
 Hi all,
 I'm a bit confused about the allowed range of values for the
 open-files-limit and the table_cache settings. The documentation
 states that the range of values allowed for open-files-limit is
 0-65535 and for table_cache it is 1-524288.

 Where I get confused is that from my understanding each table in the
 table_cache will require at least one file descriptor (two if it is a
 MyISAM) table. Surely this means that the maximum for table_cache
 effectively is 65535. What am I misunderstanding or missing here?

 Documentation links:
 http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_open-files-limit
 http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_table_cache

 Thanks for any clarification on this.

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
high performance mysql consulting.
http://provenscaling.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]