56,687
社区成员
发帖
与我相关
我的任务
分享
__ InnoDB Buffer Pool __________________________________________________
Usage 6.00G of 6.00G %Used: 100.00
Read hit 100.00%
Pages
Free 0 %Total: 0.00
Data 351.98k 89.51 %Drty: 0.00
Misc 41231 10.49
Latched 0.00
Reads 22.09G 177.5k/s
From file 277.21k 2.2/s 0.00
Ahead Rnd 0/s
Ahead Sql 0/s
Writes 2.75M 22.1/s
Flushes 104.42k 0.8/s
Wait Free 0 0/s
mysql> show global status like '%innodb%';
+---------------------------------------+-------------+
| Variable_name | Value |
+---------------------------------------+-------------+
| Innodb_buffer_pool_pages_data | 351985 |
| Innodb_buffer_pool_pages_dirty | 1 |
| Innodb_buffer_pool_pages_flushed | 104528 |
| Innodb_buffer_pool_pages_free | 1 |
| Innodb_buffer_pool_pages_misc | 41229 |
| Innodb_buffer_pool_pages_total | 393215 |
| Innodb_buffer_pool_read_ahead | 119733 |
| Innodb_buffer_pool_read_ahead_evicted | 123 |
| Innodb_buffer_pool_read_requests | 22103546894 |
| Innodb_buffer_pool_reads | 277236 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 2755035 |
| Innodb_data_fsyncs | 50903 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 6548721664 |
| Innodb_data_reads | 283967 |
| Innodb_data_writes | 338159 |
| Innodb_data_written | 3905318400 |
| Innodb_dblwr_pages_written | 104528 |
| Innodb_dblwr_writes | 8017 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 820425 |
| Innodb_log_writes | 243699 |
| Innodb_os_log_fsyncs | 17348 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 477159424 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 17448 |
| Innodb_pages_read | 399440 |
| Innodb_pages_written | 104528 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 16906 |
| Innodb_row_lock_time_avg | 1536 |
| Innodb_row_lock_time_max | 14849 |
| Innodb_row_lock_waits | 11 |
| Innodb_rows_deleted | 12867 |
| Innodb_rows_inserted | 739480 |
| Innodb_rows_read | 94935197818 |
| Innodb_rows_updated | 95642 |
+---------------------------------------+-------------+
43 rows in set (0.00 sec)
mysql> show global variables like '%innodb_buffer%';
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| innodb_buffer_pool_size | 2147483648 |
+-------------------------+------------+
1 row in set (0.00 sec)
mysql> show global status like '%innodb_buffer%';
+---------------------------------------+--------------+
| Variable_name | Value |
+---------------------------------------+--------------+
| Innodb_buffer_pool_pages_data | 129233 |
| Innodb_buffer_pool_pages_dirty | 15 |
| Innodb_buffer_pool_pages_flushed | 8540671 |
| Innodb_buffer_pool_pages_free | 0 |
| Innodb_buffer_pool_pages_misc | 1838 |
| Innodb_buffer_pool_pages_total | 131071 |
| Innodb_buffer_pool_read_ahead | 96756463 |
| Innodb_buffer_pool_read_ahead_evicted | 20492677 |
| Innodb_buffer_pool_read_requests | 827711274979 |
| Innodb_buffer_pool_reads | 142855319 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 258647188 |
+---------------------------------------+--------------+
# Time: 110811 20:35:06
# User@Host: dev[dev] @ [192.168.1.1]
# Query_time: 4.581699 Lock_time: 0.000045 Rows_sent: 0 Rows_examined: 0
SET timestamp=1313112906;
INSERT /* Article::insertOn F.Sandburg */ IGNORE INTO `page` (page_id,page_namespace,page_title,page_counter,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len) VALUES (NULL,'1180','blind_spot_â‚‚','0','','0','1','0.104521793912','20110812013502','0','0');
# Time: 110811 20:35:22
# User@Host: dev[dev] @ [192.168.1.1]
# Query_time: 12.982034 Lock_time: 0.000120 Rows_sent: 0 Rows_examined: 0
SET timestamp=1313112922;
INSERT /* SMW::makeSMWPageID F.Sandburg */ INTO `smw_ids` (smw_id,smw_title,smw_namespace,smw_iw,smw_sortkey) VALUES (NULL,'blind_spot_â‚‚','1180','','BLIND SPOT B blind spot B');