• Resolved aine89

    (@aine89)


    Hi,

    I’ve installed Wordfence on my website, but I’m facing a serious issue — it’s rapidly draining my website’s storage every second.

    When I checked the error logs, I found the following message:

    WordPress database error: Can’t find file: ‘./dbname/wp_csri_wfHits.MYI’ (errno: 2 “No such file or directory”)
    for query: SELECT MAX(attackLogTime) FROM wp_csri_wfHits
    made by: require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’),
    require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action,
    WP_Hook->apply_filters, wordfence::veryFirstAction

    Could you please help me resolve this issue?

    Thanks in advance.

Viewing 1 replies (of 1 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @aine89,

    A missing “.MYI” file in a MySQL database table means that the index for the table is missing, which can cause performance issues and potentially prevent certain queries from working correctly.

    If just the wfHits table itself is affected, you could try repairing the table in phpmyadmin (or however you usually administer your database). If you’re also having more general performance issues with the WordPress tables unrelated to Wordfence, you may need to speak with your host to see if there’s a bigger issue with your database.

    Many thanks,
    Peter.

Viewing 1 replies (of 1 total)

The topic ‘Wordfence Causing Storage Drain and Database Error’ is closed to new replies.