I am currently working on some experiments and have to deal with some millions of tuples. As you can imagine indexing is essentiall. However My InnoDB file has grown to over 3.6G and fragmentation is sometimes a big problem. Additionally the file keeps its size even after dropping the 'big' tables. So, any suggestions in order to optimize the space usage?
thanx in advance aik_b
