0
Good afternoon!

I have two components installed: Music Collection and Content Statistics. I noticed that the xxxxx_content_statistics table has a very large value in the database - 564.8 Mb. Can we do something about this?

In addition, the hoster sent a notification that a significant part of the site's resources were consumed by requests to the database server.

And gives an example: SELECT COUNT(*) FROM xxxxx_muscol_songs WHERE artist_id = 33; where, according to them, 1787 rows are analyzed without using indexes:

+----+-------------+--------------------+------------+------+---------------+------+---------+------+------+----------+-------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+-------------+--------------------+------------+------+---------------+------+---------+------+------+----------+-------------+
| 1 | SIMPLE | v0ecf_muscol_songs | NULL | ALL | NULL | NULL | NULL | NULL | 1787 | 10.00 | Using where |
+----+-------------+--------------------+------------+------+---------------+------+---------+------+------+----------+-------------+

We recommend contacting the developer to optimize SQL queries.

Is there anything you can recommend?
Attachments:
Responses (7)
  • Accepted Answer

    dzr
    dzr
    Offline
    Tuesday, April 21 2020, 08:44 AM - #Permalink
    0
    Hi,
    you can make a CronTask:
    Delete Stats < nbr months



    Andrey Nesterov wrote:

    So:

    1) xxxx_muscol_statistics can I delete without any problems? Or is the data in this table used on site pages?

    2) If I clear xxxx_content_statistics, all statistics on the site will be reset to zero? Or will the total number of pageviews still be shown on the pages?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, March 26 2020, 10:33 AM - #Permalink
    0
    we will release a new version for J4, yes.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, March 26 2020, 10:27 AM - #Permalink
    0
    1. Since the last update, I only use content_statistics modules

    2. I understand

    Thank you for your help!

    P.S.: Will the MC and CS components be compatible with Joomla 4?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, March 26 2020, 10:07 AM - #Permalink
    0
    1. its only used for the very old modules mod_muscol_statisitics.

    2. yes they will be reset. you will loose all page views.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, March 26 2020, 10:05 AM - #Permalink
    0
    So:

    1) xxxx_muscol_statistics can I delete without any problems? Or is the data in this table used on site pages?

    2) If I clear xxxx_content_statistics, all statistics on the site will be reset to zero? Or will the total number of pageviews still be shown on the pages?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, March 26 2020, 09:54 AM - #Permalink
    0
    xxxx_muscol_statistics is deprecated

    xxxx_content_statistics stores info about album views, artist view, etc.

    if you're not interested in them, you can clear the db table :)
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, March 25 2020, 09:20 PM - #Permalink
    0
    Hello!

    Tell me what information is stored in the database tables - xxxx_content_statistics and xxxx_muscol_statistics? And is it possible to clear these tables without problems with the site?
    The reply is currently minimized Show
Your Reply