MySql optimization for large tables - memory requirements
Posted on 2006-05-25
I have mySQL and PHP running on a single dedicated server hosting a web application and will have aprox 10 - 30 concurrent connections. The database contains a person table with 12 million records (2GB) and an address table with 8 million records (1.5GB). The entire database including the other tables will be about 5 - 6 GB. I am currently running a default installation of XAMPP and have not optimized any memery setting in mySQL. The server has 1.5GB installed. I know I am not giving enough information for a specific answer, but are there any obvious issues or bottlenecks limiting performance? Is 1.5GB way to small for this database? Most queries are optimized to use indexes but occasionally someone will run something that is not optimized and seems to bring things to a halt.