Skip to:
Content
Pages
Categories
Search
Top
Bottom

Activity that will disappear on my database

  • @mika69400

    Participant

    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 !

Viewing 4 replies - 1 through 4 (of 4 total)
  • @mika69400

    Participant

    I forget :

    I have 7 OOO activity …

    @mika69400

    Participant

    Nobody has any answers?

    @r-a-y

    Keymaster

    Do you see any debug error messages when you enable WP_DEBUG?
    https://codex.wordpress.org/Debugging_in_WordPress

    In wp-config.php, set WP_DEBUG to true, WP_DEBUG_DISPLAY to false to prevent error messages showing on your site, and WP_DEBUG_LOG to true so error messages are logged to wp-content/debug.log.

    Next, when the activities disappear, check the log and see what it says.

    Also, always strip down your install to see if there is a problem with plugins or your theme. For instance, your caching and DB plugins could affect this. Try disabling some plugins to see if the problem persists.

    @mika69400

    Participant

    Hello,

    Thank you for your help . I put the debug on, this is the only mistake I noticed today when I had activities that have disappeared :

    [31-Aug-2017 16:40:43 UTC] PHP Notice: is_404 was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in /var/www/clients/client1/web20/web/wp-includes/functions.php on line 4139

    Do you know if this can come from there? What to do ?

    Thank you …

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.