|
|
Задавайте вопросы, мы ответим
Вы не зашли.
не могу понять откуда появлюются затык в мускуле - сайт начинает тормозить ... при этом апач нормально работает ... мускул начинает тормозить ? его не хватает ? памяти ?
на сервер 12 гиг память - а это конфиг - помогите плиз советом - куда копать ?
[client]
default-character-set = cp1251
[mysqld]
port = 3306
datadir = /var/lib/mysql
user = mysql
log-error = /var/log/mysql.log
log-bin=/var/log/mysql/srv01-bin.log
server-id = 1
expire_logs_days = 2
max_binlog_size = 100M
binlog-do-db=freesell_new
binlog-do-db=freesell_forum
skip-name-resolve
skip-locking
low-priority-updates
#skip-innodb
max_connections=3000
key_buffer_size = 2G
innodb_buffer_pool_size = 1G
innodb_log_buffer_size = 128M
innodb_flush_log_at_trx_commit=0
max_allowed_packet = 8M
table_cache = 2048
tmp_table_size=2024M
max_heap_table_size = 1024M
sort_buffer_size = 8M
read_buffer_size = 8M
join_buffer_size = 8M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 128M
query_cache_limit=32M
query_cache_size=512M
memlock
thread_stack=512K
thread_cache_size = 90
thread_concurrency = 16
default-character-set=cp1251
skip-character-set-client-handshake
character-set-server = cp1251
collation-server = cp1251_general_ci
init-connect = "SET NAMES cp1251"
concurrent_insert=2
low_priority_updates=1
#log-slow-queries=/var/log/mysql-slow-queries.log
#long_query_time=10
#log-queries-not-using-indexes
[mysqldump]
quick
max_allowed_packet = 1600M
[mysql]
default-character-set=cp1251
[mysqldump]
quick
max_allowed_packet = 1600M
[mysql]
default-character-set=cp1251
Неактивен
Почему Вы считаете, что дело в MySQL? И почему Вы считаете, что Апач нормально
работает? Ну и запросы из slow log посмотрите 
Неактивен
они туда начинают попадать только когда мускул лочит какие таблицы ...
а что по конфигу скажете ?
Неактивен
Ну, конфиг
init-connect — зло. Пакет в полтора гигабайта… представляю себе сервер,
обменивающийся запросами по полтора гигабайта… 
Неактивен
Какие таблицы лочит и почему? Посмотрите SHOW FULL PROCESSLIST во время этого торможения.
Неактивен
%cpu %mem
47.0 33.4 mysqld - вот почему то постоянно так вот ... почему процессор так жрёт не понимаю ?
Неактивен
Пока не покажете запросы и блокировки — мы тоже ничего сказать не можем.
Скорее всего, что-то сортирует.
Неактивен
Может быть побилась таблица, он ее чинит. Выполните запрос "SHOW FULL PROCESSLIST"
Неактивен
767 da_admin 192.168.0.1:34925 NULL Binlog Dump 2852 Has sent all binlog to slave; waiting for binlog t... NULL
2580 freesell_new 213.186.115.83:57341 freesell_new Sleep 4 NULL
38650 freesell_new 192.168.0.1:45312 freesell_new Query 1 Updating UPDATE s_messages SET show_cnt = show_cnt + 1 , ct...
38657 freesell_new 192.168.0.1:45356 freesell_new Sleep 1 NULL
38659 freesell_new 192.168.0.1:45361 freesell_new Query 1 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('50...
38661 freesell_new 192.168.0.1:45372 freesell_new Query 1 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('49...
38665 freesell_new 192.168.0.1:45387 freesell_new Sleep 0 NULL
38666 freesell_new 192.168.0.1:45390 NULL Query 0 NULL SHOW FULL PROCESSLIST
2580 freesell_new 213.186.115.83:57341 freesell_new Sleep 2 NULL
39234 freesell_new 192.168.0.1:47650 freesell_new Query 0 Copying to tmp table SELECT g.*, b.item, b.item_path FROM goods g LEFT ...
39235 freesell_new 192.168.0.1:47654 freesell_forum Query 1 Writing to net SELECT *
FROM datastore
WHERE title IN ('','...
Отредактированно mordan (04.03.2010 22:27:42)
Неактивен
767 da_admin 192.168.0.1:34925 NULL Binlog Dump 3152 Has sent all binlog to slave; waiting for binlog t... NULL
2580 freesell_new 213.186.115.83:57341 freesell_new Sleep 3 NULL
41796 freesell_new 213.186.115.83:50782 freesell_new Query 3 Sending data INSERT INTO stat_brands (cdate, user_id, category_...
41798 freesell_new 213.186.115.83:50784 freesell_new Query 89 Sending data INSERT INTO `t_messages_temp` SELECT m_id, parent_...
41801 freesell_new 213.186.115.83:50786 freesell_new Query 0 Updating UPDATE goods SET c_sellers = 1 WHERE id = 138022
41838 freesell_new 192.168.0.1:52722 freesell_new Query 88 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42354 freesell_new 192.168.0.1:54668 freesell_new Query 50 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42356 freesell_new 192.168.0.1:54695 freesell_new Query 49 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42373 freesell_new 192.168.0.1:54744 freesell_new Query 3 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42374 freesell_new 192.168.0.1:54747 freesell_new Query 3 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42386 freesell_new 192.168.0.1:54775 freesell_new Query 2 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42393 freesell_new 192.168.0.1:54791 freesell_forum Query 1 update INSERT INTO post
(showsignature, allowsmilie, us...
42398 freesell_new 192.168.0.1:54802 freesell_new Query 2 statistics SELECT message FROM t_messages_text WHERE m_id = 8...
42401 freesell_new 192.168.0.1:54808 freesell_new Query 1 statistics SELECT id FROM gspec_goods WHERE id_goods = '99080...
42402 freesell_new 192.168.0.1:54810 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42406 freesell_new 192.168.0.1:54819 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42410 freesell_new 192.168.0.1:54829 freesell_new Query 3 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42434 freesell_new 192.168.0.1:54890 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42446 freesell_new 192.168.0.1:54923 freesell_forum Query 1 Locked INSERT INTO post
(showsignature, allowsmilie, us...
42447 freesell_new 192.168.0.1:54924 freesell_forum Query 1 Locked INSERT INTO post
(showsignature, allowsmilie, us...
42455 freesell_new 192.168.0.1:54940 freesell_new Query 1 update INSERT INTO `t_messages_img` (`id`, `real_name`, `...
42465 freesell_new 192.168.0.1:54962 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42466 freesell_new 192.168.0.1:54965 freesell_new Query 1 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42474 freesell_new 192.168.0.1:54984 freesell_new Query 2 statistics SELECT message FROM t_messages_text WHERE m_id = 2...
42477 freesell_new 192.168.0.1:54993 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42478 freesell_new 192.168.0.1:54995 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42483 freesell_new 192.168.0.1:55006 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42491 freesell_new 192.168.0.1:55032 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42494 freesell_new 192.168.0.1:55039 freesell_new Query 1 statistics SELECT * FROM goods_comment WHERE id_goods = '7219...
42498 freesell_new 192.168.0.1:55048 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42504 freesell_new 192.168.0.1:55061 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42509 freesell_new 192.168.0.1:55072 freesell_new Query 2 Sending data SELECT * FROM goods_images WHERE (id_goods = '1441...
42510 freesell_new 192.168.0.1:55074 freesell_new Query 2 statistics select 1 from t_user where login='lelelada'
42511 freesell_new 192.168.0.1:55076 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42512 freesell_new 192.168.0.1:55080 freesell_forum Query 1 Locked INSERT INTO post
(showsignature, allowsmilie, us...
42531 freesell_new 192.168.0.1:55128 freesell_forum Query 1 Locked INSERT INTO post
(showsignature, allowsmilie, us...
42533 freesell_new 192.168.0.1:55132 freesell_new Query 1 Copying to tmp table SELECT m.m_id as id, m.title, mt.message as descri...
42541 freesell_new 192.168.0.1:55149 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42551 freesell_new 192.168.0.1:55197 freesell_new Query 2 Updating UPDATE t_messages SET m_read = m_read+1, m_read_pe...
42553 freesell_new 192.168.0.1:55204 freesell_new Query 1 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42557 freesell_new 192.168.0.1:55215 freesell_new Query 2 statistics SELECT u_id, price_approved, price_status FROM t_u...
42570 freesell_new 192.168.0.1:55256 freesell_new Query 1 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42571 freesell_new 192.168.0.1:55273 freesell_new Query 1 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42572 freesell_new 192.168.0.1:55278 freesell_new Query 1 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42573 freesell_new 192.168.0.1:55293 freesell_new Query 1 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42575 freesell_new 192.168.0.1:55299 freesell_new Query 1 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42576 freesell_new 192.168.0.1:55394 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42583 freesell_new 192.168.0.1:55424 freesell_new Query 1 updating DELETE FROM `price_click` WHERE `cdate` != curdat...
42589 freesell_new 192.168.0.1:55491 freesell_new Query 0 update INSERT INTO se(date , host, agent, page, http_host...
42591 freesell_new 192.168.0.1:55497 freesell_new Query 0 update INSERT INTO se(date , host, agent, page, http_host...
42603 freesell_new 192.168.0.1:55559 freesell_new Query 0 Copying to tmp table SELECT m.m_id, m.type, m.title, m.r_id, m.u_id, UN...
42616 freesell_new 192.168.0.1:55646 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42618 freesell_new 192.168.0.1:55649 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42621 freesell_new 192.168.0.1:55662 freesell_new Query 0 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42622 freesell_new 192.168.0.1:55665 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42623 freesell_new 192.168.0.1:55666 freesell_new Query 0 Updating UPDATE t_messages SET m_read = m_read+1, m_read_pe...
42624 freesell_new 192.168.0.1:55674 freesell_new Query 0 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('19...
42625 freesell_new 192.168.0.1:55677 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42626 freesell_new 192.168.0.1:55682 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42627 freesell_new 192.168.0.1:55683 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42629 freesell_new 192.168.0.1:55697 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42631 freesell_new 192.168.0.1:55715 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42637 freesell_new 192.168.0.1:55743 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42638 freesell_new 192.168.0.1:55745 freesell_new Query 0 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42640 freesell_new 192.168.0.1:55762 freesell_new Query 0 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42641 freesell_new 192.168.0.1:55771 freesell_new Query 0 Sorting result SELECT * FROM categories order by menu_item
42642 freesell_new 192.168.0.1:55780 freesell_forum Sleep 0 NULL
42643 freesell_new 192.168.0.1:55785 freesell_new Sleep 0 NULL
42644 freesell_new 192.168.0.1:55786 NULL Query 0 NULL SHOW FULL PROCESSLIST
Неактивен
767 da_admin 192.168.0.1:34925 NULL Binlog Dump 3208 Has sent all binlog to slave; waiting for binlog t... NULL
2580 freesell_new 213.186.115.83:57341 freesell_new Query 6 update insert into `hars_values` set `har_id` = '108',
...
41796 freesell_new 213.186.115.83:50782 freesell_new Query 10 Sending data INSERT INTO stat_global_tmp (cdate, user_id, categ...
41798 freesell_new 213.186.115.83:50784 freesell_new Query 145 Sending data INSERT INTO `t_messages_temp` SELECT m_id, parent_...
41801 freesell_new 213.186.115.83:50786 freesell_new Query 18 Updating UPDATE goods SET c_sellers = 1 WHERE id = 80829
42386 freesell_new 192.168.0.1:54775 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0....
42401 freesell_new 192.168.0.1:54808 freesell_new Query 18 Copying to tmp table SELECT gc.id_spec as nid, gb.name AS grp, gb.url_g...
42402 freesell_new 192.168.0.1:54810 freesell_new Query 18 Sending data SELECT p.*, u.u_id, u.full_name full_name, u.inpri...
42406 freesell_new 192.168.0.1:54819 freesell_new Query 21 Copying to tmp table SELECT gf.parent_id as id, gfi.id_filter, gf1.numb...
42434 freesell_new 192.168.0.1:54890 freesell_new Query 21 Sending data SELECT p.*, u.u_id, u.full_name full_name, u.inpri...
42465 freesell_new 192.168.0.1:54962 freesell_new Query 19 Sorting result SELECT gfi.id id_goods, gfi.id_brand
FR...
42466 freesell_new 192.168.0.1:54965 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0....
42477 freesell_new 192.168.0.1:54993 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42498 freesell_new 192.168.0.1:55048 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42504 freesell_new 192.168.0.1:55061 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42509 freesell_new 192.168.0.1:55072 freesell_new Query 18 Sorting result SELECT g.id, g.cpu, g.model_name, gb.item brand_na...
42511 freesell_new 192.168.0.1:55076 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42553 freesell_new 192.168.0.1:55204 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0....
42570 freesell_new 192.168.0.1:55256 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0....
42571 freesell_new 192.168.0.1:55273 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0....
42572 freesell_new 192.168.0.1:55278 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0 ...
42573 freesell_new 192.168.0.1:55293 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0 ...
42575 freesell_new 192.168.0.1:55299 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0....
42583 freesell_new 192.168.0.1:55424 freesell_new Query 21 Locked UPDATE t_user SET price_balans = price_balans - 0 ...
42589 freesell_new 192.168.0.1:55491 freesell_new Query 56 update INSERT INTO se(date , host, agent, page, http_host...
42621 freesell_new 192.168.0.1:55662 freesell_new Query 18 update INSERT INTO se(date , host, agent, page, http_host...
42623 freesell_new 192.168.0.1:55666 freesell_new Query 18 Copying to tmp table SELECT g.*, b.item, b.item_path FROM goods g LEFT ...
42626 freesell_new 192.168.0.1:55682 freesell_new Query 18 Sorting result SELECT g.id, g.cpu, g.model_name, g.c_sellers, g.p...
42631 freesell_new 192.168.0.1:55715 freesell_new Query 18 update INSERT INTO se(date , host, agent, page, http_host...
42638 freesell_new 192.168.0.1:55745 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42646 freesell_new 192.168.0.1:55805 freesell_new Query 18 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('21...
42647 freesell_new 192.168.0.1:55810 freesell_new Query 21 Updating UPDATE t_messages SET m_read = m_read+1, m_read_pe...
42648 freesell_new 192.168.0.1:55833 freesell_new Query 10 update INSERT INTO price_click (item_type, item_id, item_...
42650 freesell_new 192.168.0.1:55838 freesell_new Query 18 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('42...
42651 freesell_new 192.168.0.1:55845 freesell_new Query 18 Copying to tmp table SELECT DISTINCT(g.id_brand), b.item, b.item_path
...
42655 freesell_new 192.168.0.1:55871 freesell_new Query 18 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('21...
42669 freesell_new 192.168.0.1:55955 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42671 freesell_new 192.168.0.1:55964 freesell_new Query 18 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('62...
42681 freesell_new 192.168.0.1:56053 freesell_new Query 50 update INSERT INTO se(date , host, agent, page, http_host...
42682 freesell_new 192.168.0.1:56058 freesell_new Query 10 update INSERT INTO price_click (item_type, item_id, item_...
42690 freesell_new 192.168.0.1:56088 freesell_new Query 18 Copying to tmp table SELECT gc.id_spec as nid, gb.name AS grp, gb.url_g...
42694 freesell_new 192.168.0.1:56101 freesell_new Query 18 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('25...
42701 freesell_new 192.168.0.1:56128 freesell_new Query 20 update INSERT INTO se(date , host, agent, page, http_host...
42702 freesell_new 192.168.0.1:56131 freesell_new Query 19 Sending data SELECT p.*, u.u_id, u.full_name full_name, u.inpri...
42704 freesell_new 192.168.0.1:56140 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42710 freesell_new 192.168.0.1:56166 freesell_new Query 21 Copying to tmp table SELECT gf.parent_id as id, gfi.id_filter, gf1.numb...
42712 freesell_new 192.168.0.1:56173 freesell_new Query 18 Copying to tmp table SELECT DISTINCT(g.id_brand), b.item, b.item_path
...
42714 freesell_new 192.168.0.1:56184 freesell_new Query 21 Sending data SELECT p.*, u.u_id, u.full_name full_name, u.inpri...
42716 freesell_new 192.168.0.1:56204 freesell_new Query 18 Updating UPDATE s_messages SET show_cnt = show_cnt + 1 , ct...
42718 freesell_new 192.168.0.1:56228 freesell_new Query 42 update INSERT INTO se(date , host, agent, page, http_host...
42720 freesell_new 192.168.0.1:56241 freesell_new Query 42 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42726 freesell_new 192.168.0.1:56265 freesell_new Query 19 Sending data SELECT g.*, b.item brand_name, gp.preview_descript...
42731 freesell_new 192.168.0.1:56298 freesell_new Query 10 update INSERT INTO price_click (item_type, item_id, item_...
42732 freesell_new 192.168.0.1:56306 freesell_new Query 18 Copying to tmp table SELECT gc.id_spec as nid, gb.name AS grp, gb.url_g...
42737 freesell_new 192.168.0.1:56344 freesell_new Query 21 Updating UPDATE t_messages SET m_read = m_read+1, m_read_pe...
42745 freesell_new 192.168.0.1:56386 freesell_new Query 21 update INSERT INTO se(date , host, agent, page, http_host...
42749 freesell_new 192.168.0.1:56399 freesell_new Query 18 Sorting result SELECT g.id, g.cpu, g.model_name, g.c_sellers, g.c...
42750 freesell_new 192.168.0.1:56403 freesell_new Query 18 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('43...
42757 freesell_new 192.168.0.1:56441 freesell_new Query 21 update INSERT INTO se(date , host, agent, page, http_host...
42759 freesell_new 192.168.0.1:56452 freesell_new Query 18 Updating UPDATE s_messages SET show_cnt = show_cnt + 1 , ct...
42762 freesell_new 192.168.0.1:56467 freesell_new Query 18 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('19...
42763 freesell_new 192.168.0.1:56470 freesell_new Query 18 Copying to tmp table SELECT gc.id_spec as nid, gb.name AS grp, gb.url_g...
42764 freesell_new 192.168.0.1:56473 freesell_new Query 18 Sorting result SELECT g.id, g.cpu, g.model_name, g.c_sellers, g.p...
42766 freesell_new 192.168.0.1:56481 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42783 freesell_new 192.168.0.1:56556 freesell_new Query 10 update INSERT INTO price_click (item_type, item_id, item_...
42790 freesell_new 192.168.0.1:56576 freesell_new Query 20 Sending data SELECT g.*, b.item brand_name, gp.preview_descript...
42791 freesell_new 192.168.0.1:56578 freesell_new Query 18 Copying to tmp table SELECT * FROM s_messages WHERE category_id IN ('24...
42801 freesell_new 192.168.0.1:56651 freesell_new Query 10 update INSERT INTO price_click (item_type, item_id, item_...
42803 freesell_new 192.168.0.1:56655 freesell_new Query 20 Sending data SELECT g.*, b.item brand_name, gp.preview_descript...
42805 freesell_new 192.168.0.1:56660 freesell_new Query 20 Copying to tmp table SELECT g.*, b.item, b.item_path FROM goods g LEFT ...
42806 freesell_new 192.168.0.1:56666 freesell_new Query 21 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42815 freesell_new 192.168.0.1:56714 freesell_new Query 19 Sending data select count(m_id) from t_messages as m where type...
42817 freesell_new 192.168.0.1:56728 freesell_new Query 20 Copying to tmp table SELECT g.*, b.item, b.item_path FROM goods g LEFT ...
42821 freesell_new 192.168.0.1:56761 freesell_new Query 18 Copying to tmp table SELECT gc.id_spec as nid, gb.name AS grp, gb.url_g...
42822 freesell_new 192.168.0.1:56764 freesell_new Query 18 Copying to tmp table SELECT g1.menu_path AS menu_path, g1.menu_item AS ...
42827 freesell_new 192.168.0.1:56777 freesell_new Query 20 Locked insert into t_user (login, passwd, full_name, emai...
42830 freesell_new 192.168.0.1:56819 freesell_new Query 19 Copying to tmp table SELECT gf.parent_id as id, gfi.id_filter, gf1.numb...
42831 freesell_new 192.168.0.1:56824 freesell_new Query 18 Copying to tmp table SELECT g.*, b.item, b.item_path FROM goods g LEFT ...
42835 freesell_new 192.168.0.1:56841 freesell_new Query 18 Copying to tmp table SELECT gc.id_spec as nid, gb.name AS grp, gb.url_g...
42836 freesell_new 192.168.0.1:56844 freesell_new Query 18 Updating UPDATE goods SET show_cnt = show_cnt+1 WHERE (id =...
42837 freesell_new 192.168.0.1:56846 freesell_new Query 18 Sorting result SELECT g.id, g.cpu, g.model_name, gb.item brand_na...
42840 freesell_new 192.168.0.1:56861 freesell_new Query 18 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42841 freesell_new 192.168.0.1:56867 freesell_new Query 18 Updating UPDATE goods SET show_cnt = show_cnt+1 WHERE (id =...
42843 freesell_new 192.168.0.1:56875 freesell_new Query 18 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42846 freesell_new 192.168.0.1:56903 freesell_new Query 18 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42848 freesell_new 192.168.0.1:56928 freesell_new Query 17 statistics SELECT g.id, g.price_min, g.price_max, g.price_min...
42849 freesell_new 192.168.0.1:56931 freesell_new Query 18 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42850 freesell_new 192.168.0.1:56938 freesell_new Query 18 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42851 freesell_new 192.168.0.1:56944 freesell_new Query 18 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42854 freesell_new 192.168.0.1:56970 freesell_new Query 17 Sorting result SELECT * FROM categories WHERE parent = 0 ORDER BY...
42855 freesell_new 192.168.0.1:56974 freesell_new Query 16 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42856 freesell_new 192.168.0.1:56978 freesell_new Query 16 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42857 freesell_new 192.168.0.1:56980 freesell_new Query 16 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42858 freesell_new 192.168.0.1:56996 freesell_new Query 16 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42861 freesell_new 192.168.0.1:57005 freesell_new Query 16 update INSERT INTO se(date , host, agent, page, http_host...
42863 freesell_new 192.168.0.1:57018 freesell_new Query 15 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42864 freesell_new 192.168.0.1:57023 freesell_new Query 15 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42869 freesell_new 192.168.0.1:57044 freesell_new Query 15 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42870 freesell_new 192.168.0.1:57046 freesell_new Query 15 Copying to tmp table SELECT g.*, b.item, b.item_path FROM goods g LEFT ...
42871 freesell_new 192.168.0.1:57061 freesell_new Query 14 Sorting result SELECT * FROM categories order by menu_item
Id User Host db Command Time State Info
42872 freesell_new 192.168.0.1:57062 freesell_new Query 14 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42873 freesell_new 192.168.0.1:57066 freesell_new Query 14 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42874 freesell_new 192.168.0.1:57075 freesell_new Query 14 Copying to tmp table SELECT g.*, b.item, b.item_path FROM goods g LEFT ...
42879 freesell_new 192.168.0.1:57116 freesell_new Query 13 Sorting result SELECT * FROM categories order by menu_item
42880 freesell_new 192.168.0.1:57119 freesell_new Query 13 statistics SELECT id, title, id_serie, picture_server from go...
42889 freesell_new 192.168.0.1:57185 freesell_new Query 13 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42891 freesell_new 192.168.0.1:57190 freesell_new Query 13 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42894 freesell_new 192.168.0.1:57204 freesell_new Query 12 Sending data SELECT pclick FROM t_user_bids WHERE user_id = '92...
42897 freesell_new 192.168.0.1:57223 freesell_new Query 11 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42899 freesell_new 192.168.0.1:57228 freesell_new Query 11 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42900 freesell_new 192.168.0.1:57234 freesell_new Query 11 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42902 freesell_new 192.168.0.1:57242 freesell_new Query 10 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42904 freesell_new 192.168.0.1:57251 freesell_new Query 10 update INSERT INTO se(date , host, agent, page, http_host...
42906 freesell_new 192.168.0.1:57258 freesell_new Query 10 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42907 freesell_new 192.168.0.1:57261 freesell_new Query 10 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42908 freesell_new 192.168.0.1:57265 freesell_new Query 9 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42909 freesell_new 192.168.0.1:57271 freesell_new Query 9 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42910 freesell_new 192.168.0.1:57278 freesell_new Query 8 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42912 freesell_new 192.168.0.1:57283 freesell_new Query 8 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42913 freesell_new 192.168.0.1:57286 freesell_new Query 8 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42914 freesell_new 192.168.0.1:57289 freesell_new Query 8 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42915 freesell_new 192.168.0.1:57292 freesell_new Query 8 Sending data SELECT g.id, g.id_brand, g.id_category, g.id_serie...
42917 freesell_new 192.168.0.1:57297 freesell_new Query 7 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42919 freesell_new 192.168.0.1:57307 freesell_new Query 6 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42920 freesell_new 192.168.0.1:57308 freesell_new Query 6 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42921 freesell_new 192.168.0.1:57316 freesell_new Query 6 Sending data SELECT pclick FROM t_user_bids WHERE user_id = '10...
42924 freesell_new 192.168.0.1:57325 freesell_new Query 5 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42926 freesell_new 192.168.0.1:57330 freesell_forum Query 5 Sending data SELECT
post.*, post.username AS postusername, p...
42927 freesell_new 192.168.0.1:57335 freesell_new Query 5 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42929 freesell_new 192.168.0.1:57342 freesell_forum Query 4 statistics SELECT voteoption
FROM pollvote
WHERE userid...
42930 freesell_new 192.168.0.1:57344 freesell_new Query 5 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42931 freesell_new 192.168.0.1:57347 freesell_new Query 5 Sorting result SELECT * FROM categories order by menu_item
42933 freesell_new 192.168.0.1:57352 freesell_new Query 5 update INSERT INTO se(date , host, agent, page, http_host...
42934 freesell_new 192.168.0.1:57355 freesell_new Query 4 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42935 freesell_new 192.168.0.1:57359 freesell_forum Query 4 Locked UPDATE user
SET lastactivity = 1267731143,
...
42936 freesell_new 192.168.0.1:57361 freesell_new Query 4 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42937 freesell_new 192.168.0.1:57364 freesell_new Query 4 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42938 freesell_new 192.168.0.1:57368 freesell_new Query 4 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42939 freesell_new 192.168.0.1:57372 freesell_new Query 4 Locked UPDATE goods_filters SET c_popular = c_popular + 1...
42940 freesell_new 192.168.0.1:57377 freesell_new Query 3 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42941 freesell_new 192.168.0.1:57381 freesell_new Query 3 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42942 freesell_new 192.168.0.1:57386 freesell_new Query 3 statistics SELECT g.id, g.id_brand, g.id_category, g.id_serie...
42943 freesell_new 192.168.0.1:57408 freesell_new Query 3 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42947 freesell_new 192.168.0.1:57427 freesell_new Query 3 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42949 freesell_new 192.168.0.1:57444 freesell_new Query 2 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42950 freesell_new 192.168.0.1:57455 freesell_new Query 2 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42951 freesell_new 192.168.0.1:57461 freesell_new Query 2 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42952 freesell_new 192.168.0.1:57464 freesell_new Query 2 statistics SELECT m.m_id, m.parent_id, m.type, m.title, m.fi...
42953 freesell_new 192.168.0.1:57467 freesell_new Query 2 update INSERT INTO se(date , host, agent, page, http_host...
42954 freesell_new 192.168.0.1:57472 freesell_new Query 2 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42955 freesell_new 192.168.0.1:57476 freesell_new Query 1 Copying to tmp table SELECT g.*, b.item, b.item_path FROM goods g LEFT ...
42956 freesell_new 192.168.0.1:57479 freesell_forum Query 1 statistics SELECT voteoption
FROM pollvote
WHERE userid...
42957 freesell_new 192.168.0.1:57481 freesell_new Query 1 update INSERT INTO partners_click(u_id, HTTP_REFERER, REM...
42958 freesell_new 192.168.0.1:57484 freesell_new Query 1 Updating UPDATE categories SET popular = popular + 1 WHERE ...
42959 freesell_new 192.168.0.1:57487 freesell_forum Query 1 Locked UPDATE user
SET lastactivity = 1267731146,
...
42960 freesell_new 192.168.0.1:57490 freesell_new Query 0 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42962 freesell_new 192.168.0.1:57495 freesell_new Query 0 statistics SELECT g.id, g.id_brand, g.id_category, g.id_serie...
42963 freesell_new 192.168.0.1:57497 freesell_new Query 0 statistics SELECT g.*, b.item brand_name, b.item_path brand_...
42964 freesell_new 192.168.0.1:57501 NULL Query 0 NULL SHOW FULL PROCESSLIST
Неактивен
это вот сейчас нагрузка на мускульный сервер откуда то полезла ...
Неактивен
Визуально вот это подвисло:
41798 freesell_new 213.186.115.83:50784 freesell_new Query 145 Sending data INSERT INTO
`t_messages_temp` SELECT m_id, parent_...
Ну а остальное просто тормозит из-за нагрузки на диск. Кстати, по диску ничего
не ездит в этот момент? Какой-нибудь дикий бэкап или rsync, например?
Неактивен
у нас репликация настроена на другой сервер - может репликация тормозит ?
Неактивен
Нет, это как раз самый маловероятный фактор. Очень много запросов
с созданием временных табличек. Попробуйте пооптимизировать их,
они уберут основную нагрузку.
Неактивен
а как их оптимизировать ? разбить на несколько таблиц ?
Неактивен
Возьмите какой-нибудь один из них, посмотрите (и/или покажите тут на форуме)
EXPLAIN от него и структуры табличек. Возможно, будет достаточно добавить
несколько индексов.
Неактивен
