Can MYSQL support databases about 4 GB in size? Will I have performance issues?

Question

I plan to have a database of more than 12 million records, all of them in one table, as well as no other joins, etc. used for search, filtered by table field names, approximately 4 GB in the MYSQL backend and php interface .

Question: can MYSQL support databases about 4 GB in size, will I have a performance problem when doing a search using php

Will I be able to get results for at least 30 to 60 seconds

your suggestions please

Answer 1

Yes, you will have performance issues. Each application has problems with database performance, even with much smaller databases than yours. You need to learn and work to understand how to use RDBMS technology in your best interests.

The good news is that you can do this. A 4 GB database is not excessive, and many success stories relate to databases that are much larger.

I suggest starting with a study of the following resources:

• Chapter 7: Optimization
• High Performance MySQL, 2nd edition of Baron Schwartz and others.
• MySQLPerformanceBlog.com , where the best MySQL performance consultants write.

Combining technologies such as APC Cache or Memcached with PHP and MySQL is also practically required for high-performance PHP applications. Since the fastest database query is the one you don't need to run (since the data is already in the cache).

We cannot answer your question about receiving query results within 30-60 seconds, because we do not know what types of requests you need to run. There are many other performance factors. The naive and general nature of your questions indicates that you have to go through a lot of research before you succeed.

Answer 2

There is no fundamental reason that a 4 GB database with 12 million rows should have performance issues, but that does not mean that it is not. If you make basic selection queries in the same table with reasonable indexes, your results should return within 20 to 30 seconds. Uploading a result set (if large) to your page can take considerable time.

Why not give it a try? Can you upload your data to the test server with MYSQL / MARIADB and make some test queries, which will give you a good indicator to start with.

Answer 3

Yes, of course, mysql can support small databases like 4G. You will not have performance problems, as your database server will have> 4G of memory, so the entire database can be stored in memory.

If you wanted to use a large database, MySQL, of course, can support this, but you cannot say, 1Tb, in ram.

Answer 4

Take a look at these links:

http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB

http://www.allinterview.com/showanswers/35641.html

MySQL works with two well-known database engines: MyISAM and InnoDB. InnoDB is known for its high performance in large databases.

Answer 5

Appropriate indexes and simple queries will handle SELECT performance issues.

Answer 6

As a reference point, we have a 15 GB database, but it is split between different tables. The largest tables have the simplest structures that help increase productivity.