Good day!
I wonder how storagespace is affected by the storage of data in a mysql-database. Is there a way to calculate what eg. 1000 txt files with each 5KB would take up in a mysql db?
Thanx for your help
Johannes
just do it and check the table sizes. MySQL tables are just files and the size is easily found for them.
The MySQL manual has descriptions of how much data each datatype uses. For varchar fields the overhead is in the order of a few bytes for each field.
