15K tables on DataBase

Resolved

(@tractor1st)

Hello, I have a problem? Bug? Error?
I have 20000 tables with content like:

_transient_aiowps_captcha_string_info_q6qiyut080
_transient_timeout_aiowps_captcha_string_info_r2srepvcg6

Example screen of DB
screen1

And I do not know what to do with whis, but I am sure it is very long ago. And not only I can have this problem, because i have usuall settings on my site
Can i delete this tables?
What makes them?
How to fix this in the future?

I found what Youst SEO have this problem too
link to GitHub

If I hadn’t been able to customize the ‘multisite’, I would not have found it. artifacts crawled right in the site settings in the console. I backup site after that found
Thank you

Plugin Version : 4.3.7.2
WP Version : 4.9.8
WPMU: No
MySQL Version : 5.6.39
WP Table Prefix : f_
PHP Version : 7.0.30
Session Save Path : 
WP URL: https://xn--80aaldj1b7b.xn--p1ai
Server Name : xn--80aaldj1b7b.xn--p1ai
Cookie Domain : xn--80aaldj1b7b.xn--p1ai
CURL Library Present : Yes
Debug File Write Permissions : Writable
PHP Version : 7.0.30
PHP Memory Usage: 31.03 MB 
PHP Memory Limit : 256M
PHP Max Upload Size : 256M
PHP Max Post Size : 256M
PHP Allow URL fopen : On 
PHP Allow URL Include : Off
PHP Display Errors : On 
PHP Max Script Execution Time : 30 Seconds
Name	Version	Plugin URL
WPGrabber	3.2 (17.08.2016)	
Admin Bar Disabler	1.4	https://www.scottkclark.com/
All In One WP Security	4.3.7.2	https://www.tipsandtricks-hq.com/wordpress-security-and-firewall-plugin
Auto Post Thumbnail PRO	1.6.1	http://codecanyon.net/item/auto-post-thumbnail-pro/4322624
Duplicator	1.2.52	https://snapcreek.com/duplicator/duplicator-free/
Jetpack by WordPress.com	6.6.1	https://jetpack.com
WPBakery Page Builder	5.5.4	http://wpbakery.com
Maintenance	3.6.1	http://wordpress.org/plugins/maintenance/
Simple Sitemap	2.6	http://wordpress.org/plugins/simple-sitemap/
tagDiv Composer	2.3 | built on 27.06.2018 14:16	http://tagdiv.com
tagDiv Social Counter	4.4 | built on 27.06.2018 14:16	http://tagdiv.com
TinyMCE Advanced	4.8.0	http://www.laptoptips.ca/projects/tinymce-advanced/
TotalPoll Pro	3.3.2	http://totalpoll.com
uLogin - виджет авторизации через социальные сети	2.9.0	http://ulogin.ru/
UpToLike Social Share Buttons	1.5.9	https://uptolike.com/
WordPress Importer	0.6.4	https://wordpress.org/plugins/wordpress-importer/
Yoast SEO Premium	8.3	https://yoa.st/2jc
WP-Recall	16.16.0	http://codeseller.ru/?p=69
WP Super Cache	1.6.4	https://wordpress.org/plugins/wp-super-cache/
WP Translitera	p1.2.5	http://yur4enko.com/category/moi-proekty/wp-translitera
wpDiscuz	5.2.2	http://wpdiscuz.com/

This topic was modified 7 years, 6 months ago by stephencottontail. Reason: fix HTML

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Contributor mbrsolution
(@mbrsolution)

7 years, 6 months ago

Hi, AIOWPS plugin has a code which will automatically clean up the old transient entries created by captcha feature. The code is triggered once daily via a wp cron event. You can try a simple test if you wish to confirm whether the cleanup code is working or not. Deactivate and reactivate the plugin, then check to see if your transients have cleared?

Let me know how you go.

Regards

Thread Starter tractor1st
(@tractor1st)

7 years, 6 months ago

Hi, I deactivated and then activated plugin, but its not help
How was be ~15,815 and so this remained

Maybe, shoud wait 1-2 days? After that
Or you have some SQL script for delite bad tables?
Thank you

Plugin Contributor wpsolutions
(@wpsolutions)

7 years, 6 months ago

Hi,
You should check to see if the aiowp wp cron task is actually running on your system.
The checking and cleanup of the transients will be performed using the hourly wp cron event called “aiowps_hourly_cron_event“.

Also you should check your server error logs just in case there are MySQL or PHP errors related to this functionality on your site.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘15K tables on DataBase’ is closed to new replies.

Tags