I wonder how many capacity of Mysql. Please tell me with details of some Server Specifications(OS,CPU,RAM...).
Thanks in advanced, Rithy
migrated from stackoverflow.com Dec 20 '10 at 20:50
This question came from our site for professional and enthusiast programmers.
Wow -- this is an impossible question to answer. Other than using the ambiguous term "capacity", it's all really dependent on your dataset, schema and your usage patterns.
Having said that, most applications are bottlenecked by disk seeks (rather than being limited by the CPU). If I had to sum up a starting point in one sentence, I'd say use InnoDB for all your tables and make sure your entire dataset (data plus indexes) fits in your InnoDB buffer pool (RAM).