How to Purge or Truncate the IQ Block “debug_logging” table

  • Resolved SunnyOz

    (@sunnyoz)


    1 year, 11 months ago

    I am on a cPanel hosting package and use phpMyAdmin to maintain my WordPress Database for my client’s website. They have the IQ Block Country plugin installed, and has been running for quite a while now. (Plugin Version 1.2.19 – with MySQL Database Version: 10.2.44-MariaDB-cll-lve and PHP Version: 7.4.33.)

    Can someone tell me how to purge/truncate the contents of the iqblock_debug_logging table <span style=”text-decoration: underline;”>without corrupting the rest of the Database</span>??

    This table currently has over 800,000 rows and is taking up 128MB of space.

    If I am viewing the iqblock_debug_logging table via phpMyAdmin, and click on the ‘Operations’ tab (from the top menu area), there is an option at the bottom of the page to either ‘Empty the table (TRUNCATE)’ or ‘Delete the table (DROP)’. Are either of these options what I should be doing?

    Alternately, the only other thing I can think of to do, is to backup the current settings, then uninstall the IQ Block Country WP Plugin, then reinstall, and then re-import the old settings.

    Or is there some easier/better way to clear the space being used, so that my Database is not so big – without corrupting the Database!

    AND – is there a way to turn off the debug logging so it doesn’t continue to grow?

    Thanks,

    SunnyOz

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Pascal

    (@iqpascal)

    You can truncate the table from phpMyAdmin yes that deletes all rows. Drop just drops the entire database and will lead to issues.

    You really should disable debug logging as there is no use for it unless you’re debugging an error.

    Thread Starter SunnyOz

    (@sunnyoz)

    Thanks for your quick reply!

    Are you saying there is no issue with truncating the iqblock_debug_logging table without any consequences to the website or the IQ Block Country plugin?

    Oh, wow… I just found the debug option on the home page of the IQ Block settings area. I have unticked it, so hopefully that does stop the on-going logging issue!

    Plugin Author Pascal

    (@iqpascal)

    There is no issue in truncating that table no and if you unticked it it should not fill up that table anymore ??

    Thread Starter SunnyOz

    (@sunnyoz)

    FYI: Just for documentation sake (in case someone else comes here because they have the same problem):

    Once I unticked the “Log all visits” setting, the plugin automatically dropped the Database “iqblock_debug_logging” table for me. (IE: Once I logged back in to phpMyAdmin, that table was no longer there, and I had regained all the space back, and my DB size was now only 9MB).

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How to Purge or Truncate the IQ Block “debug_logging” table’ is closed to new replies.