How to turn off download history? Too many requests to MySQL database.

Viewing 12 posts - 1 through 12 (of 12 total)
#172068

Zed Game
Participant

Hello, the plugin generates a lot of requests to the MySQL database.

How can I turn off download history to stop recording data to MySQL?

Example of requests provided by hosting company. *username, hostname, and IP addresses are changed*

# Time: 2022-05-07T13:00:29.716446Z
# User@Host: USERDATABASE[HOSTDATABASE] @ localhost [] Id: 7705538
# Query_time: 4.699025 Lock_time: 3.059777 Rows_sent: 0 Rows_examined: 1386816
SET timestamp=1651928425;
UPDATE wpj4_ahm_user_download_counts SET download_count = ‘2’ WHERE user = ‘111.111.111.111’ AND package_id = ‘1111’;
# Time: 2022-05-07T13:01:12.950018Z
# User@Host: USERDATABASE[HOSTDATABASE] @ localhost [] Id: 7705788
# Query_time: 5.302771 Lock_time: 5.302570 Rows_sent: 0 Rows_examined: 0
SET timestamp=1651928467;
INSERT INTO wpj4_ahm_user_download_counts (download_count, user, package_id) VALUES (‘1’, ‘111.111.111.111’, ‘1111’);
# Time: 2022-05-07T13:01:14.574439Z
# User@Host: USERDATABASE[HOSTDATABASE] @ localhost [] Id: 7705797
# Query_time: 3.892360 Lock_time: 2.267900 Rows_sent: 0 Rows_examined: 1386819
SET timestamp=1651928470;

#172071

Nayeem Riddhi
Moderator

Hello Zed Game,

Hope you are well. And sorry for the inconvenience. Have you checked these options too from your settings section as I image attached,

privacy

please check and let me know

Thank you and regards

#172072

Zed Game
Participant

Hello Nayeem Riddhi. I already checked that a long time ago. It helped with cache files, but now it’s about MySQL database. Even if I will delete all stats that will not stop updating the database with new records.

#172073

Zed Game
Participant

Also, I updated wp-config.php and added this – define(‘WPDM_ACCEPT_COOKIE’, false); Problem is not about cache. Download history records to the database should be disabled, but I can’t find a way to do this.

#172074

Zed Game
Participant

There should be something similar to this (WPDM_DOWNLOAD_HISTORY’, false) or (WPDM_HISTORY_RECORD’, false). Code that will block history record…

#172098

Nayeem Riddhi
Moderator

Hello Zed Game,

Sorry for the inconvenience. Have you placed Temporary Storage management in Save in File option, please check my the above attached image. please let me know

Thank you and regards

#172113

Zed Game
Participant

Hello, thank you for trying to help me. It is checked as Save in File. But I see one difference between my and your screen it is the position of buttons, but I don’t think it a reason for that problem. The version of my plugin is 3.2.41 Here is a screenshot of all settings. Settings

  • This reply was modified 2 years, 11 months ago by Zed Game.
#174305

Zed Game
Participant

Hello again. My problem is not solved. Can you tell me how can I turn off the “History and Stats”?

#174313

Nayeem Riddhi
Moderator

Hello Zed Game,

Sorry for the inconvenience. Has the problem persists for Too many requests to MySQL database issue still now, please let me know

Thank you and regards

#174392

Zed Game
Participant

The hosting provider is monitoring the activity of the WPDM plugin and will share results with me in a few days.

  • This reply was modified 2 years, 10 months ago by Zed Game.
#174393

Nayeem Riddhi
Moderator

Hello Zed Game,

Please elaborate on the results so that I can give you a solution or can forward the issue to our related authority. please let me know

Thank you and regards

#174397

Zed Game
Participant

I will update this post as soon as the hosting provider will share their result with me.

Viewing 12 posts - 1 through 12 (of 12 total)

The topic ‘How to turn off download history? Too many requests to MySQL database.’ is closed to new replies.