# even update customer set showhelp=0 where cid=66 run 61 seconds

**URL:** <https://forums.percona.com/t/even-update-customer-set-showhelp-0-where-cid-66-run-61-seconds/1205>\
**Category:** Other MySQL® Questions\
**Created:** [July 6, 2009, 1:58am UTC](https://forums.percona.com/t/even-update-customer-set-showhelp-0-where-cid-66-run-61-seconds/1205 "2009-07-06T01:58:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wenew](https://avatars.discourse-cdn.com/v4/letter/w/58956e/32.png) [@wenew](https://forums.percona.com/u/wenew)\
**Post date:** [July 6, 2009, 1:58am UTC](https://forums.percona.com/t/even-update-customer-set-showhelp-0-where-cid-66-run-61-seconds/1205/1 "2009-07-06T01:58:58Z")

</div>

slow query below:

# Time: 090706 15:12:30

# [User&#64;Host](mailto:User&#64;Host): cfgbeam[cfgbeam] @ [219.133.34.201]

# Query\_time: 61 Lock\_time: 0 Rows\_sent: 0 Rows\_examined: 0

update customer set showhelp=0 where cid=66;

CREATE TABLE `customer` (  
`cid` int(10) unsigned NOT NULL,  
`bid` int(11) default NULL,  
`cno` varchar(32) NOT NULL,  
`ano` varchar(cool: NOT NULL default ’ ',  
`cname` varchar(20) NOT NULL default ’ ',  
`domain` varchar(20) default NULL,  
`siteid` varchar(cool: default NULL,  
`score` decimal(18,2) NOT NULL default ‘5.00’,  
`money` decimal(18,2) NOT NULL default ‘0.00’,  
`regdate` datetime default NULL,  
`password` varchar(32) default NULL,  
`status` varchar(20) default ‘normal’,  
`memo` varchar(255) default NULL,  
`passwderrortimes` tinyint(4) default NULL,  
`currency` varchar(3) NOT NULL default ‘RMB’,  
`email` varchar(32) default NULL,  
`homepage` varchar(255) default NULL,  
`rcv_email` tinyint(4) default ‘1’ COMMENT ‘whether receive email notice’,  
`level` tinyint(4) default ‘1’,  
`avatar` varchar(255) default NULL,  
`avatar_big` varchar(255) default NULL,  
`rmder_cid` int(10) unsigned default NULL,  
`sex` varchar(4) default NULL,  
`lst_login` datetime default NULL,  
`email_active` tinyint(4) default ‘0’,  
`kmoney` int(11) default NULL,  
`login_fr` varchar(20) default NULL,  
PRIMARY KEY (`cid`),  
UNIQUE KEY `cno` (`cno`),  
UNIQUE KEY `cid` (`cid`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8  
it’s a sns game server,mysql so slow,it’s tuned a lots,  
but event that update sql so slowly,

customer table only 150k records on a Xeon with 2G memory  
somebody help me?any idea is very appreciated

---

<div class="post-metadata">

**Author:** ![vgatto](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vgatto/32/748_2.png) [@vgatto](https://forums.percona.com/u/vgatto)\
**Post date:** [July 6, 2009, 9:40am UTC](https://forums.percona.com/t/even-update-customer-set-showhelp-0-where-cid-66-run-61-seconds/1205/2 "2009-07-06T09:40:43Z")

</div>

That query is trivial. Are there any other queries in your slow query log? You could be looking at a symptom instead of the cause.

BTW, you can drop the unique index on cid, since it is already the primary key.