Здравствуйте.
В один прекрасный день мой сервер лег.
Анализ запросов на одном из сайтов посредством mytop показал следующее:
507 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
496 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
495 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
469 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
467 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
442 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
402 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/963' AND RELATIVE_PATH
324 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
267 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e71' AND RELATIVE_PATH
266 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
266 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e71' AND RELATIVE_PATH
266 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e71' AND RELATIVE_PATH
266 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/963' AND RELATIVE_PATH
259 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
Получается море запросов аж по пол секунды каждый в таблицу b_cache_tag.
Почему так происходит и как с этим бороться?
В один прекрасный день мой сервер лег.
Анализ запросов на одном из сайтов посредством mytop показал следующее:
507 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
496 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
495 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
469 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
467 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
442 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
402 Query SEL ECT TAG FR OM b_cache_tag WHERE SITE_ID = 's1' AND CACHE_SALT = '/963' AND RELATIVE_PATH
324 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
267 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e71' AND RELATIVE_PATH
266 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
266 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e71' AND RELATIVE_PATH
266 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e71' AND RELATIVE_PATH
266 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/963' AND RELATIVE_PATH
259 Query SELECT TAG FR OM b_cache_tag WH ERE SITE_ID = 's1' AND CACHE_SALT = '/e25' AND RELATIVE_PATH
Получается море запросов аж по пол секунды каждый в таблицу b_cache_tag.
Почему так происходит и как с этим бороться?