Форум MySQL

Здравствуйте. У меня собсна такая проблема. Очень сильно грузится MySQL сервер в 746мс,а допустимая нагрузка в 500мс. Обращался в ТП хостинга и мне сказали что тут проблему надо выявлять.rnrnНагрузка создается из-за базы данных p220403_ms. Ниже лог медленных запросов для данной базы за 13-ое января: rnrn# 346.9s user time, 1.6s system time, 25.91M rss, 204.78M vszrn# Current date: Tue Jan 14 17:29:37 2014rn# # Files: /var/log/mysql-slow.log-20140113rn# Overall: 20.13k total, 5 unique, 0.23 QPS, 0.00x concurrency ___________rn# Time range: 2014-01-12 04:02:14 to 2014-01-13 04:01:11rn# Attribute total min max avg 95% stddev medianrn# ============ ======= ======= ======= ======= ======= ======= =======rn# Exec time 338s 11ms 4s 17ms 24ms 29ms 15msrn# Lock time 3s 28us 156ms 138us 273us 2ms 49usrn# Rows sent 53.06k 1 22.49k 2.70 0.99 179.79 0.99rn# Rows examine 458.16M 10.91k 25.91k 23.30k 24.75k 1.63k 22.45krn# Rows affecte 0 0 0 0 0 0 0rn# Rows read 458.16M 10.91k 25.91k 23.30k 24.75k 1.63k 22.45krn# Bytes sent 4.82M 63 2.57M 250.89 62.76 19.33k 62.76rn# Query size 2.52M 35 145 131.07 143.84 15.55 136.99rnrn# Profilern# Rank Query ID Response time Calls R/Call V/M Itemrn# ==== ================== ============== ===== ====== ===== ============rn# 1 0xCD10F1D1CAFD0606 184.5246 54.5% 9996 0.0185 0.01 SELECT mslogrn# 2 0x950D6DAAA8C3F01F 147.0323 43.5% 9996 0.0147 0.00 SELECT mslogrn# MISC 0xMISC 6.7757 2.0% 142 0.0477 0.0 <3 ITEMS>rnrn# Query 1: 0.12 QPS, 0.00x concurrency, ID 0xCD10F1D1CAFD0606 at byte 721979883rn# This item is included in the report because it matches --limit.rn# Scores: V/M = 0.01rn# Time range: 2014-01-12 04:02:14 to 2014-01-13 04:01:11rn# Attribute pct total min max avg 95% stddev medianrn# ============ === ======= ======= ======= ======= ======= ======= =======rn# Count 49 9996rn# Exec time 54 185s 11ms 728ms 18ms 26ms 11ms 16msrn# Lock time 31 877ms 35us 53ms 87us 125us 586us 54usrn# Rows sent 18 9.76k 1 1 1 1 0 1rn# Rows examine 49 227.41M 21.21k 25.91k 23.30k 24.75k 1.62k 22.45krn# Rows affecte 0 0 0 0 0 0 0 0rn# Rows read 49 227.41M 21.21k 25.91k 23.30k 24.75k 1.62k 22.45krn# Bytes sent 12 618.57k 63 64 63.37 62.76 0.00 62.76rn# Query size 54 1.38M 145 145 145 145 0 145rn# String:rn# Databases p220403_msrn# Hostsrn# Last errno 0rn# Users p220403_msrn# Query_time distributionrn# 1usrn# 10usrn# 100usrn# 1msrn# 10ms ################################################################rn# 100ms #rn# 1srn# 10s+rn# Tablesrn# SHOW TABLE STATUS FROM `p220403_ms` LIKE 'mslog'\Grn# SHOW CREATE TABLE `p220403_ms`.`mslog`\Grn# EXPLAIN /*!50100 PARTITIONS*/rnSELECT COUNT(DISTINCT CONCAT(`ip`,':',`port`)) AS `unique` FROM `mslog` WHERE timeyear = 2014 and timemonth = 01 and timeday = 12 and type = 'cs'\Grnrn# Query 2: 0.12 QPS, 0.00x concurrency, ID 0x950D6DAAA8C3F01F at byte 471036241rn# This item is included in the report because it matches --limit.rn# Scores: V/M = 0.00rn# Time range: 2014-01-12 04:02:14 to 2014-01-13 04:01:11rn# Attribute pct total min max avg 95% stddev medianrn# ============ === ======= ======= ======= ======= ======= ======= =======rn# Count 49 9996rn# Exec time 43 147s 11ms 426ms 15ms 19ms 8ms 14msrn# Lock time 63 2s 28us 156ms 177us 490us 2ms 42usrn# Rows sent 18 9.76k 1 1 1 1 0 1rn# Rows examine 49 227.41M 21.21k 25.91k 23.30k 24.75k 1.62k 22.45krn# Rows affecte 0 0 0 0 0 0 0 0rn# Rows read 49 227.41M 21.21k 25.91k 23.30k 24.75k 1.62k 22.45krn# Bytes sent 12 621.56k 63 64 63.67 62.76 0.00 62.76rn# Query size 44 1.12M 117 117 117 117 0 117rn# String:rn# Databases p220403_msrn# Hostsrn# Last errno 0rn# Users p220403_msrn# Query_time distributionrn# 1usrn# 10usrn# 100usrn# 1msrn# 10ms ################################################################rn# 100ms #rn# 1srn# 10s+rn# Tablesrn# SHOW TABLE STATUS FROM `p220403_ms` LIKE 'mslog'\Grn# SHOW CREATE TABLE `p220403_ms`.`mslog`\Grn# EXPLAIN /*!50100 PARTITIONS*/rnSELECT COUNT(`ip`) AS `unique` FROM `mslog` WHERE timeyear = 2014 and timemonth = 01 and timeday = 12 and type = 'cs'\GrnrnПомогите пожалуйста.

Такой вот пост (с замененными хвоставми строк на пары 'rn' ) - результат отправки текста после отлупа по ошибке (Не указано имя пользователя) и последующего постинга.

Стёрто сообщение. Передумал постить.