Hello,
For a database population program I run, I have observed that the disk
space allocation is larger when populating the database with multiple
concurrent connections.
For a specific configuration, the database ends up at 642 MB with a
single connection, whereas it ends up at 1.3 GB when using multiple
connections. The raw data volume is at about 215 MB, there are 20 tables
and between 20 and 30 indexes (didn't take the time to figure out which
indexes are composite, 'show indexes' doesn't give this information but
returns 31 rows).
Is this to be expected?
For the 1.3 GB database, compressing it brings it down to 642 MB again.
--
Kristian
