I'm currently running MySQL with tables that contain ~10 million rows.
Each row has 50 columns and the table has 27 indexes. The data size of
what you're describing doesn't seem so big. There are some arithmatics
in the MySQL manual on how much disk space is used per row.
If the tables you have are more or less read-only, i.e. if they're
loaded once and then are just being used, have a look at compressing
them with myisamchk.
My experiences with MERGE tables have not been satisfactory if you want
to run queries on them. Although the total size of the indexes was the
same as in a single table the response times were orders of magnitudes
different. You should write some test scripts and test the performance
of the queries you're going to run before you go down that path.
Although I don't think that you'll hit the 2 GB file size limit for the
data file you might keep an eye on that. At least for the stock Linux
2.2.x kernels the limit exists. RedHat started to provide the
-enterprise kernels which contain the large file system extensions.
Shane Anderson wrote:
>I would like to know the limitations of Mysql with extremely large tables. I
>need to store 20+ million records. Each record would contain only 4-6 fields
>and would not be longer than 128 bytes of information. The records could be
>divided among several tables, but at what size is the performance hindered
>enough to need to split records between several smaller tables? Any
>information leading to an optimal solution would be greatly appreciated.
>Thanks
>Shane Anderson
>Software Developer
>Web Accessibility in Mind - http://www.WebAIM.org
>
>
>---------------------------------------------------------------------
>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
>
--
Frank Schröder <[EMAIL PROTECTED]>
AirFlash Engineering Europe
www.airflash.com
AirFlash Inc.
---------------------------------------------------------------------
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
