I am not sure. Does anyone know any real examples of mysql handling huge database and still perform well? I am having problems with the performance with the MySQL Left join recently. A big table (about 2.5 million records) left join a small table (about 350K records) takes generally 2 mins to finish. I check the "explain" and primary key index on the small table was indeed used for the joining. My system is Redhat Linux 7.3 with 4 GB memory. I also tried replacing the default my.cnf with my-huge.cnf. It didn't help at all.
Another thing, with some linux system, there is a size limit for file. MySQL seems to store each of its table as single file. You need to choose a file system without that limit. Qunfeng Dong --- "B.G. Mahesh" <[EMAIL PROTECTED]> wrote: > > hi > > We are evaluating few databases for developing an > application with > following specs, > > 1. OS not very important. Leaning towards Linux > > 2. Currently the database has about 5 million > records but it will grow > to 120 million records. > > 3. The tables will have billing information for a > telecom company. > Nothing complex. > > 4. Back office staff will use the data in the > database to create > invoices to be sent to customers. This data is not > connected to the > live telecom system [e.g. switches etc]. We get the > data every day > from the telecom company. > > 5. Staff may perform queries on the database to get > reports like > "busiest hour of the day" etc etc. I don't see too > many concurrent > users using the system, however the system needs to > be stable. > > 6. Need to create excel, pdf files from the data in > the database. This > I think has nothing to do with the database, however > this is a requirement. > > 7. Needless to say, good security is a must which > will also be built > into the front end application. > > We are considering the following databases, > > 1. MYSQL > 2. Postgres > 3. Oracle > 4. MSQL > > If MYSQL or Postgres can do the job I prefer not to > spend the money on > Oracle/MSQL. However, if Oracle/MSQL are required > for getting good > reports and scalability, so be it. We will use > Oracle/MSQL. > > Any pointers/advice is appreciated > > > -- > -- > B.G. Mahesh > mailto:[EMAIL PROTECTED] > http://www.indiainfo.com/ > India's first ISO certified portal > > --------------------------------------------------------------------- > 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 > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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
