并发数100倒不是什么问题。一天60K记录,一年 365*60K = 22M 也就是 2千2百万。 这个数据MYSQL可以支持。不过你自己需要测算一下每条记录的大小是多少。http://dev.mysql.com/doc/refman/5.5/en/storage-engines.html Table 13.1. Storage Engines Feature Summary 13.5. The MyISAM Storage Engine There is a limit of (232)2 (1.844E+19) rows in a MyISAM table.
Table 13.1. Storage Engines Feature Summary
13.5. The MyISAM Storage Engine
There is a limit of (232)2 (1.844E+19) rows in a MyISAM table.
http://dev.mysql.com/doc/refman/5.1/zh/partitioning.html