wordpress迁移后打开很慢

回复收藏

wordpress 排障经验

迁移步骤不用多说，简单地远程拷贝。但是mysql数据并不是备份的sql，而是直接拷贝的库下的myi,myd,frm文件。

服务都搭建好了，没有任何问题，测试页面正常打开。唯独访问死活打不开，没有任何报错。

打开php-fpm的慢查询日志，量并不大，但基本上都一致

script_filename = /data/virtualhost/imiker/blog/index.php
[0x00007f4ddc6e9ec8] mysql_query() /data/blog/wp-includes/wp-db.php:1095
[0x00007f4ddc6e9410] query() /data/blog/wp-includes/wp-db.php:1422
[0x00007f4ddc6e8dc8] get_results() /data/blog/wp-includes/option.php:145
[0x00007f4ddc6e87b8] wp_load_alloptions() /data/blog/wp-includes/functions.php:1092
[0x00007f4ddc6e8018] is_blog_installed() /data/blog/wp-includes/load.php:429
[0x00007f4ddc6e7aa0] wp_not_installed() /data/blog/wp-settings.php:106

挨个去看这些文件，并看不出啥大问题，那只好去查看mysql的processlist:

mysql -uroot -pxxxxxxxx -e "show processlist"
发现了下面的结果：

接着又看mysql的error_log:
tail /var/log/mysql/error.log
2015-07-23 15:49:43 929 [Warning] Checking table: './blog/wp_options'
2015-07-23 15:49:43 929 [Warning] Checking table: './blog/wp_options'
2015-07-23 15:49:43 929 [Warning] Checking table: './blog/wp_options'
2015-07-23 15:49:43 929 [Warning] Checking table: './blog/wp_options'
2015-07-23 15:49:43 929 [Warning] Checking table: './blog/wp_options'
2015-07-23 15:49:43 929 [Warning] Checking table: './blog/wp_options'
2015-07-23 15:49:43 929 [Warning] Checking table: './blog/wp_options'

第一反应是，修复该表：

mysql -uroot -pxxxxxxx  -e "use blog; repair table wp_options;"Warning: Using a password on the command line interface can be insecure.
+------------------+--------+----------+---------------------------------+
| Table          | Op    | Msg_type | Msg_text                      |
+------------------+--------+----------+---------------------------------+
| mrhua.wp_options | repair | Error | Table 'wp_options' is read only |
| mrhua.wp_options | repair | status | Operation failed             |
+------------------+--------+----------+---------------------------------+

得，原来是这个表只读。看权限吧：