I have some problems with my database setup: The MySQL Database is written to every few seconds and it grows in size very quickly. My disk space is limited though, so I have to work around that. However, the data should not be that big. It's 3 tuples of type DOUBLE and their auto_increment Primary key which are written to the Database. It already contains about 12M rows (in one table!). The server has only 512MB of RAM and queries are taking very long.
Now, every time I mysqldump the DB, the dump file is way smaller than the database itself. How is that? Should I just remove all foreign key relations to increase performance? Is there a way to distribute the Database over multiple servers?
Thanks in advance.