Warning: array_keys() expects parameter 1 to be array, null given in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 1925

Warning: Invalid argument supplied for foreach() in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 1925

Warning: Invalid argument supplied for foreach() in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 2290

Warning: implode(): Argument must be an array in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 3242

Warning: array_keys() expects parameter 1 to be array, null given in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 3265

Warning: Invalid argument supplied for foreach() in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 3265

Warning: Invalid argument supplied for foreach() in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 3306

Warning: array_keys() expects parameter 1 to be array, null given in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 3357

Warning: Invalid argument supplied for foreach() in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 3357

Warning: array_keys() expects parameter 1 to be array, null given in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 3502

Warning: Invalid argument supplied for foreach() in /www/wwwroot/help.cefhost.cn/wp-content/plugins/wp-synhighlight/geshi/geshi.php on line 3502

WordPress系统使用时间长了,数据库中的冗余数据就会很多,定期优化和清理Wordpress的数据库,可以保证Wordpress能够快速工作。

首先,停用一些无用的插件,将WordPress系统表之外的数据表都删除,只保留wp_posts, wp_comments, wp_terms, wp_term_relationships, wp_term_taxonomy 等系统数据表。

其次,打开phpMyadmin,通过SQL语句进行冗余数据删除操作。删除前记得先备份一下。

删除脚本是:

Source code    
DELETE FROM wp_posts WHERE post_type = 'revision';
DELETE FROM wp_postmeta WHERE meta_key = '_edit_lock';
DELETE FROM wp_postmeta WHERE meta_key = '_edit_last';

最后,在phpMyAdmin中,选中所有表,点“优化表”。

经过这一番优化操作,就可以将WordPress数据库中的冗余数据删除,优化了数据库的性能。

分享到: 更多

说点什么

avatar
  Subscribe  
提醒