Slow Query and the wordpress backend is very slow

  • Resolved amjadm61

    (@amjadm61)


    1 month, 3 weeks ago

    mysql> SELECT COUNT() FROM wp_statistics_visitor; +----------+ | COUNT() |
+----------+
| 1565438 |
+----------+
1 row in set (0.30 sec)

mysql> SELECT COUNT() FROM wp_statistics_visitor_relationships; +----------+ | COUNT() |
+----------+
| 6541861 |
+----------+
1 row in set (8.42 sec)

mysql> SELECT SQL_CALC_FOUND_ROWS id FROM wp_pmpro_membership_orders ORDER BY id DESC, timestamp DESC LIMIT 5;
+--------+
| id |
+--------+
| 258246 |
| 258245 |
| 258244 |
| 258243 |
| 258242 |
+--------+
5 rows in set (0.99 sec)
Viewing 1 replies (of 1 total)
  • Plugin Author Mostafa Soufi

    (@mostafas1990)

    1 month, 3 weeks ago

    Hello,

    I’ve noticed that our database contains a substantial amount of visitor records, To improve our database performance, I suggest we remove visitor records older than six months. Here’s how:

    1. Go to Settings → Data Management.
    2. Turn on Purge Old Data Daily.
    3. Set Purge Data Older Than to 180 days.

    Feel free to reach out if you have any questions.

    Best

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.