Hybris 6.6 carts43sn table is too big. What is it used for

[d_ermakov]

We've found that table carts43sn is very big. It contains 16x more rows than cart table.

Where is it used and how can I clear it?

 enter code heremysql> desc carts43sn;
 +------------------+--------------+------+-----+---------+----------------+
 | Field            | Type         | Null | Key | Default | Extra          |
 +------------------+--------------+------+-----+---------+----------------+
 | ID               | bigint(20)   | NO   | PRI | NULL    | auto_increment |
 | ITEMPK           | bigint(20)   | YES  | MUL | NULL    |                |
 | ITEMTYPEPK       | bigint(20)   | YES  |     | NULL    |                |
 | timestamp        | datetime(6)  | YES  |     | NULL    |                |
 | currenttimestamp | datetime(6)  | YES  |     | NULL    |                |
 | changinguser     | varchar(255) | YES  |     | NULL    |                |
 | context          | longtext     | YES  |     | NULL    |                |
 | payloadbefore    | longtext     | YES  |     | NULL    |                |
 | payloadafter     | longtext     | YES  |     | NULL    |                |
 | operationtype    | bigint(20)   | YES  |     | NULL    |                |
 +------------------+--------------+------+-----+---------+----------------+
 
 mysql> select * from carts43sn limit 1\G
 *************************** 1. row ***************************
               ID: 1
           ITEMPK: 8806939263019
       ITEMTYPEPK: 8796094038098
        timestamp: 2018-03-21 13:47:03.711000
 currenttimestamp: 2018-03-21 13:47:03.770000
     changinguser: testkuser+_20171222131724@gmail.com
          context: {}
    payloadbefore: {"mapBasedAttributes":{},"attributes":{},"locAttributes":{}}
     payloadafter: {"mapBasedAttributes":{},"attributes":{"date":{"type":{"type":"java.util.Date","collection":""},"value":["1521636423546"]},"code":{"type":{"type":"java.lang.String","collection":""},"value":["200449000"]},"paymentcost":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"totalprice":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"totaltaxvaluesinternal":{"type":{"type":"java.lang.String","collection":""},"value":["[]"]},"discountsincludepaymentcost":{"type":{"type":"java.lang.Boolean","collection":""},"value":["false"]},"deliverycost":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"discountsincludedeliverycost":{"type":{"type":"java.lang.Boolean","collection":""},"value":["false"]},"totaltax":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"modifiedtime":{"type":{"type":"java.util.Date","collection":""},"value":["1521636423711"]},"itemtype":{"type":{"type":"de.hybris.platform.core.PK","collection":""},"value":["8796094038098"]},"subtotal":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"guid":{"type":{"type":"java.lang.String","collection":""},"value":["83f8e42b-d7e9-420d-bde0-e5b223ac7c88"]},"totaldiscounts":{"type":{"type":"java.lang.Double","collection":""},"value":["0.0"]},"currency":{"type":{"type":"de.hybris.platform.core.PK","collection":""},"value":["8800746242081"]},"creationtime":{"type":{"type":"java.util.Date","collection":""},"value":["1521636423546"]},"pk":{"type":{"type":"de.hybris.platform.core.PK","collection":""},"value":["8806939263019"]},"net":{"type":{"type":"java.lang.Boolean","collection":""},"value":["false"]},"calculated":{"type":{"type":"java.lang.Boolean","collection":""},"value":["false"]},"user":{"type":{"type":"de.hybris.platform.core.PK","collection":""},"value":["8797043884036"]}},"locAttributes":{}}
    operationtype: 1
 1 row in set (0.00 sec)

[d_ermakov · Accepted solution]

Found. It's generic audit logic. And it can be turned off in configuration. https://help.hybris.com/6.6.0/hcd/3e2b8491449d43b391eb1ce9c73cbb7f.html