Re: Using file_per_table, ibdata1 file still grew to 77GB
(I still don't have an explanation of the large ibdata1.)
SHOW CREATE TABLE
for the relevant tables; these may give some more clues.
Also EXPLAIN SELECT for the naughty query.
Smells like a DW task, where Summary table(s) can save the day:
http://mysql.rjweb.org/doc.php/datawarehouse
(I need to CREATEs to provide more details.)
Subject
Written By
Posted
Re: Using file_per_table, ibdata1 file still grew to 77GB
July 24, 2013 09:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.