[Vtigercrm-developers] Large database

Ranieri rslemer at gmail.com
Wed May 18 15:09:06 GMT 2016


Hi Alan,  what configuration in config.perfomance influence this table ?

Thanks a lot!



2016-03-01 9:58 GMT-03:00 Alan Lord <alanslists at gmail.com>:

> On 01/03/16 12:34, Stacey Johnson wrote:
>
>> vtiger_sqltimelog - 912 MB
>>
>
> I'd empty that one! That's a throwback to a setting in
> config.performance.php which is no longer used as far I can tell. This
> table gets massive very quickly.
>
> vtiger_modtracker_detail - 664 MB
>>
>
> This one will get pretty big pretty quickly but I would normally be
> interested in row count rather than physical size as that is dependent on
> all sorts of other params.
>
> vtiger_crmentity - 450MB
>>
>
> Again - it's really about rows. the problem with this table is the use of
> the description column for emails... (Who thought that was a good idea
> needs their head examining!).
>
> We have a few customers where a mysqldump file will be more than 2GB. That
> would mean to me that crmenity is around 3million rows and
> modtracker_detail will be over 3 million rows.
>
> If you use lots of indexes the db will also get bigger.
>
> Al
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20160518/318bad55/attachment.html>


More information about the vtigercrm-developers mailing list