27.1] cleanup table wp_wfConfig manually

Task name

Project

Reassign this task? Sasha Listopad

Priority Low Normal High Urgent

Start date Clear

Due Date Clear

Status Complete Incomplete In progress On hold

This task is currently blocked by 27.1] cleanup table wp_wfConfig manually. Change its status and unblock anyway?

Yes No

This task

Elaboration

Log time Clear

1 min incs

Job number

Additional information

Support tickets: 
Subject: Database Size Warning
Dear Customer,
We are contacting you with regard to a database on your account called (cl60-a-wordp-jby) attached to
the hosting package (murashdom.com). Your database is currently 1012.6MB in size,
which exceeds the permitted limit of 500MB. We'd like to help you try and reduce the
size of your database, bringing it back under our permitted limit. It is quite likely that a single
table within your database is causing the problem, and all that will be necessary is to reduce the
size of it. This is especially likely if you're running a forum, they can quickly become very large
in size if they have been subjected to automated spam. Very large databases do negatively impact
server performance, if we do not hear back from you then we may need to disable yours. If the
database remains too large and no action is taken after it has been disabled, then the database may
be deleted.
Best Wishes
Heart Internet Support
--------------------
us: 
Hello. Could you please tell me what table is causing it. You've mentioned it could be one table. Could you please help me identify that table. This is an e-commerce site of our customer, please do not disconnect the site, we are willing to work with you and customer to reduce the table. Thank you in advance. 
-------------------------
Thanks for contacting us.

Here is the table in your database taking up the most space :

wp_wfConfig 0.87G

========to do: ========
1] run this query on your database to see how many rows it has stored?

SELECT COUNT(*) FROM wp_wfconfig;

It should be around 200-300.
actual rows:

—–
 2] try these steps to reduce the size of the tables?

If you want to keep your settings:

1. Go to Wordfence -> Tools -> Import/Export Options
2. Click on Export Wordfence Options
3. Copy the Key

3] clean up Wordfence database tables:

4. Go to Wordfence -> All Options
5. Check Delete Wordfence tables and data on deactivation
6. Click Save Changes in the top right corner
7. Deactivate, then reinstall Wordfence

4] run this query on your database again to see how many rows it has stored?

SELECT COUNT(*) FROM wp_wfconfig;

actual rows:

Task Details Instigator Sasha Listopad

Project: Ускорение murashdom.com
Job number: -
Priority: urgent
Added: 7th April 2019
Start date: 7th April 2019
Due Date: 8th April 2019
ID: 1487

Status: Complete
Time spent: -
Attachments: -
Visibility: Public
Owner: Sasha Listopad

Additional Info

Support tickets: 
Subject: Database Size Warning
Dear Customer,
We are contacting you with regard to a database on your account called (cl60-a-wordp-jby) attached to
the hosting package (murashdom.com). Your database is currently 1012.6MB in size,
which exceeds the permitted limit of 500MB. We'd like to help you try and reduce the
size of your database, bringing it back under our permitted limit. It is quite likely that a single
table within your database is causing the problem, and all that will be necessary is to reduce the
size of it. This is especially likely if you're running a forum, they can quickly become very large
in size if they have been subjected to automated spam. Very large databases do negatively impact
server performance, if we do not hear back from you then we may need to disable yours. If the
database remains too large and no action is taken after it has been disabled, then the database may
be deleted.
Best Wishes
Heart Internet Support
--------------------
us: 
Hello. Could you please tell me what table is causing it. You've mentioned it could be one table. Could you please help me identify that table. This is an e-commerce site of our customer, please do not disconnect the site, we are willing to work with you and customer to reduce the table. Thank you in advance. 
-------------------------
Thanks for contacting us.

Here is the table in your database taking up the most space :

wp_wfConfig 0.87G

========to do: ========
1] run this query on your database to see how many rows it has stored?

SELECT COUNT(*) FROM wp_wfconfig;

It should be around 200-300.
actual rows: 

—–
 2] try these steps to reduce the size of the tables?

If you want to keep your settings:

1. Go to Wordfence -> Tools -> Import/Export Options
2. Click on Export Wordfence Options
3. Copy the Key

3] clean up Wordfence database tables:

4. Go to Wordfence -> All Options
5. Check Delete Wordfence tables and data on deactivation
6. Click Save Changes in the top right corner
7. Deactivate, then reinstall Wordfence

4] run this query on your database again to see how many rows it has stored?

SELECT COUNT(*) FROM wp_wfconfig;

actual rows:

Comments

Sasha Listopad
7th April 2019 at 4:27 pm
done all the steps, flashed the tables and data Database size 111 MB.
After WF installation database 112 MB
importted WF old settings
activated Wordfence autoupdater
optimized firewall
After all database 112 MB
Sent report to provider
Log in to Reply
Sasha Listopad
7th April 2019 at 3:56 pm
done 1] run this query on your database to see how many rows it has stored?

SELECT COUNT(*) FROM wp_wfconfig; actual rows: 284
Log in to Reply

Projects 41

27.1] cleanup table wp_wfConfig manually

Task Details Instigator Sasha Listopad

Additional Info

Comments