Database growing

  • Hi!

    If I make a backup from my webpage the database grows up very fast and it′s not possible to make a backup: If I look to my MYSQL Tables there are two tables which grows up: Table tin0_actionscheduler_actions grows to 2.1 GB and tin0_actionscheduler_logs grows to 800 MB! Is a plugin a reason for this or is this a hack. How can I delete the content of the tables? Or which possibilities are available. Set back to the last valid backup. Then Isolate all plugins and then make a backup and have a look what happens?

    Or is this possible from a Mail Client Plugin WP Mail SMTP or WPForms Lite?

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

  • Hi @kaschwei
    This should be due to a cron event that keeps on running.
    I recommend you install wp control plugin.
    Then go to tools -> Cron Events menu to manage cron events.
    From there, you would have a view on what is causing tin0_actionscheduler_actions to grow without limit.

    Regards.

    Moderator Yui

    (@fierevere)

    永子

    You can TRUNCATE actionscheduler_logs table
    i.e. using PHPMyAdmin, it will set its site close to zero, it should not break anything.

    Thread Starter kaschwei

    (@kaschwei)

    Sorry I have no Idea about cron Events. I know that normally you can set something in the backend of your provider. But which command should be set there. That The maximum of lines in the table of the tin0_actionscheduler_actions will not grow?

    Other Advice to install wp control plugin is good, but I′m afraid to handle wrong.

    You didn’t mention your domain or anything about your web host! That’s okay but I can’t take a look at things that way to try to help. I do understand you might not want anyone to know though.

    So, how about if you make a database backup from your web host?

    If you can’t backup the database from your web host then you’ll need some solution (like a hosting account upgrade) to get to where you can do the backup. If your host can’t handle backing up the database in the space you have available then nothing within WordPress can help.

    If your webhost can’t help you then you might consider finding a freelancer dev to help you from some site such as https://jobs.wordpress.net/

    —
    Some web hosts limit database size to 1 gb. but then offer multiple databases. That may be an option for you to span multiple databases but you’ll probably need professional help with that if needed.

    Thread Starter kaschwei

    (@kaschwei)

    Thank you for the answers! I think the tin0_actionscheduler_actions and tin0_actionscheduler_logs grows up every month always when I make a backup of the page!
    The last valid backup was 90 MB from the Backup and now i restore and I get 700MB Database Store. So the backup-Tool maybe produces this lot of entries or something else.
    The website is a small webpage one pager and build with Divi. It is hosted by STRATO and I can give following informations:

    ### wp-core ###

version: 5.5.3
site_language: de_DE
user_language: de_DE
timezone: +00:00
permalink: /%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: open
environment_type: production
user_count: 3
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /mnt/web312/d2/12/51485012/htdocs/STRATO-apps/wordpress_01/app
wordpress_size: 129,73 MB (136036170 bytes)
uploads_path: /mnt/web312/d2/12/51485012/htdocs/STRATO-apps/wordpress_01/app/wp-content/uploads
uploads_size: 586,88 MB (615384724 bytes)
themes_path: /mnt/web312/d2/12/51485012/htdocs/STRATO-apps/wordpress_01/app/wp-content/themes
themes_size: 38,55 MB (40424639 bytes)
plugins_path: /mnt/web312/d2/12/51485012/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins
plugins_size: 112,36 MB (117813840 bytes)
database_size: 802,14 MB (841105408 bytes)
total_size: 1,63 GB (1750764781 bytes)

### wp-active-theme ###

name: Divi Child Theme (Divi-Child-Theme)
version: 1.0.0
author: Divi.world
author_website: https://divi.world
parent_theme: Divi (Divi)
theme_features: core-block-patterns, custom-background, automatic-feed-links, post-thumbnails, menus, title-tag, post-formats, woocommerce, wc-product-gallery-zoom, wc-product-gallery-lightbox, wc-product-gallery-slider, customize-selective-refresh-widgets, editor-style, widgets
theme_path: /mnt/web312/d2/12/51485012/htdocs/STRATO-apps/wordpress_01/app/wp-content/themes/Divi-Child-Theme

### wp-parent-theme ###

name: Divi (Divi)
version: 4.5.1
author: Elegant Themes
author_website: https://www.elegantthemes.com
theme_path: /mnt/web312/d2/12/51485012/htdocs/STRATO-apps/wordpress_01/app/wp-content/themes/Divi

### wp-themes-inactive (3) ###

Twenty Nineteen: version: 1.7, author: WordPress-Team (latest version: 2.0)
Twenty Seventeen: version: 2.4, author: WordPress-Team (latest version: 2.6)
Twenty Twenty: version: 1.5, author: WordPress-Team (latest version: 1.7)

### wp-mu-plugins (1) ###

installatron_hide_status_test.php: author: (undefined), version: (undefined)

### wp-plugins-active (11) ###

Akismet Anti-Spam: version: 4.1.7, author: Automattic (latest version: 4.1.9)
BackupGuard Pro: version: 1.6.0, author: BackupGuard
Complianz | GDPR/CCPA Cookie Consent: version: 4.7.7, author: Really Simple Plugins (latest version: 4.9.10)
Maintenance Mode Pro - WPOS: version: 1.1, author: WP OnlineSupport
Really Simple SSL: version: 3.3.5, author: Really Simple Plugins (latest version: 4.0.11)
WP Cerber Security, Anti-spam & Malware Scan: version: 8.6.8, author: Cerber Tech Inc. (latest version: 8.8.3)
WPForms Lite: version: 1.6.3.1, author: WPForms (latest version: 1.6.5)
WP Mail SMTP: version: 2.5.1, author: WPForms (latest version: 2.6.0)
YellowPencil Pro: version: 7.3.1, author: WaspThemes
Yoast Duplicate Post: version: 3.2.6, author: Enrico Battocchi & Team Yoast
Yoast SEO: version: 15.3, author: Team Yoast (latest version: 15.9.2)

### wp-plugins-inactive (6) ###

Advanced Database Cleaner: version: 3.0.3, author: Younes JFR.
Hello Dolly: version: 1.7.2, author: Matt Mullenweg
Limit Login Attempts Reloaded: version: 2.15.2, author: WPChef (latest version: 2.20.3)
Rank Math SEO: version: 1.0.52.2, author: Rank Math (latest version: 1.0.59)
Strato Assistant: version: 5.7.0, author: Strato
Wordfence Security: version: 7.4.14, author: Wordfence

### wp-media ###

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1691
imagemagick_version: ImageMagick 6.9.11-39 Q16 x86_64 2020-12-01 https://imagemagick.org
file_uploads: File uploads is turned off
post_max_size: 76M
upload_max_filesize: 64M
max_effective_size: 64 MB
max_file_uploads: 20
imagick_limits: 
	imagick::RESOURCETYPE_AREA: 4 GB
	imagick::RESOURCETYPE_DISK: 9.2233720368548E+18
	imagick::RESOURCETYPE_FILE: 192
	imagick::RESOURCETYPE_MAP: 4 GB
	imagick::RESOURCETYPE_MEMORY: 2 GB
	imagick::RESOURCETYPE_THREAD: 1
gd_version: bundled (2.1.0 compatible)
ghostscript_version: not available

### wp-server ###

server_architecture: Linux localhost 3.10.0-1127.10.1.el7.x86_64 #1 SMP Linux localhost 3.10.0-1127.10.1.el7.x86_64 #1 SMP Linux localhost 3.10.0-1127.10.1.el7.x86_64 #1 SMP
httpd_software: Apache/2.4.46 (Unix)
php_version: 7.4.15 64bit
php_sapi: cgi-fcgi
max_input_variables: 4000
time_limit: 0
memory_limit: 512M
max_input_time: 60
upload_max_filesize: 64M
php_post_max_size: 76M
curl_version: 7.73.0 OpenSSL/1.0.2u
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: false

### wp-database ###

extension: mysqli
server_version: 5.6.42-log
client_version: 5.6.45

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /mnt/web312/d2/12/51485012/htdocs/STRATO-apps/wordpress_01/app/wp-content
WP_PLUGIN_DIR: /mnt/web312/d2/12/51485012/htdocs/STRATO-apps/wordpress_01/app/wp-content/plugins
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_LOCAL_DEV: undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

### wpforms ###

version: 1.6.3.1
lite: Jul 28, 2020 @ 12:33pm
upload_dir: Writable
db_tables: tin0_wpforms_tasks_meta
total_forms: 1
total_submissions: 2

### wp_mail_smtp ###

version: 2.5.1
license_key_type: lite
debug: Keine Debug-Hinweise gefunden.
db_tables: tin0_wpmailsmtp_tasks_meta
lite_install_date: Nov 10, 2020 @ 8:09am

    Hi @kaschwei

    From your reply, I can see you have many plugins installed. I believe there is one or many that is the cause of your database growing so quickly.

    I still suggest you install wp-cron and view all the events being scheduled in background

    Other Advice to install wp control plugin is good, but I′m afraid to handle wrong.

    You don’t need to be afraid is a straight forward process. and by the way if you have encounter any problem, we are here to help you

    • This reply was modified 3 years, 11 months ago by Randolph GAMO.
    Thread Starter kaschwei

    (@kaschwei)

    Thanks a lot! I went to MYSQL and there are a lot of entries about WPFORMS
    https://test1.h20470.server14.configcenter.info/database-entry.jpg

    So maybe this can be the reason?

    https://wpforms.com/docs/how-to-troubleshoot-action-scheduler-issues-in-wpforms/

    So you think with this procedure it works?

    Thread Starter kaschwei

    (@kaschwei)

    What′s the normally database Size of a small webpage, without problems?

    https://wpforms.com/docs/how-to-troubleshoot-action-scheduler-issues-in-wpforms/
    So you think with this procedure it works?

    I had a quick look on the link. Yes, I think it provides a solution.
    On a simpler note, I would suggest you just deactivate the plugin, delete it and reinstall it back

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Database growing’ is closed to new replies.