Администратор Сообщений: 3023 Откуда: Astana Зарегистрирован: 01 Апреля 2007, 18:11:10 Сказали спасибо 470 раз Статус: offline
Опубликовано 27 Февраля 2009, 14:47:42
нет не идиотизм... для VDS 1,5Тб трафика самый раз! Учтите что VDS берется как альтернатива дедику, т.е. подразумевает множество сайтов с большим потоком инфы... Вот Я на 1 тп у данного хостера... все сайты кушают примерно 400Гб трафа
Местный Сообщений: 41 Зарегистрирован: 10 Сентября 2007, 22:58:22 Сказали спасибо 1 раз Статус: offline
Опубликовано 02 Марта 2009, 20:27:09
Не знаю как VDS но сайт на Wordpress c момента оплаты и по сегодняшний день на своей морде пишет вот такие прелести
WordPress database error: [Can't create/write to file '/tmp/#sql_4c17_0.MYD' (Errcode: 17)]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag' AND tr.object_id IN (84, 80, 77, 74, 71) ORDER BY t.name ASC
вместо форума показывает такое:
WordPress database error: [Can't create/write to file '/tmp/#sql_7ee6_0.MYD' (Errcode: 17)]
SELECT wp_sfgroups.group_id, group_name, group_desc, group_rss, group_icon, forum_id, forum_name, forum_slug, forum_desc, forum_status, forum_icon, forum_rss_private, post_id FROM wp_sfgroups LEFT JOIN wp_sfforums ON wp_sfgroups.group_id = wp_sfforums.group_id ORDER BY group_seq, forum_seq;
WordPress database error: [Can't create/write to file '/tmp/#sql_7ee6_0.MYD' (Errcode: 17)]
SELECT wp_sfgroups.group_id, group_name, group_desc, group_rss, group_icon, forum_id, forum_name, forum_slug, forum_desc, forum_status, forum_icon, forum_rss_private, post_id FROM wp_sfgroups LEFT JOIN wp_sfforums ON wp_sfgroups.group_id = wp_sfforums.group_id ORDER BY group_seq, forum_seq;
или такое
WordPress database error: [Can't create/write to file '/tmp/#sql_7ee6_0.MYI' (Errcode: 23)]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag' AND tr.object_id IN (90) ORDER BY t.name ASC
WordPress database error: [Can't find file: './elenix_db/wp_sfforums.frm' (errno: 23)]
SELECT forum_name FROM wp_sfforums WHERE forum_slug='forum-2'
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT admin FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmemberships.frm' (errno: 23)]
SELECT wp_sfmemberships.usergroup_id, usergroup_name, usergroup_desc FROM wp_sfmemberships LEFT JOIN wp_sfusergroups ON wp_sfusergroups.usergroup_id = wp_sfmemberships.usergroup_id WHERE user_id=1
WordPress database error: [Can't find file: './elenix_db/wp_sfpermissions.frm' (errno: 23)]
SELECT forum_id, usergroup_id, permission_role FROM wp_sfpermissions ORDER BY permission_id
WordPress database error: [Can't find file: './elenix_db/wp_sfroles.frm' (errno: 23)]
SELECT role_id, role_actions FROM wp_sfroles ORDER BY role_id
WordPress database error: [Can't find file: './elenix_db/wp_sfmeta.frm' (errno: 23)]
SELECT * FROM wp_sfmeta WHERE meta_type='forum_rank' ORDER BY meta_id
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT admin FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT moderator FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmeta.frm' (errno: 23)]
SELECT * FROM wp_sfmeta WHERE meta_type='smileys' AND meta_key='smileys' ORDER BY meta_id
WordPress database error: [Can't find file: './elenix_db/wp_sfmeta.frm' (errno: 23)]
SELECT * FROM wp_sfmeta WHERE meta_type='tinymce_toolbar' AND meta_key='user' ORDER BY meta_id
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT admin FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfforums.frm' (errno: 23)]
SELECT forum_id FROM wp_sfforums WHERE forum_slug='forum-2'
Записки кадровика…
немного о кадровом документообороте
* Контакты
* Форум
Форум
WordPress database error: [Can't find file: './elenix_db/wp_sfsettings.frm' (errno: 23)]
DELETE FROM wp_sfsettings WHERE setting_date < DATE_SUB(CURDATE(), INTERVAL 24 HOUR) AND setting_name <> 'membercount' AND setting_name <> 'maxonline';
WordPress database error: [Can't find file: './elenix_db/wp_sfsettings.frm' (errno: 23)]
DELETE FROM wp_sfsettings WHERE setting_name='membercount' AND setting_value < 1;
WordPress database error: [Can't find file: './elenix_db/wp_sfnotice.frm' (errno: 23)]
DELETE FROM wp_sfnotice WHERE ndate < DATE_SUB(CURDATE(), INTERVAL 24 HOUR);
WordPress database error: [Can't find file: './elenix_db/wp_sfforums.frm' (errno: 23)]
SELECT * FROM wp_sfforums WHERE forum_slug='forum-2';
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT * FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT * FROM wp_sfmembers WHERE moderator=1 AND user_id=1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT posts FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sftrack.frm' (errno: 23)]
SELECT id FROM wp_sftrack WHERE trackname='admin'
WordPress database error: [Can't find file: './elenix_db/wp_sfposts.frm' (errno: 23)]
SELECT DISTINCT topic_id FROM wp_sfposts WHERE post_status = 0 AND UNIX_TIMESTAMP(post_date) > '' AND user_id != 1 ORDER BY topic_id DESC;
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
UPDATE wp_sfmembers SET newposts = 'a:1:{i:0;i:0;}' WHERE user_id=1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
UPDATE wp_sfmembers SET checktime = now() WHERE user_id=1
WordPress database error: [Can't find file: './elenix_db/wp_sftrack.frm' (errno: 23)]
SELECT * FROM wp_sftrack WHERE trackdate < DATE_SUB(now(), INTERVAL 20 MINUTE)
WordPress database error: [Can't find file: './elenix_db/wp_sfnotice.frm' (errno: 23)]
SELECT message FROM wp_sfnotice WHERE id='95.111.222.119' AND item='sfmessage'
WordPress database error: [Can't find file: './elenix_db/wp_sfgroups.frm' (errno: 23)]
SELECT wp_sfgroups.group_id, group_name, group_desc, group_rss, group_icon, forum_id, forum_name, forum_slug, forum_desc, forum_status, forum_icon, forum_rss_private, post_id FROM wp_sfgroups LEFT JOIN wp_sfforums ON wp_sfgroups.group_id = wp_sfforums.group_id ORDER BY group_seq, forum_seq;
WordPress database error: [Can't find file: './elenix_db/wp_sfgroups.frm' (errno: 23)]
SELECT * FROM wp_sfgroups ORDER BY group_seq
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT newposts FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT checktime FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfposts.frm' (errno: 23)]
SELECT DISTINCT topic_id FROM wp_sfposts WHERE post_status = 0 AND UNIX_TIMESTAMP(post_date) > '' AND user_id != 1 ORDER BY topic_id DESC;
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
UPDATE wp_sfmembers SET newposts = 'a:1:{i:0;i:0;}' WHERE user_id=1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
UPDATE wp_sfmembers SET checktime = now() WHERE user_id=1
WordPress database error: [Can't find file: './elenix_db/wp_sfposts.frm' (errno: 23)]
SELECT DISTINCT forum_id, topic_id FROM wp_sfposts ORDER BY post_id DESC LIMIT 15;
WordPress database error: [Can't find file: './elenix_db/wp_sfnotice.frm' (errno: 23)]
SELECT message FROM wp_sfnotice WHERE id='95.111.222.119' AND item='sfmessage'
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT display_name FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT signature FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT sigimage FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT avatar FROM wp_sfmembers WHERE user_id = 1
WordPress database error: [Can't find file: './elenix_db/wp_sfmeta.frm' (errno: 23)]
SELECT * FROM wp_sfmeta WHERE meta_type='custom_field' ORDER BY meta_id
WordPress database error: [Can't find file: './elenix_db/wp_sftrack.frm' (errno: 23)]
SELECT trackuserid, trackname FROM wp_sftrack ORDER BY trackuserid
WordPress database error: [Can't find file: './elenix_db/wp_sfforums.frm' (errno: 23)]
SELECT group_id, forum_id, topic_count FROM wp_sfforums ORDER BY group_id
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT SQL_CALC_FOUND_ROWS user_id, display_name, posts FROM wp_sfmembers WHERE moderator=0 AND admin=0 ORDER BY posts DESC LIMIT 0,6;
WordPress database error: [Can't find file: './elenix_db/wp_sfsettings.frm' (errno: 23)]
SELECT setting_value FROM wp_sfsettings WHERE setting_name = 'membercount'
WordPress database error: [Can't find file: './elenix_db/wp_sfsettings.frm' (errno: 23)]
SELECT setting_value FROM wp_sfsettings WHERE setting_name = 'membercount'
WordPress database error: [Can't find file: './elenix_db/wp_sfposts.frm' (errno: 23)]
SELECT DISTINCT guest_name FROM wp_sfposts WHERE guest_name IS NOT NULL
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT COUNT(display_name) FROM wp_sfmembers WHERE moderator=1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT COUNT(display_name) FROM wp_sfmembers WHERE admin=1
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT display_name, posts FROM wp_sfmembers WHERE admin=1 ORDER BY display_name
WordPress database error: [Can't find file: './elenix_db/wp_sfmembers.frm' (errno: 23)]
SELECT display_name, posts FROM wp_sfmembers WHERE moderator=1 ORDER BY display_name
--------------------------------------------------------------------
С 27 числа проблема не устраняется. Сайт переодически работает нормально, переодически высвечивает ошибки. Примерно 5% времени сайт работает, а 95% времени он в выдает ошибки о проблемах с MySQL
Сайт в действии можно посмотреть по адресу http://jus.org.ua
Местный Сообщений: 41 Зарегистрирован: 10 Сентября 2007, 22:58:22 Сказали спасибо 1 раз Статус: offline
Опубликовано 03 Марта 2009, 14:40:19
Да в тикетах все расписано начиная с 27 февраля, только проблема не решается. Права на файлы стоят правильные, а ошибки относятся к фалам MySQL, такие как
Can't create/write to file '/tmp/#sql_4c17_0.MYD
Can't find file: './elenix_db/wp_sfforums.frm
Can't find file: './elenix_db/wp_sfmemberships.frm и т.д.
Это именно проблема базы данных, а не файлов залитых на хост... Если б проблема была в моей криворукости или в файлах на хостинге, ошибки выдавало б постоянно, а так пол часа сайт работает потом 2 часа выдает ошибки. Ну не может такого быть.
P.S. Uptime это очень хорошо, только он показывает доступность самого сайта, а не доступность MySQL сервера.
Местный Сообщений: 22 Зарегистрирован: 20 Февраля 2009, 07:04:23 Сказали спасибо 0 раз Статус: offline
ICQ статус
Опубликовано 03 Марта 2009, 15:35:25
я уверен, что после 5-го, все измениться к лучшему, кроме полного администрирования, будет произведен апгрейд, также будет установлена + еще одна антиддос программа
Регистрация 
