hello I got email from jaguarpc and said my website suspended because my website very high load on the server . they send these mysqp query : ================================ --- | 22 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 109 | closing tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 23 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 109 | closing tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 24 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 28 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'cbnetpo_ping_optimizer' LIMIT 1 | | 25 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 109 | closing tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 41 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 109 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 42 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 28 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'cbnetpo_ping_optimizer' LIMIT 1 | | 43 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 28 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'cbnetpo_ping_optimizer' LIMIT 1 | | 44 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 28 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'cbnetpo_ping_optimizer' LIMIT 1 | | 63 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 109 | closing tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 70 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 109 | closing tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 79 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 28 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'cbnetpo_ping_optimizer' LIMIT 1 | | 80 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 28 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'cbnetpo_ping_optimizer' LIMIT 1 | | 82 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 109 | closing tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 100 | jdailyfr | localhost | jdailyfr_pdfgoo | Query | 69 | Opening tables | SELECT `Configuration`.`id`, `Configuration`.`config_term`, `Configuration`.`config_name`, `Configur | | 101 | jdailyfr | localhost | jdailyfr_pdfgoo | Query | 206 | closing tables | SELECT `Ebook`.`id`, `Ebook`.`category_id`, `Ebook`.`title`, `Ebook`.`slug`, `Ebook`.`description`, | | 102 | jdailyfr | localhost | jdailyfr_pdfgoo | Query | 54 | Opening tables | SELECT `Configuration`.`id`, `Configuration`.`config_term`, `Configuration`.`config_name`, `Configur | | 118 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 109 | closing tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 129 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 69 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 143 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 153 | closing tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 160 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 130 | closing tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 179 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 14 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'aiosp_post_title_format' LIMIT 1 | | 183 | jdailyfr_wrdp4 | localhost | jdailyfr_wrdp4 | Query | 81 | Opening tables | SELECT option_value FROM wp_options WHERE option_name = 'siteurl' | | 192 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 80 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 197 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 74 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 201 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 74 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 207 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 62 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 208 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 62 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 214 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 53 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 222 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 39 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 223 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 38 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 224 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 35 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 226 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 33 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 233 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 26 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 234 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 26 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 246 | jdailyfr | localhost | jdailyfr_pdfgoo | Query | 13 | Opening tables | SELECT `Ebook`.`id`, `Ebook`.`category_id`, `Ebook`.`title`, `Ebook`.`slug`, `Ebook`.`description`, | | 262 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 0 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' | | 263 | jdailyfr_ucar | localhost | jdailyfr_caca | Query | 0 | Opening tables | SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' -- ================================ anyone can help analyze , plugin that make my website high load ? I dont understand to read this query thanks
"aiosp_post_title_format" refers to the All In One SEO plugin (aiosp) "cbnetpo_ping_optimizer" refers to the cbnet Ping Optimizer plugin (cbnetpo) But it may even be something else causing the problem.
Hey Pal, Dont you worry! firstly, do you have access to your FTP? If yes login to your ftp and rename the plugins folder, if these are caused due to plugins eating server handle memory then your blog will work again. then login to the admin section and one by one enable each plugin back. Also google for WP Health plugin, it shows the memory usage by your blog of its in RED or not this way you could use the minimal plugin and have a great blog. let me know if that helped or more questions. warm regards Josh