SmartCJ Support Forum

Добрый вечер!
08.09 select value from settings where name = 'last_update_number':: :
08.09 select separate_vars from rot_linked_db where rot_linked_id = '1' :: :
08.09 select value from settings where name = 'site_url':: :
08.09 SELECT name, value FROM rot_settings WHERE name IN ('save_method', 'url_to_data', 'ftp_url',
'sphinx_host', 'sphinx_port', 'sphinx_search_index', 'sphinx_match_mode', 'banner_groups' ) :: :
08.09 SELECT * FROM rot_sponsors as s, rot_sponsors_data as sd
WHERE s.sponsor_id = sd.sponsor_id and sd.site_id = '1'
ORDER BY sponsor_name:: :
08.09 SELECT gr.name as category_name, gr_data.custom_name as category_custom_name,
gr_data.description as category_description, gr.id as category_id,
gr_data.group_custom_var1, gr_data.group_custom_var2, gr_data.group_custom_var3, gr_data.status as group_status, gr.parent_id,
g.*, gs.total_shows
FROM rot_galleries AS g
JOIN rot_gallery_stats1 as gs on gs.thumb_id = g.id
JOIN rot_gallery_info AS gi ON gi.gallery_md5 = g.gallery_md5
JOIN rot_groups AS gr ON gi.url = gr.id
JOIN rot_groups_data AS gr_data ON gi.url = gr_data.group_id
where g.rgroup = 0 and g.sponsor_id = 0 and gi.url != 0
and content_type = '0'
and gr_data.site_id = '1' and gi.source_url = '1' order by category_name asc:: :
08.09 SELECT gr.name as category_name, gr_data.custom_name as category_custom_name,
gr_data.description as category_description, gr.id as category_id,
gr_data.group_custom_var1, gr_data.group_custom_var2, gr_data.group_custom_var3, gr_data.status as group_status, gr.parent_id,
g.*, gs.total_shows
FROM rot_galleries AS g
JOIN rot_gallery_stats1 as gs on gs.thumb_id = g.id
JOIN rot_gallery_info AS gi ON gi.gallery_md5 = g.gallery_md5
JOIN rot_groups AS gr ON gi.url = gr.id
JOIN rot_groups_data AS gr_data ON gi.url = gr_data.group_id
where g.rgroup = 0 and g.sponsor_id = 0 and gi.url != 0
and content_type = '0'
and gr_data.site_id = '1' and gi.source_url = '1' order by gs.total_ctr desc:: :


вот подобное льется с дикой скоростью в scj/logs/error.log

почему?

Видимо какие то пробелмы на серваке.
Сайт работает номрально ? октрывается все хорошо и тп ?

вот сейчас только вот это в error.log

09.26 SELECT hr09 FROM day WHERE h = '10.smartcj.tds' :: :
09.28 SELECT hr09 FROM day WHERE h = '7.smartcj.tds' :: :
09.28 SELECT hr09 FROM day WHERE h = '9.smartcj.tds' :: :
09.28 SELECT hr09 FROM day WHERE h = '10.smartcj.tds' :: :
09.29 SELECT hr09 FROM day WHERE h = '7.smartcj.tds' :: :
09.29 SELECT hr09 FROM day WHERE h = '9.smartcj.tds' :: :
09.29 SELECT hr09 FROM day WHERE h = '10.smartcj.tds' :: :
09.30 SELECT hr09 FROM day WHERE h = '7.smartcj.tds' :: :
09.30 SELECT hr09 FROM day WHERE h = '9.smartcj.tds' :: :
09.30 SELECT hr09 FROM day WHERE h = '10.smartcj.tds' :: :

Вопросы вообщем-то теже...

сейчас все в порядке, до этого рушилась таблица day
1 сайт. 160K и Load Average средний 2.9
Без запущенного крона LA : 1
Железо
Dual E5-2620 / 48GB RAM / 4 x 1TB in hardware RAID 5

top - 11:05:24 up 16:32, 1 user, load average: 3.32, 3.15, 2.91
Tasks: 602 total, 2 running, 597 sleeping, 0 stopped, 3 zombie
Cpu(s): 12.9%us, 4.5%sy, 0.0%ni, 80.6%id, 1.6%wa, 0.0%hi, 0.4%si, 0.0%st
Mem: 49396744k total, 19753480k used, 29643264k free, 311688k buffers
Swap: 24772600k total, 0k used, 24772600k free, 11787176k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1278 mysql 20 0 30.0g 4.9g 7088 S 118.2 10.4 153:08.78 mysqld
17301 webadmin 20 0 193m 48m 6140 R 99.1 0.1 0:07.47 php
17300 webadmin 20 0 244m 99m 6468 S 45.6 0.2 0:06.47 php
27025 root 20 0 240m 4460 1232 S 32.5 0.0 5:10.72 php-fpm
13021 couchbas 20 0 1954m 426m 39m S 3.9 0.9 22:45.26 beam.smp
27814 webadmin 20 0 49664 5668 956 S 3.3 0.0 1:12.24 nginx
13184 couchbas 20 0 6268 664 528 S 3.0 0.0 15:08.71 sigar_port
30242 webadmin 20 0 249m 15m 3384 S 3.0 0.0 0:00.09 php-fpm
27808 webadmin 20 0 48460 4308 956 S 2.6 0.0 1:24.10 nginx
27811 webadmin 20 0 50960 6856 956 S 2.0 0.0 1:13.08 nginx
346 root 39 19 0 0 0 S 1.0 0.0 10:22.86 kipmi0
922 root 20 0 0 0 0 S 1.0 0.0 1:11.25 jbd2/dm-0-8
5452 root 20 0 15428 1720 976 R 1.0 0.0 0:16.69 top
13209 couchbas 20 0 410m 4204 1388 S 1.0 0.0 2:58.91 moxi
28532 webadmin 20 0 245m 10m 3300 S 1.0 0.0 0:00.03 php-fpm
30228 webadmin 20 0 246m 11m 3212 S 1.0 0.0 0:00.03 php-fpm
30244 webadmin 20 0 244m 10m 3192 S 1.0 0.0 0:00.03 php-fpm
30231 webadmin 20 0 245m 10m 3216 S 0.7 0.0 0:00.02 php-fpm
30237 webadmin 20 0 245m 10m 3204 S 0.7 0.0 0:00.02 php-fpm
30246 webadmin 20 0 245m 10m 3176 S 0.7 0.0 0:00.02 php-fpm
1 root 20 0 19356 1576 1264 S 0.3 0.0 0:05.33 init
160 root 20 0 0 0 0 S 0.3 0.0 0:12.99 kblockd/6
2500 root 20 0 0 0 0 S 0.3 0.0 0:46.54 kondemand/0
2502 root 20 0 0 0 0 S 0.3 0.0 0:08.47 kondemand/2
2506 root 20 0 0 0 0 S 0.3 0.0 0:15.79 kondemand/6
2507 root 20 0 0 0 0 S 0.3 0.0 0:08.41 kondemand/7
2513 root 20 0 0 0 0 S 0.3 0.0 0:14.44 kondemand/13

Ок, те ошибки были из-за того того что упала таблица.
3 это небольшой ЛА для этого проца.