How much data can MySQL effectivly handle?

[listenmirndt]

Generally speaking, on average..

How many tables? how many rows? Fields in each row?

Just trying to get a rough idea..

Thanks!

[olaf]

You cant answer the question like this.

Maybe one simple rule don't create tables where a lot of columns are empty for a the most of the records.

If you can insert (usefull) data in every column than it make sense to create tables with a more columns .

number of rows:
There are people on the net with more than 100.000 records in a table without problems

[TheSoko]

One of my friends is running a PHP/MySQL database with at least 10 gigabytes of data. It's a snapshot of objects in a 3D World, and as I'm posting this he's got 157,992,188 objects in there.

https://tangent.imatowns.com/awps/

MySQL can probably handle your needs. 😉

[Sxooter]

The real issue isn't how much stuff you can put in a database and get back out, it's how many people, at the same time, can put data in and take it out.