Title: I get a database error Occasionally
Last modified: July 3, 2020

---

# I get a database error Occasionally

 *  [mino0613](https://wordpress.org/support/users/mino0613/)
 * (@mino0613)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/i-get-a-database-error-occasionally/)
 * hi
 * I get a database error Occasionally.
    If anyone knows, I would like to get a 
   advice please.
 * WordPress databese error: MySQL server has gone away for query
    SELECT MIN(dt)
   AS dt, COUNT( ip ) AS v1, COUNT( DISTINCT ip ) AS v2 FROM wp_slim_stats WHERE
   1=1 AND (dt BETWEEN 1588809600 AND 1591228799 OR dt BETWEEN 1591228800 AND 1593617710)
   GROUP BY MONTH(CONVERT_TZ(FROM_UNIXTIME(dt), @@session.time_zone, ‘+00:00’)),
   DAY(CONVERT_TZ(FROM_UNIXTIME(dt), @@session.time_zone, ‘+00:00’)) made by wp_dashboard,
   do_meta_boxes, wp_slimstat_reports::callback_wrapper, wp_slimstat_reports::show_chart,
   wp_slimstat_db::get_data_for_chart, wp_slimstat_db::get_results

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [toxicum](https://wordpress.org/support/users/toxicum/)
 * (@toxicum)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/i-get-a-database-error-occasionally/#post-13066660)
 * The SQL query is ok.
    How big is your wp_slim_stats table?
 * If it is very big:
    Do you have the Slimstat setting Database > Data Retention
   set to a value > 0? Also, the “Archive Records” option can be enabled if Data
   Retention is on.
 * I have set mine to 365 days and archive on to keep the wp_slim_stats table small
   enough.

Viewing 1 replies (of 1 total)

The topic ‘I get a database error Occasionally’ is closed to new replies.

 * ![](https://ps.w.org/wp-slimstat/assets/icon.svg?rev=2832242)
 * [SlimStat Analytics](https://wordpress.org/plugins/wp-slimstat/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-slimstat/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-slimstat/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-slimstat/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-slimstat/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-slimstat/reviews/)

 * 1 reply
 * 3 participants
 * Last reply from: [toxicum](https://wordpress.org/support/users/toxicum/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/i-get-a-database-error-occasionally/#post-13066660)
 * Status: not resolved