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

    (@toxicum)

    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.