MySQL Limitations for huge data / Drupal Framework

I want to use Drupal framework with MySql database for a portal with a lot of data, I mean 5-6 million records on some tables.
Is there any limitation in MySql for such amount of data?

Thanks
Super222Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KalpanCommented:
This would be depends on the size of the each database and the hosting server it supports...

please refer

http://www.fromdual.com/mysql-limitations

some hosting providers do offer the follwoing

MySQL databases are limited to 200 MB each. The number of databases your site can utilize depends on whether you have an Economy, Deluxe, or Unlimited plan.

MySQL Database Limits
Economy: 10
Deluxe: 25
Unlimited: No limit
For more information about MySQL databases, see the following articles:
Setting Up a MySQL database for Your website
Setting up a MySQL Database on Your Windows Hosting Account.
Super222Author Commented:
Dear kalmax,

I want to know the limitation of MySQL by itself, not the providers' limitations. I have my own dedicated server to install and run the MySQL.

Thanks
Usama FoadIT ManagerCommented:
MySQL can handle your 6 Mega records or more if you want. There are other limitations as kalmax mention.

Is there any limitation in MySql for such amount of data?
No
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

Ray PaseurCommented:
MySQL can handle arbitrarily large amounts of data.  When you get to the billions of rows, you may run into anomalies with the auto_increment integer keys.  And if you're concerned about performance, so you index the tables, you want to have a server that has a lot of memory so the keys can be in storage at all times.

Table with six million rows?  Not a problem at all -- that is squarely in the wheelhouse.
markloganCommented:
http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html

- "The minimum tablespace size is 10MB. The maximum tablespace size is four billion database pages (64TB). This is also the maximum size for a table. "

The MySQL software will never struggle with the data you throw at it, it will be the host limitations.

I work with tables with over 85million records in with no issues.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wolfgang_93Commented:
I find a bigger limitation is in maintenance.

For example, try using mysqldump to dump out 200 gig worth of databases.
You probably could not run such a job each day because it would likely
run for more than 24 hours to do so.

Try restoring a 200 gig worth of databases from a mysqldump.
It would also likely take you well over a day -- not a good scenario if you
are recoverying a production database from a backup because of a media
failure or corruption.

So unless you are doing mainly a read-only database system where you can
look at alternative backup/recovery techniques that don't come with MySQL
(e.g. suspending writes while you take a snapshot of your data), there is
a limit on total disk space usage of say 50 gig or less -- depending on the
power of the server you have set up etc.
markloganCommented:
If you are using MyISAM tables then you can always use mysqlhotcopy for backups.

http://dev.mysql.com/doc/refman/5.5/en/mysqlhotcopy.html

There is also using partitions and a DIFF backup and backing up only the files that have changed

http://dev.mysql.com/doc/refman/5.5/en/partitioning.html

But this all really depends on the format of your data.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.