Анна Сайфулина 0 Опубликовано 23 марта, 2012 Жалоба Share Опубликовано 23 марта, 2012 Последние несколько дней резко увеличилась скорость загрузки сайта. Постоянно появляется ошибка "2006 - MySQL server has gone away". На хостинге перешли на более производительный тариф, на нем же увеличили скорость подключения. Тем не менее скорость загрузки сайта осталась такой же и ошибка не исчезает. MYSQL ERROR REPORT - 23/03/2012 19:03:05 --------------------------------------- 2006 - MySQL server has gone away[/size][/font][/color] [color=#000000][font=Arial, Tahoma, Verdana, sans-serif][size=3]SELECT * FROM customers_status WHERE customers_status_id = '1' AND language_id = '1' --------------------------------------- Server Name : golant.ru Remote Address: 128.75.58.32 Referer : http://golant.ru/admin/whos_online.php?info=pkoice5qj7tof9igt6ft5c6mn5 Requested : /admin/whos_online.php?info=il17hp594tt1f7h5dmpsjq1dq4 Trace Back : admin/whos_online.php:22(requirearray(1) {; [0]=>; string(69) "admin/includes/application_top.php"; }; ) => admin/includes/application_top.php:438(requirearray(1) {; [0]=>; string(70) "includes/write_customers_status.php"; }; ) => includes/write_customers_status.php:67(vam_db_queryarray(1) {; [0]=>; &string(316) "SELECT; *; FROM; customers_status; WHERE; customers_status_id = '1' AND language_id = '1'"; }; ) => inc/vam_db_query.inc.php:35(vam_db_errorarray(3) {; [0]=>; &string(316) "SELECT; *; FROM; customers_status; WHERE; ! customers_status_id = '1' AND language_id = '1'"; [1]=>; &int(2006); [2]=>; &string(26) "MySQL server has gone away"; }; )[/size][/font][/color] [color=#000000][font=Arial, Tahoma, Verdana, sans-serif][size=3][/CODE][/size][/font][/color] Ссылка на сообщение Поделиться на другие сайты
support 447 Опубликовано 23 марта, 2012 Жалоба Share Опубликовано 23 марта, 2012 Видимо, слебанький MySQL у хостинга. Можно тогда вообще отключить кто в онлайне, раз не тянет. Ссылка на сообщение Поделиться на другие сайты
Анна Сайфулина 0 Опубликовано 23 марта, 2012 Автор Жалоба Share Опубликовано 23 марта, 2012 Видимо, слебанький MySQL у хостинга. Можно тогда вообще отключить кто в онлайне, раз не тянет. Проблема появилась пару дней назад. До этого все нормально было. Ошибка возникает не только при обращении к странице кто в онлайне. MYSQL ERROR REPORT - 23/03/2012 20:03:41 --------------------------------------- 2006 - MySQL server has gone away select categories_url from categories where categories_id="23" --------------------------------------- Server Name : golant.ru Remote Address: 195.230.109.227 Referer : http://yandex.ru/yandsearch?text=%D1%87%D0%B8%D1%81%D1%82%D0%BE+%D1%87%D0%B5%D1%80%D0%BD%D1%8B%D0%B5+%D1%84%D1%83%D1%82%D0%B1%D0%BE%D0%BB%D0%BA%D0%B8&clid=9403&lr=10664 Requested : /index.php?cat=23 Trace Back : redirector.php:282(includearray(1) {; [0]=>; string(44) "index.php"; }; ) => index.php:33(requirearray(1) {; [0]=>; string(66) "templates/xtc5/source/boxes.php"; }; ) => templates/xtc5/source/boxes.php:65(includearray(1) {; [0]=>; string(77) "templates/xtc5/source/boxes/currencies.php"; }; ) => templates/xtc5/source/boxes/currencies.php:29(vam_href_linkarray(3) {; [0]=>; &string(9) "index.php"; [1]=>; &string(20) "currency=RUR&cat=23&"; [2]=>; &string(6) "NONSSL"; }; ) => inc/vam_href_link.inc.php:89(vamDBqueryarray(1) {; [0]=>; &string(62) "select categories_url from categories where categories_id="23""; }; ) => includes/application_top.php:202(vam_db_queryarray(1) {; [0]=>; &string(62) "select categories_url from categories where categories_id="23""; }; ) => inc/vam_db_query.inc.php:35(vam_db_errorarray(3) {; [0]=>; &string(62) "select categories_url from categories where categories_id="23""; [1]=>; &int(2006); [2]=! >; &string(26) "MySQL server has gone away"; }; ) [/CODE] [CODE] MYSQL ERROR REPORT - 23/03/2012 20:03:03 --------------------------------------- 2006 - MySQL server has gone away select distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_price from products p, products_description pd, products_to_categories p2c, categories c where p.products_status=1 and p.products_id = p2c.products_id and pd.products_id = p.products_id and p.products_id !='0' and pd.language_id = '1' and c.categories_id = p2c.categories_id and c.categories_status=1 order by p.products_date_added desc limit 10 --------------------------------------- Server Name : golant.ru Remote Address: 77.88.29.248 Referer : Requested : /remont-telefona.html Trace Back : manager.php:110(includearray(1) {; [0]=>; string(51) "article_info.php"; }; ) => article_info.php:29(requirearray(1) {; [0]=>; string(66) "templates/xtc5/source/boxes.php"; }; ) => templates/xtc5/source/boxes.php:33(requirearray(1) {; [0]=>; string(76) "templates/xtc5/source/boxes/whats_new.php"; }; ) => templates/xtc5/source/boxes/whats_new.php:59(vam_random_selectarray(1) {; [0]=>; &string(1304) "select distinct; p.products_id,; pd.products_name,; p.products_image,; p.products_tax_class_id,; p.products_vpe,; p.products_vpe_status,; p.products_vpe_value,; p.products_price; from products! p, products_description pd, products_to_categories p2c, categories c; where p.products_status=1; and p.products_id = p2c.products_id; and pd.products_id = p.products_id; and p.products_id !='0'; and pd.language_id = '1'; and c.categories_id = p2c.categories_id; ; ; and c.categories_status=1 order by; p.products_date_added desc limit 10"; }; ) => inc/vam_random_select.inc.php:22(vam_db_queryarray(1) {; [0]=>; &string(1304) "select distinct; p.products_id,; pd.prod! ucts_name,; p.produ! cts_imag e,; p.products_tax_class_id,; p.products_vpe,; p.products_vpe_status,; p.products_vpe_value,; p.products_price; from products p, products_description pd, products_to_categories p2c, categories c; where p.products_status=1; and p.products_id = p2c.products_id; and pd.products_id = p.products_id; and p.products_id !='0'; and pd.language_id = '1'; and c.categories_id = p2c.categories_id; ; ; ! and c.categories_status=1 order by; p.products_date_added desc limit 10"; }; ) => inc/vam_db_query.inc.php:35(vam_db_errorarray(3) {; [0]=>; &string(1304) "select distinct; p.products_id,; pd.products_name,; p.products_image,; p.products_tax_class_id,; p.products_vpe,; p.products_vpe_status,; p.products_vpe_value,; p.products_price; from products p, products_description pd, products_to_categories p2c, categories c; where p.products_status=1; and p.products_id = p2! c.products_id; and ! pd.produ cts_id = p.products_id; and p.products_id !='0'; and pd.language_id = '1'; and c.categories_id = p2c.categories_id; ; ; and c.categories_status=1 order by; p.products_date_added desc limit 10"; [1]=>; &int(2006); [2]=>; &string(26) "MySQL server has gone away"; }; ) MYSQL ERROR REPORT - 23/03/2012 19:03:06 --------------------------------------- 2006 - MySQL server has gone away select distinct p.products_id, p.products_fsk18, p.products_price, p.products_tax_class_id, p.products_image, p.products_vpe, p.products_vpe_status, p.products_vpe_value, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and c.categories_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '26' in (c.categories_id, c.parent_id) order by p.products_ordered desc limit 5 --------------------------------------- Server Name : golant.ru Remote Address: 178.204.134.58 Referer : http://go.mail.ru/search?mailru=1&q=%D0%B4%D0%B5%D1%82%D1%81%D0%BA%D0%B8%D0%B5+%D1%84%D1%83%D1%82%D0%B1%D0%BE%D0%BB%D0%BA%D0%B8+%D1%81+%D0%BF%D1%80%D0%B8%D0%BA%D0%BE%D0%BB%D1%8C%D0%BD%D1%8B%D0%BC%D0%B8+%D0%BD%D0%B0%D0%B4%D0%BF%D0%B8%D1%81%D1%8F%D0%BC%D0%B8&us=16 Requested : /baby.html Trace Back : manager.php:54(includearray(1) {; [0]=>; string(44) "index.php"; }; ) => index.php:33(requirearray(1) {; [0]=>; string(66) "templates/xtc5/source/boxes.php"; }; ) => templates/xtc5/source/boxes.php:50(includearray(1) {; [0]=>; string(79) "templates/xtc5/source/boxes/best_sellers.php"; }; ) => templates/xtc5/source/boxes/best_sellers.php:95(vamDBqueryarray(1) {; [0]=>; &string(1400) "select distinct ; p.products_id, ; p.products_fsk18, p.products_price, ; p.products_tax_class_id, ; p.products_image, ; p.products_vpe, ; p.products_vpe_status, ; p.products_vpe_value, ; pd.products_name from products p,! products_description pd, products_to_categories p2c, categories c ; where p.products_status = '1' ; and c.categories_status = '1' ; and p.products_ordered > 0 ; and p.products_id = pd.products_id ; and pd.language_id = '1' ; and p.products_id = p2c.products_id ; ; ; and p2c.categories_id = c.categories_id and '26' ; in (c.categories_id, c.parent_id) ; order by p.products_ordered desc limit 5"; }; ) => includes/application_top.php:202(vam_db_queryarray(1) {; [0]=>; &string(1400) "select distinct ; ! p.products_id, ; ! p.products_fsk18, p.products_price, ; p.products_tax_class_id, ; p.products_image, ; p.products_vpe, ; p.products_vpe_status, ; p.products_vpe_value, ; pd.products_name from products p, products_description pd, products_to_categories p2c, categories c ; where p.products_status = '1' ; and c.categories_status = '1' ; and p.products_ordered > 0 ; and p.products_id = pd.products_id ; and pd.language_id = '1' ; and p.products_id = p2c.products_id ; ! ; ; and p2c.categories_id = c.categories_id and '26' ; in (c.categories_id, c.parent_id) ; order by p.products_ordered desc limit 5"; }; ) => inc/vam_db_query.inc.php:35(vam_db_errorarray(3) {; [0]=>; &string(1400) "select distinct ; p.products_id, ; p.products_fsk18, p.products_price, ; p.products_tax_class_id, ; p.products_image, ; p.products_vpe, ; p.products_vpe_status, ; p.products_vpe_value, ; pd.products_name from products p, products_desc! ription pd, products_to_categories p2c, categories c ; ! where p.products_status = '1' ; and c.categories_status = '1' ; and p.products_ordered > 0 ; and p.products_id = pd.products_id ; and pd.language_id = '1' ; and p.products_id = p2c.products_id ; ; ; and p2c.categories_id = c.categories_id and '26' ; in (c.categories_id, c.parent_id) ; order by p.products_ordered desc limit 5"; [1]=>; &int(2006); [2]=>; &string(26) "MySQL server has gone away"; }; ) [/code] [CODE] MYSQL ERROR REPORT - 23/03/2012 16:03:44 --------------------------------------- 2006 - MySQL server has gone away SELECT * FROM customers_status WHERE customers_status_id = '1' AND language_id = '1' --------------------------------------- Server Name : golant.ru Remote Address: 93.90.225.184 Referer : http://golant.ru/index.php?cat=24 Requested : /wp.html Trace Back : manager.php:54(includearray(1) {; [0]=>; string(44) "index.php"; }; ) => index.php:26(includearray(1) {; [0]=>; string(63) "includes/application_top.php"; }; ) => includes/application_top.php:405(requirearray(1) {; [0]=>; string(70) "includes/write_customers_status.php"; }; ) => includes/write_customers_status.php:67(vam_db_queryarray(1) {; [0]=>; &string(316) "SELECT; *; FROM; customers_status; WHERE; customers_status_id = '1' AND language_id = '1'"; }; ) => inc/vam_db_query.inc.php:35(vam_db_errorarray(3) {; [0]=>; &string(316) "SELECT; *; FROM; customers_status; ! WHERE; customers_status_id = '1' AND language_id = '1'"; [1]=>; &int(2006); [2]=>; &string(26) "MySQL server has gone away"; }; ) Ссылка на сообщение Поделиться на другие сайты
support 447 Опубликовано 24 марта, 2012 Жалоба Share Опубликовано 24 марта, 2012 Попробуйте в phpMyAdmin почистить таблицу sessions Ссылка на сообщение Поделиться на другие сайты
Анна Сайфулина 0 Опубликовано 24 марта, 2012 Автор Жалоба Share Опубликовано 24 марта, 2012 Попробуйте в phpMyAdmin почистить таблицу sessions Не помогло. Параметры MySQL какие должны быть? Ссылка на сообщение Поделиться на другие сайты
support 447 Опубликовано 24 марта, 2012 Жалоба Share Опубликовано 24 марта, 2012 Тога наверное кроме как нормальнго хостера найти ничего особо и не посоветуешь. Либо вообще убрать кто в онлайне. Ссылка на сообщение Поделиться на другие сайты
Рекомендуемые сообщения