问:系统负载:4.66 4.66 3.90内存使用:总:5853M 已用: 2857M 剩余:2996M负载如上,为何数据库读写已经出了问题?,网站数据库使用异常,访问缓慢
问:另外想知道一下,按现在的配置大概的并发可以承受多少?
问:而且好像还不只是数据库的问题,当时去看日志的时候也看不了,传输文件也受到了限制
答:您好,
1. 从目前来看, 您系统的cpu及内存等负载正常. 磁盘读写也是正常的, 之前有段时间带宽超标的情况, 现在带宽已经回落, 之前应该只是突发情况; 目前带宽还有一些超标;2. 若是您某个站点正在进行活动, 那么请临时升级一下服务器的带宽到10M后再观察看看; 且若还是会出现负载高达3.5以上,请及时升级CPU; 当带宽超标时, 您与服务器之间传输文件便会非常慢; 请知悉.非常感谢您长期对我司的支持!
问:数据库启动异常,网站出现问题
答:您好,已启动并设置为开机自启动.请访问查看,非常感谢您长期对我司的支持!
问:谢谢
答:您好,不客气,如果有其他问题请再反馈,非常感谢您长期对我司的支持!
问:网站访问非常缓慢 , 域名是: http://www.geshow.com , 有时候直接无法打开 , 同时数据库访问也非常缓慢 , 打开和操作表都很卡 , 望尽快排查处理 , 在线等
答:您好,查看是mysql数据库占用cpu较多资源导致卡顿,您可联系程序提供商优化下程序和数据库,优化后再访问测试下,非常感谢您长期对我司的支持!
问:数据库和代码都没有动过 , 只是昨天你们做了服务器迁移之后网站就开始访问慢的 , 而且其中没有变好
答:您好,数据库存在大量的访问查询,并有锁表的情况,您可进入mysql使用show porcesslist即可查看mysql执行情况,非常感谢您长期对我司的支持!
Id | User | Host | db | Command | Time | State | Info | —— —— —- | 3436 | geshow | localhost | geshow | Query | 7 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 3457 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3460 | geshow | localhost | geshow | Query | 6 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3479 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3505 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3529 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3534 | geshow | localhost | geshow | Query | 6 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3568 | geshow | localhost | geshow | Query | 7 | Locked | SELECT gb.*,g.*,gb.act_id AS group_buy_id, gb.goods_id, gb.ext_info, gb.goods_name, g.goods_thumb, g || 3574 | geshow | localhost | geshow | Query | 8 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 3575 | geshow | localhost | geshow | Query | 7 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 3579 | geshow | localhost | geshow | Query | 8 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 3588 | geshow | localhost | geshow | Query | 5 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(g.goods_id) AS goods_num, IF(b.brand_logo > \’\’, || 3607 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3613 | geshow | localhost | geshow | Query | 5 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3622 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3648 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3675 | geshow | localhost | geshow | Query | 12 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3720 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3722 | geshow | localhost | geshow | Query | 12 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3726 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3734 | geshow | localhost | geshow | Query | 7 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 3742 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3747 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3764 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3765 | geshow | localhost | geshow | Query | 5 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 3779 | geshow | localhost | geshow | Query | 12 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3787 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3790 | geshow | localhost | geshow | Query | 7 | Locked | SELECT c.*,g.goods_name,g.goods_thumb,g.goods_id,c.goods_number,c.goods_price FROM `geshow`.`ecs_car || 3791 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3803 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3806 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3808 | geshow | localhost | geshow | Query | 7 | Locked | SELECT c.*,g.goods_name,g.goods_thumb,g.goods_id,c.goods_number,c.goods_price FROM `geshow`.`ecs_car || 3810 | geshow | localhost | geshow | Query | 8 | Locked | SELECT * FROM `geshow`.`ecs_goods` WHERE goods_id = \’33382\’ || 3812 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3813 | geshow | localhost | geshow | Query | 7 | Locked | SELECT c.*,g.goods_name,g.goods_thumb,g.goods_id,c.goods_number,c.goods_price FROM `geshow`.`ecs_car || 3815 | geshow | localhost | geshow | Query | 7 | Locked | UPDATE `geshow`.`ecs_goods` SET click_count = click_count 1 WHERE goods_id = \’29522\’ || 3821 | geshow | localhost | geshow | Query | 8 | Locked | UPDATE `geshow`.`ecs_goods` SET click_count = click_count 1 WHERE goods_id = \’30792\’ || 3825 | geshow | localhost | geshow | Query | 6 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3826 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3828 | geshow | localhost | geshow | Query | 5 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3829 | geshow | localhost | geshow | Query | 6 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3833 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3834 | geshow | localhost | geshow | Query | 7 | Locked | SELECT c.*,g.goods_name,g.goods_thumb,g.goods_id,c.goods_number,c.goods_price FROM `geshow`.`ecs_car || 3837 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_img,b.brand_desc,b.wap_brand_desc, COUNT(*) A || 3838 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3839 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3840 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3841 | geshow | localhost | geshow | Query | 7 | Locked | UPDATE `geshow`.`ecs_goods` SET click_count = click_count 1 WHERE goods_id = \’30423\’ || 3842 | geshow | localhost | geshow | Query | 5 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 3843 | geshow | localhost | geshow | Query | 26 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3847 | geshow | localhost | geshow | Query | 7 | Locked | SELECT c.*,g.goods_name,g.goods_thumb,g.goods_id,c.goods_number,c.goods_price FROM `geshow`.`ecs_car || 3850 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3857 | geshow | localhost | geshow | Query | 8 | Locked | SELECT * FROM `geshow`.`ecs_goods` WHERE goods_id = \’33382\’ || 3861 | geshow | localhost | geshow | Query | 5 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3863 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3864 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3866 | geshow | localhost | geshow | Query | 6 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3868 | geshow | localhost | geshow | Query | 26 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3873 | geshow | localhost | geshow | Query | 7 | Locked | SELECT gb.*,g.*,gb.act_id AS group_buy_id, gb.goods_id, gb.ext_info, gb.goods_name, g.goods_thumb, g || 3874 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3875 | geshow | localhost | geshow | Query | 26 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3879 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3881 | geshow | localhost | geshow | Query | 25 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3882 | geshow | localhost | geshow | Query | 8 | Locked | SELECT goods_id, goods_name, shop_price,market_price,goods_img,original_img, goods_thumb, salesnum , || 3884 | geshow | localhost | geshow | Query | 25 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3885 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_img,b.brand_desc,b.wap_brand_desc, COUNT(*) A || 3887 | geshow | localhost | geshow | Query | 8 | Locked | SELECT cat_id, brand_id FROM `geshow`.`ecs_goods`WHERE goods_id = \’31048\’ || 3888 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3890 | geshow | localhost | geshow | Query | 7 | Locked | UPDATE `geshow`.`ecs_goods` SET click_count = click_count 1 WHERE goods_id = \’33284\’ || 3896 | geshow | localhost | geshow | Query | 7 | Locked | SELECT gb.*,g.*,gb.act_id AS group_buy_id, gb.goods_id, gb.ext_info, gb.goods_name, g.goods_thumb, g || 3899 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3901 | geshow | localhost | geshow | Query | 5 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3902 | geshow | localhost | geshow | Query | 8 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 3903 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3904 | geshow | localhost | geshow | Query | 6 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3905 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3906 | geshow | localhost | geshow | Query | 3 | Locked | UPDATE `geshow`.`ecs_goods` SET click_count = click_count 1 WHERE goods_id = \’28749\’ || 3907 | geshow | localhost | geshow | Query | 8 | Locked | SELECT g.*, c.measure_unit, b.brand_id, b.brand_name AS goods_brand, m.type_money AS bonus_money, IF || 3910 | geshow | localhost | geshow | Query | 26 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3912 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3914 | geshow | localhost | geshow | Query | 5 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3915 | geshow | localhost | geshow | Query | 26 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3918 | geshow | localhost | geshow | Query | 25 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3919 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3921 | geshow | localhost | geshow | Query | 25 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3923 | geshow | localhost | geshow | Query | 26 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3925 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3927 | geshow | localhost | geshow | Query | 8 | Locked | SELECT goods_id FROM `geshow`.`ecs_goods` WHERE cat_id=86 AND goods_id > 32877 AND is_on_sale = 1 AN || 3929 | geshow | localhost | geshow | Query | 8 | Locked | SELECT g.goods_id, g.goods_name, g.goods_name_style,g.goods_brief, g.market_price,g.is_best,g.is_new || 3930 | geshow | localhost | geshow | Query | 8 | Locked | SELECT g.*, c.measure_unit, b.brand_id, b.brand_name AS goods_brand, m.type_money AS bonus_money, IF || 3932 | geshow | localhost | geshow | Query | 8 | Locked | SELECT g.shop_price , g.promote_price FROM `geshow`.`ecs_goods` AS g WHERE g.goods_id = \’33079\’ || 3933 | geshow | localhost | geshow | Query | 7 | Locked | SELECT cat_id, brand_id FROM `geshow`.`ecs_goods`WHERE goods_id = \’29844\’ || 3937 | geshow | localhost | geshow | Query | 8 | Locked | SELECT cat_id, brand_id FROM `geshow`.`ecs_goods`WHERE goods_id = \’31048\’ || 3942 | geshow | localhost | geshow | Query | 7 | Locked | SELECT g.goods_id, g.goods_name, g.goods_name_style,g.goods_brief, g.market_price,g.is_best,g.is_new || 3943 | geshow | localhost | geshow | Query | 6 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3945 | geshow | localhost | geshow | Query | 8 | Locked | SELECT g.goods_id, g.goods_name, g.goods_name_style,g.goods_brief, g.market_price,g.is_best,g.is_new || 3947 | geshow | localhost | geshow | Query | 8 | Locked | SELECT g.goods_id, g.goods_name, g.goods_name_style,g.goods_brief, g.market_price,g.is_best,g.is_new || 3948 | geshow | localhost | geshow | Query | 6 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3949 | geshow | localhost | geshow | Query | 26 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3954 | geshow | localhost | geshow | Query | 7 | Locked | SELECT g.goods_id, g.goods_name, g.goods_name_style,g.goods_brief, g.market_price,g.is_best,g.is_new || 3955 | geshow | localhost | geshow | Query | 6 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3956 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3957 | geshow | localhost | geshow | Query | 7 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3959 | geshow | localhost | geshow | Query | 8 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo || 3960 | geshow | localhost | geshow | Query | 7 | Locked | SELECT goods_id, goods_name, shop_price,market_price,goods_img,original_img, goods_thumb, salesnum , || 3966 | geshow | localhost | geshow | Query | 5 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3968 | geshow | localhost | geshow | Query | 7 | Locked | SELECT g.goods_id, g.goods_name, g.goods_name_style,g.goods_brief, g.market_price,g.is_best,g.is_new || 3969 | geshow | localhost | geshow | Query | 25 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3971 | geshow | localhost | geshow | Query | 8 | Locked | SELECT goods_id FROM `geshow`.`ecs_goods` WHERE cat_id=47 AND goods_id > 30804 AND is_on_sale = 1 AN || 3975 | geshow | localhost | geshow | Query | 6 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3978 | geshow | localhost | geshow | Query | 7 | Locked | UPDATE `geshow`.`ecs_goods` SET click_count = click_count 1 WHERE goods_id = \’33268\’ || 3979 | geshow | localhost | geshow | Query | 25 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 3999 | geshow | localhost | geshow | Query | 6 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4000 | geshow | localhost | geshow | Query | 29 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4003 | geshow | localhost | geshow | Query | 7 | Locked | SELECT COUNT(*) FROM `geshow`.`ecs_goods` AS g WHERE brand_id = \’63\’ AND supplier_id = \’0\’ AND g.is_ || 4008 | geshow | localhost | geshow | Query | 6 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4010 | geshow | localhost | geshow | Query | 7 | Locked | SELECT COUNT(*) FROM `geshow`.`ecs_goods` AS g WHERE brand_id = \’83\’ AND supplier_id = \’0\’ AND g.is_ || 4013 | geshow | localhost | geshow | Query | 8 | Locked | SELECT COUNT(*) FROM `geshow`.`ecs_goods` AS g WHERE brand_id = \’133\’ AND supplier_id = \’0\’ AND g.is || 4021 | geshow | localhost | geshow | Query | 8 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4024 | geshow | localhost | geshow | Query | 28 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4025 | geshow | localhost | geshow | Query | 26 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4027 | geshow | localhost | geshow | Query | 29 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4044 | geshow | localhost | geshow | Query | 25 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4046 | geshow | localhost | geshow | Query | 8 | Locked | SELECT goods_id, goods_name,goods_name_style,goods_brief, shop_price,market_price, goods_thumb,sales || 4048 | geshow | localhost | geshow | Query | 8 | Locked | SELECT cat_id, brand_id FROM `geshow`.`ecs_goods`WHERE goods_id = \’33347\’ || 4049 | geshow | localhost | geshow | Query | 7 | Locked | SELECT cat_id, brand_id FROM `geshow`.`ecs_goods`WHERE goods_id = \’30161\’ || 4051 | geshow | localhost | geshow | Query | 25 | Copying to tmp table | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4052 | geshow | localhost | geshow | Query | 5 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4056 | geshow | localhost | geshow | Query | 6 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4057 | geshow | localhost | geshow | Query | 8 | Locked | SELECT goods_id, goods_name,goods_name_style,goods_brief, shop_price,market_price, goods_thumb,sales || 4058 | geshow | localhost | geshow | Query | 5 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4061 | geshow | localhost | geshow | Query | 8 | Locked | SELECT goods_id, goods_name,goods_name_style,goods_brief, shop_price,market_price, goods_thumb,sales || 4086 | geshow | localhost | geshow | Query | 7 | Locked | SELECT g.goods_id, g.goods_name, g.market_price, g.shop_price AS org_price, g.promote_price, IFNULL || 4087 | geshow | localhost | geshow | Query | 7 | Locked | UPDATE `geshow`.`ecs_goods` SET click_count = click_count 1 WHERE goods_id = \’30437\’ || 4090 | geshow | localhost | geshow | Query | 5 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4091 | geshow | localhost | geshow | Query | 7 | Locked | SELECT goods_id, goods_name,goods_name_style,goods_brief, shop_price,market_price, goods_img,origina || 4092 | geshow | localhost | geshow | Query | 7 | Locked | SELECT d.* FROM `geshow`.`ecs_dynamic` AS d LEFT JOIN `geshow`.`ecs_goods` AS g ON d.goods_id = g. || 4094 | geshow | localhost | geshow | Query | 6 | Locked | SELECT goods_id, goods_name,goods_name_style,goods_brief, shop_price,market_price, goods_thumb,sales || 4095 | geshow | localhost | geshow | Query | 6 | Locked | SELECT g.*, c.measure_unit, b.brand_id, b.brand_name AS goods_brand, m.type_money AS bonus_money, IF || 4098 | geshow | localhost | geshow | Query | 5 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(*) AS goods_num FROM `geshow`.`ecs_brand`AS b, || 4099 | geshow | localhost | geshow | Query | 4 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(*) AS goods_num FROM `geshow`.`ecs_brand`AS b, || 4100 | geshow | localhost | geshow | Query | 3 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4103 | geshow | localhost | geshow | Query | 2 | Locked | select is_virtual from `geshow`.`ecs_goods` where goods_id=30830 || 4104 | geshow | localhost | geshow | Query | 2 | Locked | SELECT goods_id, goods_name,goods_name_style,goods_brief, shop_price,market_price, goods_img,origina || 4106 | geshow | localhost | geshow | Query | 2 | Locked | SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number F || 4108 | geshow | localhost | geshow | Query | 1 | Locked | select is_virtual from `geshow`.`ecs_goods` where goods_id=32707 || 4109 | geshow | localhost | geshow | Query | 1 | Locked | SELECT c.*,IF(c.extension_code = \”package_buy\”,act_name,g.goods_name) as goods_name, IF(c.extension || 4110 | geshow | localhost | geshow | Query | 1 | Locked | select is_virtual from `geshow`.`ecs_goods` where goods_id=32843 || 4111 | geshow | localhost | geshow | Query | 0 | Locked | SELECT b.brand_id, b.brand_name, b.brand_logo, COUNT(*) AS goods_num FROM `geshow`.`ecs_brand`AS b, || 4112 | geshow | localhost | geshow | Query | 0 | Locked | SELECT goods_id, goods_name,goods_name_style,goods_brief, shop_price,market_price, goods_thumb,sales || 4113 | geshow | localhost | NULL | Query | 0 | NULL | show processlist | —— —— —-
问:为什么服务器没被你们迁移我的网站都没事,一被你们迁移我的网站就有问题,2天都没法运营~~~
问:锁表的情况该怎么处理?? 之前是没有这种情况的 , 还请尽
答:您好,我们重新迁移了一个新的宿主机,目前检查网站访问正常,请再测试一下,非常感谢您长期对我司的支持.由此给您带来的不便之处,敬请原谅!谢谢!
问:网站还是打不开
答:您好,我司仔细排查了,可以确认不是服务器配置引起的,目前我司查看了您的数据库,主要是有锁表情况造成其它查询长时间等待,这种我司无法处理,请联系开发人员排查sql语句,优化索引,非常感谢您长期对我司的支持!