Whilst a truncate table operation is underway a lock mutex around the table is created to ensure data consistency; if using innodb file per table the physical .ibd file must be removed which is a painfully slow operation under ext3.
You are currently browsing articles tagged data warehouse.
Tags: data warehouse, MySQL, performance
Customer interactions create a wealth of timely data that marketing departments are eager to exploit. The customer status fact table provides a central switchboard for using this fast-moving data.
Tags: data warehouse, dimension, dw