List:General Discussion« Previous MessageNext Message »
From:Bhavin Vyas Date:June 8 2002 11:49pm
Subject:Re: How many MySQL tables can we open paralel
View as plain text  
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" <aai@stripped>
To: <mysql@stripped>
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
> Best regards,
> Shoshi Cohen - BuildaGate Suite Technology - General Manager
> e-Mail: info@stripped
> ---------------------------------------------------------------------
> Before posting, please check:
>   (the manual)
>           (the list archive)
> To request this thread, e-mail <mysql-thread111410@stripped>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try:

How many MySQL tables can we open paralelShoshi & Iphtach Cohen8 Jun
  • Re: How many MySQL tables can we open paralelBhavin Vyas8 Jun
  • Re: How many MySQL tables can we open paralelDan Nelson9 Jun