Hello.
MySQL was developed to hold huge count of users and databases. In addition to: http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html You may read: http://dev.mysql.com/doc/mysql/en/Source_notes-Linux.html (There is also some tips about the magic number 1024). "Andreas Karlsson" <[EMAIL PROTECTED]> wrote: > Hi. > > I have database structure of about 45 tables, and a separate database for > each of the 100+ users. > Everything has been working nicely for quite some time. > > When I wrote a function that looped through all the DBs and ran some > queries, MySQL hung and I got "too many open files" in my .err-file. > (Mysql 4.0.22, trustix linux, reiserfs, mysql:open-files-limit at 1024) > > I am trying different ways of raising the limit, and that shouldn't be a > problem. > > My question is if I am doing this the wrong way? > > Will I be able to keep my structure, reach 500 users and keep things running > smoothly? > > Is it a problem to have that many databases? > > Thanx! > > /Andreas > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.799 / Virus Database: 543 - Release Date: 2004-11-19 > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
