Is MySQL good for large database?

Question

MySQL can handle a lot, you just need to make sure you're using the right database engine that suits your needs. I use InnoDB for mostly performance reasons, but you can use anything that's not MyISAM. 27 апр. 2011 г.

Can MySQL support large databases?

If you have proper indexes, use proper engines (don't use MyISAM where multiple DMLs are expected), use partitioning, allocate correct memory depending on the use and of course have good server configuration, MySQL can handle data even in terabytes! There are always ways to improve the database performance.

Which database is best for large data?

TOP 10 Open Source Big Data DatabasesCassandra. Originally developed by Facebook, this NoSQL database is now managed by the Apache Foundation. ... HBase. Another Apache project, HBase is the non-relational data store for Hadoop. ... MongoDB. ... Neo4j. ... CouchDB. ... OrientDB. ... Terrstore. ... FlockDB.TOP 10 Open Source Big Data Databases - Bitnine.net

How big is too big for a MySQL database?

In addition, a practical size limit on MySQL databases with shared hosting is: A database should not contain more than 1,000 tables; Each individual table should not exceed 1 GB in size or 20 million rows; The total size of all the tables in a database should not exceed 2 GB.

Can MySQL handle 1 million records?

Millions of rows is fine, tens of millions of rows is fine - provided you've got an even remotely decent server, i.e. a few Gbs of RAM, plenty disk space. You will need to learn about indexes for fast retrieval, but in terms of MySQL being able to handle it, no problem.

Expert · Answer