Answers.Body: <p>Thats from Civimobile extension and You can find quick solution at <a href="https://lab.civicrm.org/extensions/civimobileapi/-/issues/57#note_54817" rel="nofollow noreferrer">https://lab.civicrm.org/extensions/civimobileapi/-/issues/57#note_54817</a></p>
  <blockquote>
  <p>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</p>
  </blockquote>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-07T11:23:41.597Z
Answers.Text: That's very interesting and seems certain to fix. Just for interest - I do have civimobile extension installed but haven't really started to use it. What's the push notifications table for (given that it isn't actualy pushing anything to anyone as I'm not actually using it).
Answers.UserDisplayName: Caroline B
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-07T11:18:36.370Z
Answers.LastActivityDate: 2021-04-07T11:18:36.370Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Database table Table: civicrm_contact_push_notification_messages</p>
  <p>Is huge. 51GB to be precise.</p>
  <p>The main field is %display_name has created activity.</p>
  <p>Is this the table that shows up what emails have been sent under a user's activity tab? Or something else.</p>
  <p>Does anyone know?</p>
  <p>Thakns!
  Caroline</p>
  
Tags: <database><mysql>
Title: One database table very large
ThreadText: # One database table very large
  
  (Asked by: username_0 on 2021-04-07)
  
  Database table Table: civicrm\_contact\_push\_notification\_messages
  
  Is huge. 51GB to be precise.
  
  The main field is %display\_name has created activity.
  
  Is this the table that shows up what emails have been sent under a user's activity tab? Or something else.
  
  Does anyone know?
  
  Thakns!
  username_0
  
  **Tags:** database, mysql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-04-07. Score: 3 | Accepted answer
  
  Thats from Civimobile extension and You can find quick solution at <https://lab.civicrm.org/extensions/civimobileapi/-/issues/57#note_54817>
  
  > 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
  
  > **Comments:**
  > **username_0**: That's very interesting and seems certain to fix. Just for interest - I do have civimobile extension installed but haven't really started to use it. What's the push notifications table for (given that it isn't actualy pushing anything to anyone as I'm not actually using it).  
  
  ---
  
  