Big Database File

  • Resolved poweromania

    (@poweromania)


    4 months, 1 week ago

    I have this file created by the plugin “wpftsi_qlog.ibd” that is 40GB is size the problem is that is getting bigger and bigger and soon i will run out of space on my vps. How can i reduce that file size? Also, since it has log in its name is it safe to delete it since i assume is a log file?

    • This topic was modified 4 months, 1 week ago by poweromania.
Viewing 1 replies (of 1 total)
  • Plugin Author Epsiloncool

    (@epsiloncool)

    Hi @poweromania

    Yes, this was a known issue for websites with big number of requests. The reason is: your Query Log grows fast. It’s good.

    Here is how you can fix that:

    1. Install latest WPFTS free plugin
    2. Navigate to WPFTS Settings / Analytics / Query Log / Settings
    3. Ensure you removed both two RED checkboxes (3rd and 4th from top)
    4. Check the value in the input “Max Log Size”, I would propose you to set it up to 100000 or 10000.
    5. Save changes.

    After that your qlog table should be much smaller.

    Let me know in case it does not work.

    Thanks!

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