BuddyPress.org

Hello,

First of all here is my config:

Server vps ssd 8GB ram 3×3.7 ghz apache
Wordpress 4.8.1
Theme Responsive free 2.9

Plugins :
Wp rocket cache
Buddypress 2.9
Admin custom login
Advanced ads pro
Responsive menu pro
Ban Hammer
Bp profile search
Buddypress activity shortcode
Buddypress like
Wp foro
Google analytics dashboard
Iq block country
Newsletter
Plugin business directory
Redirection
Secupress
Social Plug
Strong testimonials
Table of content plus
Wordpress database backup
Wp asset cleanup
Wp excerpt generator
Wp testing
Yoast seo

Database SQL manage on phpmyadmin; modify :
max connection = 502
timeout = 69
table open cache = 71144
max heap table size = 3G
tmp table size = 3G
allowed pack 1 000 000
open files limit = 150 000
myisam_sort_buffer_size = 72M
read_rnd_buffer_size = 24M
join_buffer_size = 32M
query_prealloc_size = 65K
query_alloc_block_size = 128K
table_definition_cache = 71144
thread_stack = 512K
thread_concurrency = 28
read_buffer_size = 36M
query cache min res unit = 512
bulk insert buffer size = 72M
thread_cache_size = 16K
query_cache_limit = 512M
innodb_buffer_pool_size = 3G
query_cache_size= 512M
innodb_log_buffer_size = 32M
sort_buffer_size = 192M
innodb_read_io_threads = 12
innodb_write_io_threads = 12?
innodb_open_files = 1200

Members on my buddypress : 1300
monthly visitors : 100 000
monthly pages views : 200 000

For several months now, I have activities that disappear completely from my database !!! I checked all the plugins, in case there was a conflict, but everything is ok. So I changed the table type from my MYISAM database to INNODB, but that still has not solved the problem. Same, I have changed many times some sql varibals in phpmyadmin, but nothing works. I also tried the data recovery via the buddypress dashboard, but it does not help! Activities disappear when some members are very active. Bizarre ??? !! So, if people have the solution to my problem, thank you for telling me what to change. Thank you !