我的网店流量大,后台操作有时间出现这样的问题

2016-07-07 15:20 来源:www.chinab4c.com 作者:ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => UPDATE `took2008`.`took_sessions` SET expiry = '1227319581', ip = '216.72.20.218', userid = '0', adminid = '1', user_name='0', user_rank='0', discount='0', email='0', data = 'a:3:{s:10:\"admin_name\";s:4:\"tozj\";s:11:\"action_list\";s:3:\"all\";s:10:\"last_check\";s:0:\"\";}' WHERE sesskey = 'b5fed98de02b980c0148d7be8839a4e3' LIMIT 1 ) [2] => Array ( [error] => MySQL server has gone away ) [3] => Array ( [errno] => 2006 ) )

请问怎么回事,took_sessions 这个缓存表还是有问题吧。我已经多次更换此表,还是频频出现此问题,而且速度很慢,但是第一出现后,后面就不会出现了。

回答:
我今天也遇到了这个问题,不知道怎么回事MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT COUNT(*) AS access_count, area FROM `sq_3535993`.`hx_stats` WHERE access_time >= '1230624000' AND access_time < 1231315200 GROUP BY area ORDER BY access_count DESC LIMIT 20 ) [2] => Array ( [error] => Table 'hx_stats' is marked as crashed and should be repaired ) [3] => Array ( [errno] => 1194 ) )

这不是流量问题,是服务器问题。缓存清空一下,以及数据表优化一下。




服务器什么问题呢?请问该怎么解决?