Answers.Body: <p>seamuslee wrote 11 months ago on <a href="https://lab.civicrm.org/extensions/civimobileapi/-/issues/57" rel="nofollow noreferrer">https://lab.civicrm.org/extensions/civimobileapi/-/issues/57</a> :
  One thing I have found is editing the scheduled job Civimobile clean old push notification messages and setting a command / API parameter</p>
  <p>count_of_day=1</p>
  <p>which means keep only 1 days worth of notification messages can help.</p>
  <p>Works :)</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-01-26T18:15:30.317Z
Answers.LastActivityDate: 2022-01-26T18:15:30.317Z
Answers.UserDisplayName: wintermoor
Answers.Body: <p>We are having this same issue. The civicrm_contact_push_notification_messages table has grown to 4GB with 14million records in just 14 days. There is a 'Civimobile clean old push notification messages' scheduled job but it only cleans notifications older than 90 days.</p>
  <p>This appears to be causing timeouts on our server due to low resources. Is there any way we can turn this excessive logging off?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-11T18:55:30.777Z
Answers.LastActivityDate: 2020-09-11T18:55:30.777Z
Answers.UserDisplayName: CMM Administrator
Body: <p>We installed Civimobile as a test, and aren't yet using it. It does look great!</p>
  
  <p>We have noticed a file on our server of gigantic proportions: 
  civicrm/civicrm_contact_push_notification_messages.ibd: 18GB</p>
  
  <p>Is this just generated by the Civimobile API? And if so, have we done something wrong in our setup that it has become so large? I think the extension was enabled for about 4 weeks, and has been disabled for about 6 weeks. And we haven't been using the CiviMobile app at all when the extension was enabled.</p>
  
  <p>How can we reduce the size of this file, or remove it? We don't want to use up that much space on our server if we don't have to. </p>
  
  <p>Thanks for your help.</p>
  
  <p>Civicrm 5.24, Drupal 7.69</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T20:05:11.400Z
Comments.Text: You might want to open an Issue at https://lab.civicrm.org/extensions/civimobileapi/-/issues as the devs are more likely to be watching that
Comments.UserDisplayName: petednz - fuzion
Tags: <database><civimobile>
Title: civicrm_contact_push_notification_messages table huge
ThreadText: # civicrm_contact_push_notification_messages table huge
  
  (Asked by: username_0 on 2020-05-05)
  
  We installed Civimobile as a test, and aren't yet using it. It does look great!
  
  We have noticed a file on our server of gigantic proportions:
  civicrm/civicrm\_contact\_push\_notification\_messages.ibd: 18GB
  
  Is this just generated by the Civimobile API? And if so, have we done something wrong in our setup that it has become so large? I think the extension was enabled for about 4 weeks, and has been disabled for about 6 weeks. And we haven't been using the CiviMobile app at all when the extension was enabled.
  
  How can we reduce the size of this file, or remove it? We don't want to use up that much space on our server if we don't have to.
  
  Thanks for your help.
  
  Civicrm 5.24, Drupal 7.69
  
  **Tags:** database, civimobile
  
  > **Comments:**
  > **username_1**: You might want to open an Issue at https://lab.civicrm.org/extensions/civimobileapi/-/issues as the devs are more likely to be watching that  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2022-01-26. Score: 1
  
  seamuslee wrote 11 months ago on <https://lab.civicrm.org/extensions/civimobileapi/-/issues/57> :
  One thing I have found is editing the scheduled job Civimobile clean old push notification messages and setting a command / API parameter
  
  count\_of\_day=1
  
  which means keep only 1 days worth of notification messages can help.
  
  Works :)
  
  
  ---
  
  ### Answer by username_3 on 2020-09-11. Score: 0
  
  We are having this same issue. The civicrm\_contact\_push\_notification\_messages table has grown to 4GB with 14million records in just 14 days. There is a 'Civimobile clean old push notification messages' scheduled job but it only cleans notifications older than 90 days.
  
  This appears to be causing timeouts on our server due to low resources. Is there any way we can turn this excessive logging off?
  
  
  ---
  
  