Slow site caused by Jdownloads logs - [Solved!!!]

[Relinquish]

Hi,

My Joomla site is running very slow / going down, and I couldn't find the solution so I had the server host admin take a look.

mysql is creating a lot of temp tables on disk. You'll need to see if you can optimize queries / cache some results.

Here's a lot of the problem.

| 10720615 | database_joomla | localhost | database_joomla | Query | 5 | Copying to tmp table | SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
FROM joomla_jdownloads_l |
| 10720627 | database_joomla | localhost | database_joomla | Query | 3 | Copying to tmp table | SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
FROM joomla_jdownloads_l |
| 10720636 | database_joomla | localhost | database_joomla | Query | 2 | Copying to tmp table | SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
FROM joomla_jdownloads_l |
| 10720637 | database_joomla | localhost | database_joomla | Query | 2 | Copying to tmp table | SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
FROM joomla_jdownloads_l |
| 10720669 | database_joomla | localhost | database_joomla | Sleep | 3 | | |
| 10720678 | database_joomla | localhost | database_joomla | Query | 5 | Copying to tmp table | SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
FROM joomla_jdownloads_l |
| 10720682 | database_joomla | localhost | database_joomla | Query | 5 | Copying to tmp table | SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
FROM joomla_jdownloads_l |
| 10720685 | database_joomla | localhost | database_joomla | Query | 4 | Sending data | SELECT COUNT(*)
FROM joomla_jdownloads_logs

This mysql query in particular:
SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize

Are the logs necessary, can they be disabled?

I know you can "reduce the number of logged data sets", but will that break the site somehow?

Is there some other solution? I never had this problem with Jdownloads 1.9, I'm guessing it's new to 3.2?

Thanks.

[Arno]

Hi,
i am not sure what exactly is possible here.
Is your site in backend or frontend slow?
How many datasets exist in your DB logs table?

When your logs db table is very large you can reduce the data via a special option in the jD System Plugin.

Are the logs necessary, can they be disabled?

The logs can not be complete deactivated when you use user 'restrictions' in the jD 'User Group Settings'.
So when you will not use it you can deactivate the logs in jD configuration.

[Relinquish]

Hi,

The entire site was slow. I'm not sure how many data sets there were because they are all gone now, but it was a lot.

I've been upgraded to 3.2 for a while now and didn't have any problems, so maybe the logs just got too much because there was no limit?

The only thing I use "User Group Settings" for is to allow the Public group to create downloads on the frontend.

I've set it to "1" and don't see any problems now.

[Arno]

Okay, so your problem is solved.

[Relinquish]

Well it is back to being slow again.

How can I disable the logs completely? Setting it to 0 removes the limit..

Anyone with a high traffic site is going to have issues because of it.

[ColinM]

Hi
You can disable logs totally in Config - Downloads tab in field "Activate log function for Downloads?" and setting.  Note that this might compromise the limits in User Groups settings.

Colin

[Relinquish]

Hi Colin,

Thank you, I didn't see that option.

I only use the User Group settings to allow the public group to upload files. Will this affect that?

[ColinM]

Hi
No it will not affect that at all.  The log s are needed to effect the limits such as number of downloads per day and so on
Colin