Data MySQL can support

500,000 TB???  I don't know the answer, but I'm curious why you need to know.  According to http://www.focus.com/fyi/10-largest-databases-in-the-world/, the biggest so far 2.8 Petabytes, or "just" 2,800 TB.

the question needs to be clarified on 500'000 TB for 1 single table? or for the hole db?

in short: the size of the largest table is limited by the OS' filesystem, and not so much by the db engine you use.
after that, you will have considerations on the primary keys etc ...

so, if you create 1000'000 tables with 500 MB each, or 500'000 tables with 1 TB each (or some other variants), it would work with MySQL as well as any other db system, in general.

however, I concur with above remark: 500'000 TB? for storing what?
because that is also part of the question: is it text or binary? what would be the biggest size for a single "blob" part?

Thanks for your reply. Anyway, I got the project from Thai Government and the project specification indicated that I have to use the DBMS that can store up to 500,000 TB! I just want some proven to show to the project owner that MySQL can store up to 500,000 TB even it's not happen in the real life. Or if MySQL can't, can MS-SQL or Oracle can handle that or no!

How do u think the way to prove to my customer regarding this?

Thanks
Withoon

Thank angelIII for your advice. So what you mean MySQL can handle upto 500K TB, right? No limitation on its capacity. The limitation is hardware only.