i have a problem with our server after upgrading to the latest update. Our inode and cpu usage exceed, Is there anyone encounter the same problem with me? Any MYSQL developer here can help me?
Suddenly our server exceed starting 22nd August, even no visitor .
The CPU usage is caused by the rotuku.com website. For the past 24 hours the /home/rotuku69/public_html/index.php script was executed 22600 times:
Code:
=== Top 10 Executed Scripts ============================================
Count Script Local Path
----- --------------------------- ------------------------------------
22600 http://rotuku.com/index.php/home/rotuku69/public_html/index.php
1 http://rotuku.com/api.php/home/rotuku69/public_html/api.php
------------------------------------------------------------------------
Count Script Local Path
----- --------------------------- ------------------------------------
22600 http://rotuku.com/index.php/home/rotuku69/public_html/index.php
1 http://rotuku.com/api.php/home/rotuku69/public_html/api.php
------------------------------------------------------------------------
Additionally, the database of the website generates slow queries:
Code:
=== TOP 5 of 5 (total) Slow Queries for the past 24 hours ==========
1. Executed 16h 22m 29s ago for 4.116759 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 4.116759 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000074
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
2. Executed 17h 47s ago for 2.224138 sec on Database --> rotuku69_mve
Date: 2018-08-24 14:54:38 Query_time: 2.224138 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000104
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
3. Executed 4h 58m 51s ago for 2.198587 sec on Database --> rotuku69_mve
Date: 2018-08-25 02:56:34 Query_time: 2.198587 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000098
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
4. Executed 16h 22m 29s ago for 1.730769 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 1.730769 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000057
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_stored_sessions (`session_id`, `data`, `expiry`) VALUES ('35ecddb03175be3aac40d0873a80a4cc-C', 'settings|a:2:{s:14:\"cart_languageC\";a:1:{s:5:\"value\";s:2:\"zh\";}s:19:\"secondary_currencyC\";a:2:{s:5:\"value\";s:3:\"PHP\";s:6:\"expiry\";i:1535693568;}}', 1535095968);
------------------------------------------------------------------------------------------------
5. Executed 16h 22m 29s ago for 1.5912 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 1.591200 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050165
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 SELECT name, value FROM cscart_abt__ut_settings WHERE company_id = 0 AND lang_code = 'vi' AND name = 'show_button_buy_in_product_lists';
------------------------------------------------------------------------------------------------
1. Executed 16h 22m 29s ago for 4.116759 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 4.116759 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000074
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
2. Executed 17h 47s ago for 2.224138 sec on Database --> rotuku69_mve
Date: 2018-08-24 14:54:38 Query_time: 2.224138 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000104
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
3. Executed 4h 58m 51s ago for 2.198587 sec on Database --> rotuku69_mve
Date: 2018-08-25 02:56:34 Query_time: 2.198587 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000098
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_cache_handlers (`table_name`, `cache_key`) VALUES ('settings_objects', 'settings'), ('settings_vendor_values', 'settings'), ('settings_descriptions', 'settings'), ('settings_sections', 'settings'), ('settings_variants', 'settings');
------------------------------------------------------------------------------------------------
4. Executed 16h 22m 29s ago for 1.730769 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 1.730769 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000057
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 REPLACE INTO cscart_stored_sessions (`session_id`, `data`, `expiry`) VALUES ('35ecddb03175be3aac40d0873a80a4cc-C', 'settings|a:2:{s:14:\"cart_languageC\";a:1:{s:5:\"value\";s:2:\"zh\";}s:19:\"secondary_currencyC\";a:2:{s:5:\"value\";s:3:\"PHP\";s:6:\"expiry\";i:1535693568;}}', 1535095968);
------------------------------------------------------------------------------------------------
5. Executed 16h 22m 29s ago for 1.5912 sec on Database --> rotuku69_mve
Date: 2018-08-24 15:32:56 Query_time: 1.591200 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050165
# Schema: rotuku69_mve Last_errno: 0 Killed: 0 SELECT name, value FROM cscart_abt__ut_settings WHERE company_id = 0 AND lang_code = 'vi' AND name = 'show_button_buy_in_product_lists';
------------------------------------------------------------------------------------------------
related to the cscart_cache_handlers.
The slow queries in question were most likely the cause for the reported issue.