Mysql overload
Re: Mysql overload
I didnt investigate deeply into the problem, but just switching off sphinx, the load slides to almost none on my mysql server.
Re: Mysql overload
I have check the mysql log and seems like there are many open connections using mysql_pconnect() from smartcj scripts, but I cannot tell which part of the software is not closing its connection. causing it to hit the max connections. please take a look.
------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+----------------+--------------------+----------------+---------+------+----------------+--------------------------------------------------------------------------------------------------+
| 378887 | database_fsp | localhost | database_fsp | Sleep | 83 | | |
| 379128 | database_fwp | localhost | database_fwp | Sleep | 117 | | |
| 379129 | database_fsp | localhost | database_fsp | Sleep | 117 | | |
| 379285 | database_fwp | localhost | database_fwp | Sleep | 90 | | |
| 379286 | database_fsp | localhost | database_fsp | Sleep | 90 | | |
| 379406 | database_fwp | localhost | database_fwp | Sleep | 67 | | |
| 379409 | database_fsp | localhost | database_fsp | Sleep | 67 | | |
| 379534 | database_ptell | localhost | database_ptell | Sleep | 40 | | |
| 379555 | database_fwp | localhost | database_fwp | Sleep | 36 | | |
| 379556 | database_fsp | localhost | database_fsp | Sleep | 36 | |
------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+----------------+--------------------+----------------+---------+------+----------------+--------------------------------------------------------------------------------------------------+
| 378887 | database_fsp | localhost | database_fsp | Sleep | 83 | | |
| 379128 | database_fwp | localhost | database_fwp | Sleep | 117 | | |
| 379129 | database_fsp | localhost | database_fsp | Sleep | 117 | | |
| 379285 | database_fwp | localhost | database_fwp | Sleep | 90 | | |
| 379286 | database_fsp | localhost | database_fsp | Sleep | 90 | | |
| 379406 | database_fwp | localhost | database_fwp | Sleep | 67 | | |
| 379409 | database_fsp | localhost | database_fsp | Sleep | 67 | | |
| 379534 | database_ptell | localhost | database_ptell | Sleep | 40 | | |
| 379555 | database_fwp | localhost | database_fwp | Sleep | 36 | | |
| 379556 | database_fsp | localhost | database_fsp | Sleep | 36 | |
Re: Mysql overload
When I use sphinx and importing galleries it crash server and here is the error from error.log.
21.47 select sum(hc_url0 + hc_url1 + hc_url2 + hc_url3 + hc_url4 + hc_url5 + hc_url6
+ hc_url7 + hc_url8 + hc_url9 + hc_url10 + hc_url11 + hc_url12 + hc_url13 + hc_url14 + hc_url15
+ hc_url16 + hc_url17 + hc_url18 + hc_url19 + hc_url20 + hc_url21 + hc_url22 + hc_url23
+ hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7
+ hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15
+ hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as total_clicks
from day WHERE h != 'spiders':: :
21.47 select sum(hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7
+ hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15
+ hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as total_clicks
from day WHERE h != 'spiders':: :
21.47 select *, IF( tp != '-2', 0, 1 ) AS limited from traders
where ta != 5 and td != 'new_trader' order by limited asc, tp desc:: :
21.47 UPDATE settings SET value = '1377380873' WHERE name = 'cron_running' :: :
21.47 select *, IF( tp != '-2', 0, 1 ) AS limited from traders
where ta != 5 and td != 'new_trader' order by limited asc, tp desc:: :
21.47 SELECT ts.cookie_lifetime, ts.aggregation_type, tr.* FROM tds_rules as tr
LEFT JOIN tds_schemes as ts on ts.tds_id = tr.tds_id
WHERE tr.status = 1
ORDER BY order_id:: :
21.47 SELECT ts.cookie_lifetime, ts.aggregation_type, tr.* FROM tds_rules as tr
LEFT JOIN tds_schemes as ts on ts.tds_id = tr.tds_id
WHERE tr.status = 1
ORDER BY order_id:: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 SELECT ts.cookie_lifetime, ts.aggregation_type, tr.* FROM tds_rules as tr
LEFT JOIN tds_schemes as ts on ts.tds_id = tr.tds_id
WHERE tr.status = 1
ORDER BY order_id:: :
21.47 UPDATE settings SET value = '1377380874' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '1377380874' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '1377380874' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '1377380875' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.48 SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380895 LIMIT 0, 1:: :
21.48 SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15:: :
21.48 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
21.48 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.48 SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380912 LIMIT 0, 1:: :
21.48 SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15:: :
21.48 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
21.48 INSERT into rot_page_items
SET page_id = '6', page_crc = '1308243443248955', items = '787837|604926|649668|326095|456680|372214|372063|741469|410842|206550|371772|31379|486867|216859|444132|617570|583673|458465|774580|201095|849341|598069|634353|201885|471324|127874|93003|555624|378665|543123|868058|18664|448360|347544|398919|381914|816617|620254|449380|639893|648957|8503|577122|567118|211068|228213|405298|455579|192944|284317|724396|413388|738671|733943|774322|188203|414730|779547|540626|796069|182473|65949|554537|193585|393665|183374|200680|130869|722454|377064|653547|188326|182758|542558|724239|214128|741498|759476|388912|855282|445659|166585|638310|424543|544102|193162|286985|541653|618480|194872|771278|521135|742494|602586|741458|216536|707158|448138|348948', date = '2013-08-24'
ON DUPLICATE KEY UPDATE items = '787837|604926|649668|326095|456680|372214|372063|741469|410842|206550|371772|31379|486867|216859|444132|617570|583673|458465|774580|201095|849341|598069|634353|201885|471324|127874|93003|555624|378665|543123|868058|18664|448360|347544|398919|381914|816617|620254|449380|639893|648957|8503|577122|567118|211068|228213|405298|455579|192944|284317|724396|413388|738671|733943|774322|188203|414730|779547|540626|796069|182473|65949|554537|193585|393665|183374|200680|130869|722454|377064|653547|188326|182758|542558|724239|214128|741498|759476|388912|855282|445659|166585|638310|424543|544102|193162|286985|541653|618480|194872|771278|521135|742494|602586|741458|216536|707158|448138|348948', date = '2013-08-24' :: :
21.48 INSERT into rot_page_items
SET page_id = '6', page_crc = '130824136977370', items = '787837|604926|649668|326095|456680|372214|372063|741469|410842|206550|371772|31379|398919|486867|216859|444132|617570|583673|458465|774580|286985|201095|849341|598069|634353|201885|471324|127874|93003|555624|378665|543123|868058|18664|448360|347544|381914|638310|816617|449380|377064|639893|771278|648957|8503|759476|577122|567118|228213|405298|455579|192944|284317|724396|413388|738671|733943|774322|200680|188203|620254|414730|742494|779547|796069|182473|653547|65949|554537|724239|193585|393665|183374|130869|722454|188326|182758|542558|214128|741498|388912|855282|445659|166585|424543|544102|193162|541653|618480|194872|521135|602586|741458|216536|707158|448138|348948|211068|540626', date = '2013-08-24'
ON DUPLICATE KEY UPDATE items = '787837|604926|649668|326095|456680|372214|372063|741469|410842|206550|371772|31379|398919|486867|216859|444132|617570|583673|458465|774580|286985|201095|849341|598069|634353|201885|471324|127874|93003|555624|378665|543123|868058|18664|448360|347544|381914|638310|816617|449380|377064|639893|771278|648957|8503|759476|577122|567118|228213|405298|455579|192944|284317|724396|413388|738671|733943|774322|200680|188203|620254|414730|742494|779547|796069|182473|653547|65949|554537|724239|193585|393665|183374|130869|722454|188326|182758|542558|214128|741498|388912|855282|445659|166585|424543|544102|193162|541653|618480|194872|521135|602586|741458|216536|707158|448138|348948|211068|540626', date = '2013-08-24' :: :
21.48 SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380920 LIMIT 0, 1:: :
21.48 SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15:: :
21.48 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
21.48 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.48 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.49 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.49 UPDATE functions_data SET value = '1377381372' WHERE name = 'check_db':: :
21.49 select g.id, s.thumb_id from rot_galleries as g
left join rot_gallery_stats as s ON g.id = s.thumb_id
where isnull(s.thumb_id):: :
21.49 UPDATE functions_data SET value = '1377381305' WHERE name = 'process_deleted':: :
21.49 SELECT SQL_CALC_FOUND_ROWS id, gallery_md5 FROM rot_galleries WHERE status = 12 LIMIT 0, 1:: :
21.49 SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380974 LIMIT 0, 1:: :
21.49 SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15:: :
21.49 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
21.49 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
errror from mysqlerror.log
2013-08-24 21:47:28 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377382397' WHERE name = 'set_model_cache'
2013-08-24 21:47:28 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:29 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_models ORDER BY model_name
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT url, id, g.gallery_md5, tags, thumb_url, gs.total_ctr as thumb_ctr FROM rot_galleries as g
JOIN rot_gallery_stats AS gs ON gs.thumb_id = g.id
JOIN rot_gallery_info AS gi ON gi.gallery_md5 = g.gallery_md5
WHERE g.rgroup = 0 and g.sponsor_id = 1 and gi.source_url = ''
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT model_id, SUM( gs.total_ctr)/count(g.gallery_md5) AS total_ctr
FROM rot_gal2model AS m
LEFT JOIN rot_galleries AS g ON g.gallery_md5 = m.gallery_md5
LEFT JOIN rot_gallery_stats AS gs ON gs.thumb_id = g.id
WHERE g.status = 1 and gs.total_shows > 100
group by model_id
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:32 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:31 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:32 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:33 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:34 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:33 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:35 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:35 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:34 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT SQL_CALC_FOUND_ROWS id, gallery_md5 FROM rot_galleries WHERE status = 12 LIMIT 0, 1
2013-08-24 21:47:36 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:36 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:36 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:36 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:38 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:37 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT url, id, gallery_slug, gi.gallery_md5, tags, gs.total_ctr as thumb_ctr FROM rot_galleries as g
LEFT JOIN rot_gallery_stats AS gs ON gs.thumb_id = g.id
LEFT JOIN rot_gallery_info AS gi ON gi.gallery_md5 = g.gallery_md5
LEFT JOIN rot_gallery_data AS gd ON gd.gallery_md5 = g.gallery_md5
WHERE g.rgroup = 0 and g.sponsor_id = 1 and gi.source_url = ''
2013-08-24 21:47:39 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:39 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:39 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:40 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:42 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:43 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:43 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:44 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:46 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:46 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377381570' WHERE name = 'check_db'
2013-08-24 21:47:47 : Mysql error: 2006 (MySQL server has gone away) in query select g.id, s.thumb_id from rot_galleries as g
left join rot_gallery_stats as s ON g.id = s.thumb_id
where isnull(s.thumb_id)
2013-08-24 21:47:47 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377381229' WHERE name = 'process_deleted'
2013-08-24 21:47:48 : Mysql error: 2006 (MySQL server has gone away) in query SELECT SQL_CALC_FOUND_ROWS id, gallery_md5 FROM rot_galleries WHERE status = 12 LIMIT 0, 1
2013-08-24 21:47:49 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:57 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:48:15 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380895 LIMIT 0, 1
2013-08-24 21:48:16 : Mysql error: 2006 (MySQL server has gone away) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:48:16 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:48:18 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:48:32 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380912 LIMIT 0, 1
2013-08-24 21:48:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:48:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:48:40 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380920 LIMIT 0, 1
2013-08-24 21:48:40 : Mysql error: 2006 (MySQL server has gone away) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:48:40 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:48:40 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:48:42 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:49:31 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:49:32 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377381372' WHERE name = 'check_db'
2013-08-24 21:49:32 : Mysql error: 2006 (MySQL server has gone away) in query select g.id, s.thumb_id from rot_galleries as g
left join rot_gallery_stats as s ON g.id = s.thumb_id
where isnull(s.thumb_id)
2013-08-24 21:49:32 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377381305' WHERE name = 'process_deleted'
2013-08-24 21:49:32 : Mysql error: 2006 (MySQL server has gone away) in query SELECT SQL_CALC_FOUND_ROWS id, gallery_md5 FROM rot_galleries WHERE status = 12 LIMIT 0, 1
2013-08-24 21:49:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380974 LIMIT 0, 1
2013-08-24 21:49:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:49:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:49:35 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
and when I switch off sphinx while importing galleries everything works fine and mysql is ok.
I am not sure if its something relate to scj_index, but I turn off the cron and didn't reindex sphinx while running import so I think there shouldn't be any conflicts, but again, its sphinx which cost the crash, so maybe u can take a look
21.47 select sum(hc_url0 + hc_url1 + hc_url2 + hc_url3 + hc_url4 + hc_url5 + hc_url6
+ hc_url7 + hc_url8 + hc_url9 + hc_url10 + hc_url11 + hc_url12 + hc_url13 + hc_url14 + hc_url15
+ hc_url16 + hc_url17 + hc_url18 + hc_url19 + hc_url20 + hc_url21 + hc_url22 + hc_url23
+ hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7
+ hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15
+ hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as total_clicks
from day WHERE h != 'spiders':: :
21.47 select sum(hc_trade0 + hc_trade1 + hc_trade2 + hc_trade3 + hc_trade4 + hc_trade5 + hc_trade6 + hc_trade7
+ hc_trade8 + hc_trade9 + hc_trade10 + hc_trade11 + hc_trade12 + hc_trade13 + hc_trade14 + hc_trade15
+ hc_trade16 + hc_trade17 + hc_trade18 + hc_trade19 + hc_trade20 + hc_trade21 + hc_trade22 + hc_trade23) as total_clicks
from day WHERE h != 'spiders':: :
21.47 select *, IF( tp != '-2', 0, 1 ) AS limited from traders
where ta != 5 and td != 'new_trader' order by limited asc, tp desc:: :
21.47 UPDATE settings SET value = '1377380873' WHERE name = 'cron_running' :: :
21.47 select *, IF( tp != '-2', 0, 1 ) AS limited from traders
where ta != 5 and td != 'new_trader' order by limited asc, tp desc:: :
21.47 SELECT ts.cookie_lifetime, ts.aggregation_type, tr.* FROM tds_rules as tr
LEFT JOIN tds_schemes as ts on ts.tds_id = tr.tds_id
WHERE tr.status = 1
ORDER BY order_id:: :
21.47 SELECT ts.cookie_lifetime, ts.aggregation_type, tr.* FROM tds_rules as tr
LEFT JOIN tds_schemes as ts on ts.tds_id = tr.tds_id
WHERE tr.status = 1
ORDER BY order_id:: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 SELECT ts.cookie_lifetime, ts.aggregation_type, tr.* FROM tds_rules as tr
LEFT JOIN tds_schemes as ts on ts.tds_id = tr.tds_id
WHERE tr.status = 1
ORDER BY order_id:: :
21.47 UPDATE settings SET value = '1377380874' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '1377380874' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '1377380874' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '1377380875' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE settings SET value = '0' WHERE name = 'cron_running' :: :
21.47 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.48 SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380895 LIMIT 0, 1:: :
21.48 SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15:: :
21.48 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
21.48 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.48 SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380912 LIMIT 0, 1:: :
21.48 SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15:: :
21.48 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
21.48 INSERT into rot_page_items
SET page_id = '6', page_crc = '1308243443248955', items = '787837|604926|649668|326095|456680|372214|372063|741469|410842|206550|371772|31379|486867|216859|444132|617570|583673|458465|774580|201095|849341|598069|634353|201885|471324|127874|93003|555624|378665|543123|868058|18664|448360|347544|398919|381914|816617|620254|449380|639893|648957|8503|577122|567118|211068|228213|405298|455579|192944|284317|724396|413388|738671|733943|774322|188203|414730|779547|540626|796069|182473|65949|554537|193585|393665|183374|200680|130869|722454|377064|653547|188326|182758|542558|724239|214128|741498|759476|388912|855282|445659|166585|638310|424543|544102|193162|286985|541653|618480|194872|771278|521135|742494|602586|741458|216536|707158|448138|348948', date = '2013-08-24'
ON DUPLICATE KEY UPDATE items = '787837|604926|649668|326095|456680|372214|372063|741469|410842|206550|371772|31379|486867|216859|444132|617570|583673|458465|774580|201095|849341|598069|634353|201885|471324|127874|93003|555624|378665|543123|868058|18664|448360|347544|398919|381914|816617|620254|449380|639893|648957|8503|577122|567118|211068|228213|405298|455579|192944|284317|724396|413388|738671|733943|774322|188203|414730|779547|540626|796069|182473|65949|554537|193585|393665|183374|200680|130869|722454|377064|653547|188326|182758|542558|724239|214128|741498|759476|388912|855282|445659|166585|638310|424543|544102|193162|286985|541653|618480|194872|771278|521135|742494|602586|741458|216536|707158|448138|348948', date = '2013-08-24' :: :
21.48 INSERT into rot_page_items
SET page_id = '6', page_crc = '130824136977370', items = '787837|604926|649668|326095|456680|372214|372063|741469|410842|206550|371772|31379|398919|486867|216859|444132|617570|583673|458465|774580|286985|201095|849341|598069|634353|201885|471324|127874|93003|555624|378665|543123|868058|18664|448360|347544|381914|638310|816617|449380|377064|639893|771278|648957|8503|759476|577122|567118|228213|405298|455579|192944|284317|724396|413388|738671|733943|774322|200680|188203|620254|414730|742494|779547|796069|182473|653547|65949|554537|724239|193585|393665|183374|130869|722454|188326|182758|542558|214128|741498|388912|855282|445659|166585|424543|544102|193162|541653|618480|194872|521135|602586|741458|216536|707158|448138|348948|211068|540626', date = '2013-08-24'
ON DUPLICATE KEY UPDATE items = '787837|604926|649668|326095|456680|372214|372063|741469|410842|206550|371772|31379|398919|486867|216859|444132|617570|583673|458465|774580|286985|201095|849341|598069|634353|201885|471324|127874|93003|555624|378665|543123|868058|18664|448360|347544|381914|638310|816617|449380|377064|639893|771278|648957|8503|759476|577122|567118|228213|405298|455579|192944|284317|724396|413388|738671|733943|774322|200680|188203|620254|414730|742494|779547|796069|182473|653547|65949|554537|724239|193585|393665|183374|130869|722454|188326|182758|542558|214128|741498|388912|855282|445659|166585|424543|544102|193162|541653|618480|194872|521135|602586|741458|216536|707158|448138|348948|211068|540626', date = '2013-08-24' :: :
21.48 SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380920 LIMIT 0, 1:: :
21.48 SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15:: :
21.48 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
21.48 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.48 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.49 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
21.49 UPDATE functions_data SET value = '1377381372' WHERE name = 'check_db':: :
21.49 select g.id, s.thumb_id from rot_galleries as g
left join rot_gallery_stats as s ON g.id = s.thumb_id
where isnull(s.thumb_id):: :
21.49 UPDATE functions_data SET value = '1377381305' WHERE name = 'process_deleted':: :
21.49 SELECT SQL_CALC_FOUND_ROWS id, gallery_md5 FROM rot_galleries WHERE status = 12 LIMIT 0, 1:: :
21.49 SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380974 LIMIT 0, 1:: :
21.49 SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15:: :
21.49 SELECT count(*) FROM rot_content WHERE status = 'to_grab' :: :
21.49 UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running' :: :
errror from mysqlerror.log
2013-08-24 21:47:28 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377382397' WHERE name = 'set_model_cache'
2013-08-24 21:47:28 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:29 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_models ORDER BY model_name
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT url, id, g.gallery_md5, tags, thumb_url, gs.total_ctr as thumb_ctr FROM rot_galleries as g
JOIN rot_gallery_stats AS gs ON gs.thumb_id = g.id
JOIN rot_gallery_info AS gi ON gi.gallery_md5 = g.gallery_md5
WHERE g.rgroup = 0 and g.sponsor_id = 1 and gi.source_url = ''
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT model_id, SUM( gs.total_ctr)/count(g.gallery_md5) AS total_ctr
FROM rot_gal2model AS m
LEFT JOIN rot_galleries AS g ON g.gallery_md5 = m.gallery_md5
LEFT JOIN rot_gallery_stats AS gs ON gs.thumb_id = g.id
WHERE g.status = 1 and gs.total_shows > 100
group by model_id
2013-08-24 21:47:31 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:32 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:31 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:32 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:33 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:34 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:33 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:35 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:35 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:34 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT SQL_CALC_FOUND_ROWS id, gallery_md5 FROM rot_galleries WHERE status = 12 LIMIT 0, 1
2013-08-24 21:47:36 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:36 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:36 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:36 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:47:38 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:37 : Mysql error: 2013 (Lost connection to MySQL server during query) in query SELECT url, id, gallery_slug, gi.gallery_md5, tags, gs.total_ctr as thumb_ctr FROM rot_galleries as g
LEFT JOIN rot_gallery_stats AS gs ON gs.thumb_id = g.id
LEFT JOIN rot_gallery_info AS gi ON gi.gallery_md5 = g.gallery_md5
LEFT JOIN rot_gallery_data AS gd ON gd.gallery_md5 = g.gallery_md5
WHERE g.rgroup = 0 and g.sponsor_id = 1 and gi.source_url = ''
2013-08-24 21:47:39 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:39 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:39 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:40 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:42 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:43 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:43 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:47:44 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:46 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:46 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377381570' WHERE name = 'check_db'
2013-08-24 21:47:47 : Mysql error: 2006 (MySQL server has gone away) in query select g.id, s.thumb_id from rot_galleries as g
left join rot_gallery_stats as s ON g.id = s.thumb_id
where isnull(s.thumb_id)
2013-08-24 21:47:47 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377381229' WHERE name = 'process_deleted'
2013-08-24 21:47:48 : Mysql error: 2006 (MySQL server has gone away) in query SELECT SQL_CALC_FOUND_ROWS id, gallery_md5 FROM rot_galleries WHERE status = 12 LIMIT 0, 1
2013-08-24 21:47:49 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:47:57 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:48:15 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380895 LIMIT 0, 1
2013-08-24 21:48:16 : Mysql error: 2006 (MySQL server has gone away) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:48:16 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:48:18 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:48:32 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380912 LIMIT 0, 1
2013-08-24 21:48:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:48:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:48:40 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380920 LIMIT 0, 1
2013-08-24 21:48:40 : Mysql error: 2006 (MySQL server has gone away) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:48:40 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:48:40 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:48:42 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:49:31 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
2013-08-24 21:49:32 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377381372' WHERE name = 'check_db'
2013-08-24 21:49:32 : Mysql error: 2006 (MySQL server has gone away) in query select g.id, s.thumb_id from rot_galleries as g
left join rot_gallery_stats as s ON g.id = s.thumb_id
where isnull(s.thumb_id)
2013-08-24 21:49:32 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE functions_data SET value = '1377381305' WHERE name = 'process_deleted'
2013-08-24 21:49:32 : Mysql error: 2006 (MySQL server has gone away) in query SELECT SQL_CALC_FOUND_ROWS id, gallery_md5 FROM rot_galleries WHERE status = 12 LIMIT 0, 1
2013-08-24 21:49:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT * FROM rot_import_sets WHERE status = 1 and period != 0 and next_grab < 1377380974 LIMIT 0, 1
2013-08-24 21:49:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT id FROM rot_galleries WHERE status = 4 OR status = 14
ORDER BY priority
LIMIT 0, 15
2013-08-24 21:49:34 : Mysql error: 2006 (MySQL server has gone away) in query SELECT count(*) FROM rot_content WHERE status = 'to_grab'
2013-08-24 21:49:35 : Mysql error: 2006 (MySQL server has gone away) in query UPDATE rot_settings SET value = '0' WHERE name = 'rot_cron_running'
and when I switch off sphinx while importing galleries everything works fine and mysql is ok.
I am not sure if its something relate to scj_index, but I turn off the cron and didn't reindex sphinx while running import so I think there shouldn't be any conflicts, but again, its sphinx which cost the crash, so maybe u can take a look
Re: Mysql overload
I guess it takes sometime to create index for sphinx
Don't forget to run script update