database table civicrm_pivotreportcache

[mikantchap]

Hi

We recently had an issue with the database table civicrm_pivotreportcache.

It grew to about 18GB and crashed the whole server (disk full) taking down several sites.

Have you had any reports or issues regarding this table?

[jamienovick]

@mikantchap Thats very possible. We did our best to try and optimse the library to work with larger data sets but unfortunately the way the library works is to try and load all the data to your browser in advance so you can pivot on it in the browser. The cache table tried to prepare that data so the loading was a quick as possible, but that might not be suitable for all server setups unfortunately.

Which entity are you trying to create pivot reports on?

[jitendrapurohit]

In our case, it was with log_civicrm_pivotreportcache table. Probably we should rename the main table civicrm_pivotreportcache to civicrm_pivotreport_cache so the log table isn't created by civicrm?

[jitendrapurohit]

Have raised #122 to fix the above comment after we see the log table problem on another server.