WP Tuner,从最底层来发掘是什么导致了你的站点速度过慢。
很多站点的作者觉得自己站点慢了又毫无头绪,至多加个Cache类的插件静态化页面。WP Tuner这款插件可以从根本上分析到底是什么拖慢了你的站点,插件的读入速度、插件相关的数据库读入速度、页面各部分的读入速度……从各方面给你一个详细的分析。
下面这些就是测出你访网站的访问速度如何.可以来分析你的网站那里出现了问题.这样可以更好的解决问题的所在.所以这个也可以算是管理员的必备软件.现在还有很多人没有使用到.所以我在这里说明一下.
WP Tuner
This plugin is only visible to site admins. (Update settings here; Visit MrPete at ICTA for bouquets/brickbats/help. Love it? Fill the Tip Jar.)
Analysed in 0.008 seconds.
Render Time: 0.181 sec (3.7% for queries). DB queries: 9, none defective, none > 0.500 sec. Memory: 2.2MB
Performance Analysis
Queries triggered by plugins calling Core functions are charged to: The Plugin
Yellow-highlighted rows indicate slow elements (more than 0.500 seconds)
Page Generation Performance (Order: Chronological)
| Index | Marker | %Time | %DB Time | %DB Count | Time | DB Time | DB Count | Memory | Output |
|---|---|---|---|---|---|---|---|---|---|
| (msec) | (msec) | (kb) | lev(bytes) | ||||||
| 0 | Start | 26 | 55 | 33 | 47.2 | 3.7 | 3 | ? | |
| 1 | plugins_loaded | 49 | 35 | 56 | 88.0 | 2.3 | 5 | 649.7 | 0() |
| 2 | widgets_init | 1 | 0 | 0 | 1.8 | 0.0 | 0 | 2,005.1 | 0() |
| 3 | init | 13 | 11 | 11 | 23.1 | 0.7 | 1 | 2,010.1 | 0() |
| 4 | admin_init | 3 | 0 | 0 | 6.3 | 0.0 | 0 | 2,213.4 | 1(0) |
| 5 | admin_head | 7 | 0 | 0 | 12.5 | 0.0 | 0 | 2,231.0 | 1(1656) |
| 6 | admin_notices | 1 | 0 | 0 | 2.4 | 0.0 | 0 | 2,238.4 | 1(5604) |
| 7 | admin_footer | 0 | 0 | 0 | 0.1 | 0.0 | 0 | 2,240.8 | 1(13860) |
| 8 | Stop | 2,241.3 | 1(13860) | ||||||
| Total | 100 | 100 | 100 | 181.5 | 6.8 | 9 |
Plugin / Theme SQL Query Performance (Order: DB Time)
| Code | Name | %DB Time | %DB Count | DB Time | DB Count |
|---|---|---|---|---|---|
| Category | (msec) | ||||
| -Core- | (Other) | 50 | 22 | 3.4 | 2 |
| -Core- | wp-settings.php | 18 | 22 | 1.2 | 2 |
| -Core- | widgets | 17 | 33 | 1.1 | 3 |
| -Core- | wp-admin | 11 | 11 | 0.7 | 1 |
| -Core- | (DB Constructor/Startup) | 4 | 11 | 0.3 | 1 |
| Total | 100 | 100 | 6.8 | 9 |
SQL Table Performance (Order: DB Time)
| Table | %DB Time | %DB Count | DB Time | DB Count |
|---|---|---|---|---|
| (msec) | ||||
| wp_options | 67 | 56 | 4.6 | 5 |
| wp_users | 12 | 11 | 0.8 | 1 |
| wp_comments | 11 | 11 | 0.7 | 1 |
| wp_usermeta | 6 | 11 | 0.4 | 1 |
| (N/A – Non-Table Query) | 4 | 11 | 0.3 | 1 |
| Total | 100 | 100 | 6.8 | 9 |
SQL Query Analysis
Queries triggered by plugins calling Core functions are marked (file, line) at: the plugin code that triggered the query
9 Valid Queries (Order: Query Time)
| Index | Qtime (msec) |
Query |
|---|---|---|
| 2 | 1.977 | SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’ [wp-includes\functions.php(454): wpdb->get_results()] |
| 1 | 1.433 | SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’ [wp-includes\functions.php(1365): wpdb->get_var()] |
| 3 | 0.782 | SELECT * FROM wp_users WHERE user_login = ‘admin’ [wp-settings.php(550): WP->init()] |
| 8 | 0.718 | SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments GROUP BY comment_approved [wp-admin\menu.php(23): wp_count_comments()] |
| 5 | 0.443 | SELECT option_value FROM wp_options WHERE option_name = ‘widget_categories’ LIMIT 1 [wp-includes\widgets.php(1431): wp_widget_categories_register()] |
| 4 | 0.416 | SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 1 [wp-settings.php(550): WP->init()] |
| 6 | 0.357 | SELECT option_value FROM wp_options WHERE option_name = ‘widget_text’ LIMIT 1 [wp-includes\widgets.php(1432): wp_widget_text_register()] |
| 7 | 0.348 | SELECT option_value FROM wp_options WHERE option_name = ‘widget_rss’ LIMIT 1 [wp-includes\widgets.php(1433): wp_widget_rss_register()] |
| 0 | 0.298 | SET NAMES ‘utf8′ [(DB Constructor/Startup)] |
Detailed Query Analysis
The MySQL Site provides helpful hints on the details in this section.
| 0) Query: [(DB Constructor/Startup)] SET NAMES ‘utf8′ |
| Query time: 0.2980 (ms) |
| 1) Query: [wp-includes\functions.php(1365): wpdb->get_var()] SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’ |
|||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wp_options | ref | option_name | option_name | 194 | const | 1 | Using where |
| Query time: 1.4329 (ms) | |||||||||
| 2) Query: [wp-includes\functions.php(454): wpdb->get_results()] SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’ |
|||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wp_options | ALL | 190 | Using where | ||||
| Query time: 1.9770 (ms) | |||||||||
| 3) Query: [wp-settings.php(550): WP->init()] SELECT * FROM wp_users WHERE user_login = ‘admin’ |
|||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wp_users | system | user_login_key | 1 | ||||
| Query time: 0.7820 (ms) | |||||||||
| 4) Query: [wp-settings.php(550): WP->init()] SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 1 |
|||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wp_usermeta | ref | user_id | user_id | 8 | const | 5 | |
| Query time: 0.4160 (ms) | |||||||||
| 5) Query: [wp-includes\widgets.php(1431): wp_widget_categories_register()] SELECT option_value FROM wp_options WHERE option_name = ‘widget_categories’ LIMIT 1 |
|||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wp_options | ref | option_name | option_name | 194 | const | 1 | Using where |
| Query time: 0.4430 (ms) | |||||||||
| 6) Query: [wp-includes\widgets.php(1432): wp_widget_text_register()] SELECT option_value FROM wp_options WHERE option_name = ‘widget_text’ LIMIT 1 |
|||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wp_options | ref | option_name | option_name | 194 | const | 1 | Using where |
| Query time: 0.3569 (ms) | |||||||||
| 7) Query: [wp-includes\widgets.php(1433): wp_widget_rss_register()] SELECT option_value FROM wp_options WHERE option_name = ‘widget_rss’ LIMIT 1 |
|||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wp_options | ref | option_name | option_name | 194 | const | 1 | Using where |
| Query time: 0.3479 (ms) | |||||||||
| SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments GROUP BY comment_approved |
|||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wp_comments | system | 1 | |||||
| Query time: 0.7179 (ms) | |||||||||
原创文章,转载请注明: 转载自PT Ubuntu Blog
