Can MYSQL support databases with sizes around 4 GB? Will I have any performance issues?
I am planning to have a database of size more than 12 million records all of them in a single table and no other joins etc, used for search, filtered based on field names of the table, approximately 4 GB size in MYSQL backend and php frontend.
Question is can MYSQL support databases with sizes around 4 GB, Will I have any performance issue when I do a search using php
Will I be able to get results in atleast 30 to a 60 Secs
your suggestions please
Yes, you will have performance issues. Every application has database performance issues, even with much smaller databases than yours. You need to study and work to understand how to use the RDBMS technology to its best advantage.
The good news is that you can do it. A database of 4GB is not excessive, and many success stories involve databases that are much larger.
I suggest you start by studying the following resources:
- Chapter 7: Optimization
- High Performance MySQL, 2nd Edition by Baron Schwartz and others.
- MySQLPerformanceBlog.com where the top MySQL performance consultants write.
Combining technology like the APC cache or Memcached with PHP and MySQL is also practically required for high-performance PHP applications. Because the fastest database query is the one you don't have to run (because the data is already in a cache).
We can't answer your question about getting query results in 30 to 60 seconds, because we don't know what type of queries you need to run. There are many other factors for performance. The naive and general nature of your questions indicates that you have a lot of study to do before you will be successful.