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

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;

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.

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.

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

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.

• This reply was modified 3 years, 10 months ago by Zed Game.

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

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 3 years, 9 months ago by Zed Game.

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