Re: How many MySQL tables can we open paralel

[Bhavin Vyas]

10, 000 files open at the same time...maybe the OS itself is getting
flustered, you want to make sure that your OS can handle it, on *nix, u can
do a
ulimit -a and see the open files parameter
Beyond that, the system level limit on Linux can be found as
cat /proc/sys/fs/file-max

- Original Message -
From: Shoshi  Iphtach Cohen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 08, 2002 2:00 PM
Subject: How many MySQL tables can we open paralel


 Hi experts,

 I appreciate if you could tell me how many MySQL tables we can open in
 parallel.

 In our application (BuildaGate Suite Technology) which is based on PHP 
 MySQL, there are strange situations of data loss, and we are looking for
 information on what are the limitations of an MySQL database.

 We suspect that it is because we open more than 10,000 different tables
 in the same application, but we would like to receive professional
 technical suggestions.

 You can see and check the application at www.buildagate.com.

 Best regards,

 Shoshi Cohen - BuildaGate Suite Technology - General Manager

 e-Mail: [EMAIL PROTECTED]



 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How many MySQL tables can we open paralel

[Dan Nelson]

In the last episode (Jun 08), Shoshi  Iphtach Cohen said:
 Hi experts,
 
 I appreciate if you could tell me how many MySQL tables we can open in
 parallel.

From a client's point of view?  Unlimited.  Internally, mysql will only
open table_cache number of tables at once.  If the number of open
tables reaches that limit and another query comes in that needs a new
table, it closes the least-used table.  This is invisible to the
clients, though.
 
 In our application (BuildaGate Suite Technology) which is based on PHP 
 MySQL, there are strange situations of data loss, and we are looking for
 information on what are the limitations of an MySQL database.
 
 We suspect that it is because we open more than 10,000 different tables
 in the same application, but we would like to receive professional
 technical suggestions.

Wow. 1 tables at once is quite a lot :)  I have seen mysql have
problems when table_cache is set higher than the number of files the
OS allows it to open.  You'll get file not found errors when running
queries.  The solution is to tell the OS to allow mysql to open at
least 2*table_cache files.  I have never seen dataloss occur, though.

Are you getting any errors, or are records just going missing?
 
-- 
Dan Nelson
[EMAIL PROTECTED]
sql query

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php