Re: Initial Feasability Report
Reply #1 –
Disk usage should be fine. I don't know how long it'd take the database to reach hundreds of megabytes, but by that point performance might be more problematic than size. Honestly I have no idea, other than that as long as we stay below 1GB everything's peachy, and that'd take a long time to reach.
Assuming you're using mysql - every database has its own subdirectory in mysql's data directory:
/home/mysql# du -hs *
90K branca.err
2.0K branca.pid
2.6M forum
978K fud
5.0M ib_logfile0
5.0M ib_logfile1
18M ibdata1
952K mysql
174K performance_schema
2.0K test
to find the data directory:
mysql> show variables where variable_name="datadir";
+---------------+-------------+
| Variable_name | Value |
+---------------+-------------+
| datadir | /var/mysql/ |
+---------------+-------------+
1 row in set (0.01 sec)
( /var/mysql is a symlink to /home/mysql on my server. /var/mysql is the default. )