search

metadatacenter / cedar-project

Build project for all CEDAR Java repositories
https://github.com/metadatacenter/cedar-docs/wiki
Other
12 stars 1 forks source link

Decrease the number of Cypher queries logged to MySQL #1134

Closed marcosmro closed 1 year ago

marcosmro commented 3 years ago

CEDAR is currently logging a huge number of Cypher queries to MySQL, which causes disk space problems periodically. See if it's possible to decrease the number of queries logged to the DB.

MySQL table: log_cypher, in the cedar_log DB (mysql -h 127.0.0.1 -u cedar_log_usr -p cedar_log)

marcosmro commented 3 years ago

From @alexskr: The short-term plan to address this issue is to set up a cron job to delete log entries older than lets say 1 month and run it on regular bases so that table doesn't grow too large.

marcosmro commented 3 years ago

Here is the current disk space usage (/srv is at 71%). We can use these numbers as a reference to check that the cron job mentioned by @alexskr is working properly:

[cedar@cedr-prd-app-01 ~]$ df
Filesystem                  1K-blocks      Used  Available Use% Mounted on
devtmpfs                     32895412         0   32895412   0% /dev
tmpfs                        32904004         0   32904004   0% /dev/shm
tmpfs                        32904004     66432   32837572   1% /run
tmpfs                        32904004         0   32904004   0% /sys/fs/cgroup
/dev/mapper/vg_sys-lv_root   26197508  11235828   14961680  43% /
/dev/sdc1                  2146434032     33844 2146400188   1% /tmp
/dev/sda1                     1038336    155828     882508  16% /boot
/dev/mapper/vg_data-lv_srv  268300292 189295012   79005280  71% /srv
tmpfs                         6580804         0    6580804   0% /run/user/248474