CPU가 과도하게 잡히는 것 같습니다.
본문
접속자는 이 정도인데, CPU가 과도하게 잡히는 것 같습니다.
서버사양
CPU Intel(R) Xeon(R) E-2176G CPU @ 3.70GHz
메모리 DDR4 64GB
용량 DDR4 960 SSD SATA
센토스, 아파치, 마리아디비, PHP7.4 사용중에 있습니다.
에러코드 뿜는것도 없는데...
이유가 뭘까요... 뭐 부터 들여다 봐야 하는 걸까요...?
다음은 mysql에서 show status; 쳤을 때 비상식적으로 숫자가 높은것들 입니다.
|
| Innodb_buffer_pool_pages_data | 145525 | |
|||||
|
| Innodb_buffer_pool_bytes_data | 2384281600 | |
|||||
|
| Innodb_buffer_pool_pages_dirty | 3936 | |
|||||
|
| Innodb_buffer_pool_bytes_dirty | 64487424 | |
|||||
|
| Innodb_buffer_pool_pages_flushed | 9428821 | |
|||||
|
| Innodb_buffer_pool_pages_free | 1149438 | |
|||||
|
| Innodb_buffer_pool_pages_misc | 15757 | |
|||||
|
| Innodb_buffer_pool_pages_total | 1310720 | |
|||||
|
| Innodb_buffer_pool_read_ahead_rnd | 0 | |
|||||
|
| Innodb_buffer_pool_read_ahead | 902 | |
|||||
|
| Innodb_buffer_pool_read_ahead_evicted | 0 | |
|||||
|
| Innodb_buffer_pool_read_requests | 1277690078014 | |
|||||
|
| Innodb_buffer_pool_reads | 123614 | |
|||||
|
| Innodb_buffer_pool_wait_free | 0 | |
|||||
|
| Innodb_buffer_pool_write_requests | 114166129 | |
|||||
|
| Innodb_data_fsyncs | 13697910 | |
|||||
|
| Innodb_data_pending_fsyncs | 0 | |
|||||
|
| Innodb_data_pending_reads | 0 | |
|||||
|
| Innodb_data_pending_writes | 0 | |
|||||
|
| Innodb_data_read | 2040138240 | |
|||||
|
| Innodb_data_reads | 124609 | |
|||||
|
| Innodb_data_writes | 20506901 | |
|||||
|
| Innodb_data_written | 326103515648 | |
|||||
|
| Innodb_dblwr_pages_written | 9428690 | |
|||||
|
| Innodb_dblwr_writes | 1581080 | |
|||||
|
| Innodb_log_waits | 0 | |
|||||
|
| Innodb_log_write_requests | 16599080 | |
|||||
|
| Innodb_log_writes | 9441383 | |
|||||
|
| Innodb_os_log_fsyncs | 9493560 | |
|||||
|
| Innodb_os_log_pending_fsyncs | 0 | |
|||||
|
| Innodb_os_log_pending_writes | 0 | |
|||||
|
| Innodb_os_log_written | 17115388416 | |
|||||
|
| Innodb_page_size | 16384 | |
|||||
|
| Innodb_pages_created | 21009 | |
|||||
|
| Innodb_pages_read | 124516 | |
|||||
|
| Innodb_pages0_read | 78 | |
|||||
|
| Innodb_pages_written | 9428821 | |
|||||
|
| Innodb_row_lock_current_waits | 5 | |
|||||
|
| Innodb_row_lock_time | 92448808 | |
|||||
|
| Innodb_row_lock_time_avg | 313 | |
|||||
|
| Innodb_row_lock_time_max | 3469 | |
|||||
|
| Innodb_row_lock_waits | 294630 | |
|||||
|
| Innodb_rows_deleted | 318422 | |
|||||
|
| Innodb_rows_inserted | 1426118 | |
|||||
|
| Innodb_rows_read | 547353700826 | |
|||||
|
| Innodb_rows_updated | 20518348 | |
|
| Innodb_secondary_index_triggered_cluster_reads | 410202924088 | |
|
| Memory_used_initial | 274287456 | |
|
| Innodb_secondary_index_triggered_cluster_reads | 410202924088 | |
|
| Queries | 235411609 | |
|
| wsrep_cluster_conf_id | 184467440737095 51615 | |
|
| wsrep_local_index | 184467440737095 51615 | |
