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

    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
  • 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

    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, 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: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:33 AM - #Permalink
    0
    we will release a new version for J4, yes.
    The reply is currently minimized Show
  • 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
Your Reply