Kristian Waagan wrote:
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?
No. The Difference in size seems to be too high with just inserts.
Are you doing inserts into the same table in parallel threads ?. Is it
one particular tables/index that is becoming too big or all the
tables/indexes ?
Thanks
-suresh
- Re: Increased disk space allocation when populating datab... Suresh Thalamati
-
