Website crash on 20GB database
-
Hello. I tried running the default “Run all selected optimizations” mode. The database was 20GB at the time. Unfortunately it appeared to crash somewhere as I left it running overnight. The icon kept spinning but the website was no longer accessible. It kept giving a database connection error. Tech support had to reboot the VPS. Afterwards, the database grew to 30gb and they thought the DB was corrupted but eventually somehow got it working again.
Does this plugin have problems with large databases?
Thanks
Viewing 4 replies - 1 through 4 (of 4 total)
-
@veedot2 `
Please could you ask your hosts/server admin to check the PHP Maximum Execution Time limit?
If possible, please could they increase this limit to at least 900 seconds?Then try to run the database optimizations and check if it works?
Hello. I increased the execution time limit to 3600 seconds. I then ran the DB optimization and it seemed to work but the database went from 31GB to 36GB! Isn’t it supposed to go the other way?
When it completed, it said: “Optimization complete (with warnings – open the browser console for more details)”, and this is what was in the console:
The request to optimize the table wp_options timed out after 120 seconds error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1Are images being somehow stored in the database? Could that be inflating this DB so much? If so, is there a way to detach the pictures out of the DB? I heard that WP stores pictures in DBs in some conditions, which I think it ludicrous.
EDIT: here are the largest tables:
wp_options 802,066 22.30 GB 80.70 MB InnoDB 2.44 GB
wp_posts 14,339 83.53 MB 5.92 MB InnoDB 7.00 MB-
This reply was modified 3 years ago by
veedot2. Reason: added table sizes
Edit 2: I ran DB optimize again and console gave all these errors: There were 3 errors, below, separated by spaces. DB has overall grown from 20GB to 36GB by running this plugin.
jquery.min.js?ver=3.6.0:2 POST https://mymedicalfreedom.org/wp-admin/admin-ajax.php?_fs_blog_admin=true 500 (Internal Server Error) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 S.<computed> @ jquery.min.js?ver=3.6.0:2 blcDoWork @ admin.php?page=WP-Optimize:2476 setInterval (async) (anonymous) @ admin.php?page=WP-Optimize:2488 (anonymous) @ admin.php?page=WP-Optimize:2490 jquery.min.js?ver=3.6.0:2 POST https://mymedicalfreedom.org/wp-admin/admin-ajax.php?_fs_blog_admin=true 500 (Internal Server Error) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 wpoadmin-3-1-12.min.js?ver=3.1.12:1 There was an error when running the optimization "optimizetables". error {readyState: 4, getResponseHeader: ?, getAllResponseHeaders: ?, setRequestHeader: ?, overrideMimeType: ?,?…}abort: ? (e)always: ? ()catch: ? (e)complete: ? ()done: ? ()error: ? ()fail: ? ()getAllResponseHeaders: ? ()getResponseHeader: ? (e)overrideMimeType: ? (e)pipe: ? ()progress: ? ()promise: ? (e)readyState: 4responseText: "<!DOCTYPE HTML PUBLIC \"-//IETF//DTD HTML 2.0//EN\">\n<html><head>\n<title>500 Internal Server Error</title>\n</head><body>\n<h1>Internal Server Error</h1>\n<p>The server encountered an internal error or\nmisconfiguration and was unable to complete\nyour request.</p>\n<p>Please contact the server administrator at \n [email protected] to inform them of the time this error occurred,\n and the actions you performed just before this error.</p>\n<p>More information about this error may be available\nin the server error log.</p>\n<p>Additionally, a 500 Internal Server Error\nerror was encountered while trying to use an ErrorDocument to handle the request.</p>\n</body></html>\n"setRequestHeader: ? (e,t)state: ? ()status: 500statusCode: ? (e)statusText: "Internal Server Error"success: ? ()then: ? (t,n,r)Prototype: Object {optimization_id: 'optimizetables', optimization_table: 'wp_revslider_layer_animations', optimization_table_type: 'MyISAM', optimization_force: false}optimization_force: falseoptimization_id: "optimizetables"optimization_table: "wp_revslider_layer_animations"optimization_table_type: "MyISAM"Prototype: Object error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) error @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 abort @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 setTimeout (async) ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 load (async) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 wp_optimize.send_command @ send-command-3-1-12.min.js?ver=3.1.12:1 p @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 setTimeout (async) (anonymous) @ wpoadmin-3-1-12.min.js?ver=3.1.12:1 success @ send-command-3-1-12.min.js?ver=3.1.12:1 c @ jquery.min.js?ver=3.6.0:2 fireWith @ jquery.min.js?ver=3.6.0:2 l @ jquery.min.js?ver=3.6.0:2 (anonymous) @ jquery.min.js?ver=3.6.0:2 jquery.min.js?ver=3.6.0:2 POST https://mymedicalfreedom.org/wp-admin/admin-ajax.php?_fs_blog_admin=true 404 (Not Found) send @ jquery.min.js?ver=3.6.0:2 ajax @ jquery.min.js?ver=3.6.0:2 s.ajax.s.ajax @ jquery-migrate.min.js?ver=3.3.2:2 S.<computed> @ jquery.min.js?ver=3.6.0:2 blcDoWork @ admin.php?page=WP-Optimize:2476 setInterval (async) (anonymous) @ admin.php?page=WP-Optimize:2488 (anonymous) @ admin.php?page=WP-Optimize:2490FYI, I reduced the size of the database from 36GB down to 530MB by doing the SQL query:
OPTIMIZE TABLE x;
where x=the table nameI’m not sure why the plugin didn’t accomplish this same thing.
-
This reply was modified 3 years ago by
Viewing 4 replies - 1 through 4 (of 4 total)
- The topic ‘Website crash on 20GB database’ is closed to new replies.
