Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 02-15-2011 19:44:33

CrownRoyal
Member
Registered: 01-10-2009
Posts: 716

suffering from locked tables in CCP

I was experiencing similar issues for the past couple of days. Now, pretty much all day today I am seeing this. Any ideas what's going on?

# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` pr status
+---------+------------+-----------+--------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
| Id      | User       | Host      | db           | Command | Time | State    | Info                                                                                                 |
+---------+------------+-----------+--------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
| 7917123 | ccpuser    | localhost | clickcartpro | Query   | 86   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262299'                                              |
| 7917138 | ccpuser    | localhost | clickcartpro | Query   | 97   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262303'                                              |
| 7917229 | ccpuser    | localhost | clickcartpro | Query   | 3    | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262326'                                              |
| 7917237 | ccpuser    | localhost | clickcartpro | Query   | 76   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262328'                                              |
| 7917258 | ccpuser    | localhost | clickcartpro | Query   | 180  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262335'                                              |
| 7917297 | ccpuser    | localhost | clickcartpro | Query   | 97   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262351'                                              |
| 7917318 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | UPDATE khxc_sessions SET id='496si3780tzl3q9z96651kumii101fo6', lastaccess='1297814360', data='a:4:{ |
| 7917321 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | UPDATE khxc_sessions SET id='m848f8583428684sa29m36w93swy4s95', lastaccess='1297814360', data='a:4:{ |
| 7917330 | ccpuser    | localhost | clickcartpro | Query   | 119  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262368'                                              |
| 7917339 | ccpuser    | localhost | clickcartpro | Query   | 95   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262370'                                              |
| 7917357 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | UPDATE khxc_sessions SET id='q7rf64g44l142t39gdt66k6l6o39l54n', lastaccess='1297814373', data='a:4:{ |
| 7917359 | ccpuser    | localhost | clickcartpro | Query   | 25   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262374'                                              |
| 7917372 | ccpuser    | localhost | clickcartpro | Query   | 45   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262376'                                              |
| 7917383 | ccpuser    | localhost | clickcartpro | Query   | 31   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262380'                                              |
| 7917400 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | UPDATE khxc_sessions SET id='m848f8583428684sa29m36w93swy4s95', lastaccess='1297814388', data='a:4:{ |
| 7917435 | ccpuser    | localhost | clickcartpro | Query   | 87   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262399'                                              |
| 7917525 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | UPDATE khxc_sessions SET id='496si3780tzl3q9z96651kumii101fo6', lastaccess='1297814439', data='a:4:{ |
| 7917543 | ccpuser    | localhost | clickcartpro | Query   | 32   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262445'                                              |
| 7917556 | ccpuser    | localhost | clickcartpro | Query   | 14   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262448'                                              |
| 7917571 | ccpuser    | localhost | clickcartpro | Query   | 105  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262452'                                              |
| 7917595 | ccpuser    | localhost | clickcartpro | Query   | 183  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262457'                                              |
| 7917596 | ccpuser    | localhost | clickcartpro | Query   | 49   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262458'                                              |
| 7917627 | ccpuser    | localhost | clickcartpro | Query   | 80   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262463'                                              |
| 7917750 | ccpuser    | localhost | clickcartpro | Query   | 109  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262488'                                              |
| 7917754 | ccpuser    | localhost | clickcartpro | Query   | 25   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262489'                                              |
| 7917765 | ccpuser    | localhost | clickcartpro | Query   | 14   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262495'                                              |
| 7917766 | ccpuser    | localhost | clickcartpro | Query   | 2    | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262497'                                              |
| 7917773 | ccpuser    | localhost | clickcartpro | Query   | 2    | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262500'                                              |
| 7917791 | ccpuser    | localhost | clickcartpro | Query   | 103  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262504'                                              |
| 7917792 | ccpuser    | localhost | clickcartpro | Query   | 32   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262506'                                              |
| 7917794 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | UPDATE khxc_sessions SET id='496si3780tzl3q9z96651kumii101fo6', lastaccess='1297814506', data='a:4:{ |
| 7917806 | ccpuser    | localhost | clickcartpro | Query   | 102  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262510'                                              |
| 7917809 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | UPDATE khxc_sessions SET id='q7rf64g44l142t39gdt66k6l6o39l54n', lastaccess='1297814513', data='a:4:{ |
| 7917867 | ccpuser    | localhost | clickcartpro | Query   | 96   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262529'                                              |
| 7917909 | ccpuser    | localhost | clickcartpro | Query   | 30   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262542'                                              |
| 7917919 | ccpuser    | localhost | clickcartpro | Query   | 76   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262545'                                              |
| 7917920 | ccpuser    | localhost | clickcartpro | Query   | 7    | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262545'                                              |
| 7917924 | ccpuser    | localhost | clickcartpro | Query   | 97   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262546'                                              |
| 7917939 | ccpuser    | localhost | clickcartpro | Query   | 32   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262549'                                              |
| 7917953 | ccpuser    | localhost | clickcartpro | Query   | 102  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262553'                                              |
| 7917982 | ccpuser    | localhost | clickcartpro | Query   | 26   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262566'                                              |
| 7917993 | ccpuser    | localhost | clickcartpro | Query   | 64   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262567'                                              |
| 7918003 | ccpuser    | localhost | clickcartpro | Query   | 110  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262570'                                              |
| 7918022 | ccpuser    | localhost | clickcartpro | Query   | 105  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262577'                                              |
| 7918034 | ccpuser    | localhost | clickcartpro | Query   | 179  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262582'                                              |
| 7918066 | ccpuser    | localhost | clickcartpro | Query   | 13   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262596'                                              |
| 7918116 | ccpuser    | localhost | clickcartpro | Query   | 25   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262614'                                              |
| 7918128 | ccpuser    | localhost | clickcartpro | Query   | 48   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262617'                                              |
| 7918132 | ccpuser    | localhost | clickcartpro | Query   | 57   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262622'                                              |
| 7918156 | ccpuser    | localhost | clickcartpro | Query   | 6    | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262631'                                              |
| 7918159 | ccpuser    | localhost | clickcartpro | Query   | 102  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262632'                                              |
| 7918163 | ccpuser    | localhost | clickcartpro | Query   | 105  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262634'                                              |
| 7918166 | ccpuser    | localhost | clickcartpro | Query   | 103  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262635'                                              |
| 7918169 | ccpuser    | localhost | clickcartpro | Query   | 744  | updating | DELETE FROM khxc_sessions WHERE lastaccess<'1282262636'                                              |
| 7918173 | ccpuser    | localhost | clickcartpro | Query   | 25   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262639'                                              |
| 7918187 | ccpuser    | localhost | clickcartpro | Query   | 125  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262645'                                              |
| 7918239 | ccpuser    | localhost | clickcartpro | Query   | 144  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262665'                                              |
| 7918256 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262670'                                              |
| 7918298 | ccpuser    | localhost | clickcartpro | Query   | 6    | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262678'                                              |
| 7918313 | ccpuser    | localhost | clickcartpro | Query   | 47   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262683'                                              |
| 7918347 | ccpuser    | localhost | clickcartpro | Query   | 125  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262693'                                              |
| 7918354 | ccpuser    | localhost | clickcartpro | Query   | 125  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262695'                                              |
| 7918387 | ccpuser    | localhost | clickcartpro | Query   | 36   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262700'                                              |
| 7918422 | ccpuser    | localhost | clickcartpro | Query   | 31   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262708'                                              |
| 7918459 | ccpuser    | localhost | clickcartpro | Query   | 44   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262715'                                              |
| 7918498 | ccpuser    | localhost | clickcartpro | Query   | 145  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262722'                                              |
| 7918510 | ccpuser    | localhost | clickcartpro | Query   | 137  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262724'                                              |
| 7918511 | ccpuser    | localhost | clickcartpro | Query   | 26   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262724'                                              |
| 7918535 | ccpuser    | localhost | clickcartpro | Query   | 19   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262729'                                              |
| 7918545 | ccpuser    | localhost | clickcartpro | Query   | 69   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262734'                                              |
| 7918570 | ccpuser    | localhost | clickcartpro | Query   | 109  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262738'                                              |
| 7918573 | ccpuser    | localhost | clickcartpro | Query   | 30   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262738'                                              |
| 7918583 | ccpuser    | localhost | clickcartpro | Query   | 44   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262742'                                              |
| 7918621 | ccpuser    | localhost | clickcartpro | Query   | 45   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262750'                                              |
| 7918646 | ccpuser    | localhost | clickcartpro | Query   | 87   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262755'                                              |
| 7918668 | ccpuser    | localhost | clickcartpro | Query   | 36   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262767'                                              |
| 7918671 | ccpuser    | localhost | clickcartpro | Query   | 119  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262767'                                              |
| 7918684 | ccpuser    | localhost | clickcartpro | Query   | 47   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262770'                                              |
| 7918685 | ccpuser    | localhost | clickcartpro | Query   | 77   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262770'                                              |
| 7918703 | ccpuser    | localhost | clickcartpro | Query   | 109  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262772'                                              |
| 7918722 | ccpuser    | localhost | clickcartpro | Query   | 85   | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262778'                                              |
| 7918750 | ccpuser    | localhost | clickcartpro | Query   | 744  | Locked   | UPDATE khxc_sessions SET id='6cvtp21k11wp5uyksh0taw900q6b81q0', lastaccess='1297814789', data='a:4:{ |
| 7918760 | ccpuser    | localhost | clickcartpro | Query   | 157  | Locked   | UPDATE khxc_sessions SET id='s43jaegx930750r00ek6a5t2mzjo41oj', lastaccess='1297814791', data='a:4:{ |
| 7918767 | ccpuser    | localhost | clickcartpro | Query   | 745  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='899iu6i3y2za096fy91z93w923j0z444' O |
| 7918780 | ccpuser    | localhost | clickcartpro | Query   | 742  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9l4vb14gfp8l25477s7530vdc2w0mttl' O |
| 7918792 | ccpuser    | localhost | clickcartpro | Query   | 738  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='05u743xy62q4441t823ms6tqlkat7i8z'          |
| 7918793 | ccpuser    | localhost | clickcartpro | Query   | 738  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='d734x8imz4n350gd524z4r4crh1sp265'          |
| 7918811 | ccpuser    | localhost | clickcartpro | Query   | 733  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7918836 | ccpuser    | localhost | clickcartpro | Query   | 729  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='25x8px7a168y77647q7903iww17ec26r'          |
| 7918862 | ccpuser    | localhost | clickcartpro | Query   | 725  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='01381944s0a1f55v5h21pfl6a1779qxz'          |
| 7918863 | ccpuser    | localhost | clickcartpro | Query   | 725  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='6sd8pg08h9hj9k6ccowo0sdz837593j0' O |
| 7918870 | ccpuser    | localhost | clickcartpro | Query   | 723  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='o9i177bfxpj9xv5kw60789gw1szhm4fe'          |
| 7918892 | ccpuser    | localhost | clickcartpro | Query   | 719  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='234b40f98nbyd7w3g73t1e7ej96qf5e6'          |
| 7918905 | ccpuser    | localhost | clickcartpro | Query   | 717  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='2k16fe2yxwz6g9d627mjxl7x885gjvi8'          |
| 7918920 | ccpuser    | localhost | clickcartpro | Query   | 712  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='r5sgn559m0qye8z63witc1itvi0599ky'          |
| 7918926 | ccpuser    | localhost | clickcartpro | Query   | 708  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='97hfb574748s29o3d5a68j959q6u7cca'          |
| 7918939 | ccpuser    | localhost | clickcartpro | Query   | 699  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='wh915948d58v1i78j4i7jhd170g2xv8o'          |
| 7918954 | ccpuser    | localhost | clickcartpro | Query   | 697  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6502h7kd22q3107hoz256404x5bf3akr'          |
| 7918960 | ccpuser    | localhost | clickcartpro | Query   | 696  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='19p170947580x7qa046xn6nyta8th8ah'          |
| 7918983 | ccpuser    | localhost | clickcartpro | Query   | 688  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='e48cza96054446m41575t19106dl3296' O |
| 7918999 | ccpuser    | localhost | clickcartpro | Query   | 682  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='81ptw3179526r828718h407896190637'          |
| 7919020 | ccpuser    | localhost | clickcartpro | Query   | 678  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='260v3p5jj5ijr838qy2tsd49ou9215i9'          |
| 7919030 | ccpuser    | localhost | clickcartpro | Query   | 676  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='vb139n945w7kep188vs3338918d59254'          |
| 7919055 | ccpuser    | localhost | clickcartpro | Query   | 670  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='1276o33yq86569l1wg27j5j0hqzt190b'          |
| 7919100 | ccpuser    | localhost | clickcartpro | Query   | 660  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='5j114037k520mpti3m5ubk2ydzs6324o'          |
| 7919101 | ccpuser    | localhost | clickcartpro | Query   | 660  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='dk2x8ar7azg7kw6jfz690o84u8jl4563'          |
| 7919121 | ccpuser    | localhost | clickcartpro | Query   | 656  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='3ju82rk1w2ghauu601276vx4m4ovn590'          |
| 7919132 | ccpuser    | localhost | clickcartpro | Query   | 655  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='646hqa6kqf2jahc97vft8a71zrk52472'          |
| 7919134 | ccpuser    | localhost | clickcartpro | Query   | 654  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7919147 | ccpuser    | localhost | clickcartpro | Query   | 647  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='83551f6ha4c0283s28gwowqcm08v6599'          |
| 7919178 | ccpuser    | localhost | clickcartpro | Query   | 636  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='t3n30vn23717k84ky27w8mf1e00r2g2r'          |
| 7919192 | ccpuser    | localhost | clickcartpro | Query   | 634  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='5a6t3xw60b6f71mmwi7h98g56o6f3558'          |
| 7919216 | ccpuser    | localhost | clickcartpro | Query   | 631  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7919245 | ccpuser    | localhost | clickcartpro | Query   | 618  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='ge901v8v1edf9xd55f6i97v16nzw5b1n'          |
| 7919253 | ccpuser    | localhost | clickcartpro | Query   | 615  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='oa53em57bv422640c2r9i37705cl8n5l'          |
| 7919268 | ccpuser    | localhost | clickcartpro | Query   | 611  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='9q7l63t482g134ia80s9n00s3dgphkje'          |
| 7919285 | ccpuser    | localhost | clickcartpro | Query   | 603  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6jub1n52m01cu2low1f280ml72n1hzr6'          |
| 7919287 | ccpuser    | localhost | clickcartpro | Query   | 602  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7919315 | ccpuser    | localhost | clickcartpro | Query   | 594  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0slf44sqg70x9hsfg6n50iezq65117ce'          |
| 7919334 | ccpuser    | localhost | clickcartpro | Query   | 590  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0zyj97y3q007f393wyy6g67a4x591zms'          |
| 7919413 | ccpuser    | localhost | clickcartpro | Query   | 573  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6fxc6ueu492tit069ckg88bl189tku19'          |
| 7919434 | ccpuser    | localhost | clickcartpro | Query   | 569  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7166r0ccg8a30v38bhhlwww77ade85pz'          |
| 7919438 | ccpuser    | localhost | clickcartpro | Query   | 567  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7919477 | ccpuser    | localhost | clickcartpro | Query   | 557  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='l9l1by0d0ivrmr7ei449y2g567i43wkn'          |
| 7919478 | ccpuser    | localhost | clickcartpro | Query   | 557  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i7940cc77a8ad23kl75tk1c96g1b9k4y' O |
| 7919509 | ccpuser    | localhost | clickcartpro | Query   | 552  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='7rlqiv5g9u6em6o4mhix20ln0iz5nd1c' O |
| 7919527 | ccpuser    | localhost | clickcartpro | Query   | 549  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='mpk2map4w6638m0892zh52rwtoucq9n2'          |
| 7919537 | ccpuser    | localhost | clickcartpro | Query   | 548  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='5j1317mr9511n2rt0v1979t2518y0380'          |
| 7919546 | ccpuser    | localhost | clickcartpro | Query   | 548  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='35w0v0680ube1ta3zokaj53rvvsfk8nl'          |
| 7919608 | ccpuser    | localhost | clickcartpro | Query   | 534  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7919636 | ccpuser    | localhost | clickcartpro | Query   | 522  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i7940cc77a8ad23kl75tk1c96g1b9k4y' O |
| 7919646 | ccpuser    | localhost | clickcartpro | Query   | 517  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='wr56zolw93woaw10sfssc1ze7550u956'          |
| 7919652 | ccpuser    | localhost | clickcartpro | Query   | 518  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='21x99srdmfb61wa1i21wsh3clp9a886w'          |
| 7919686 | ccpuser    | localhost | clickcartpro | Query   | 512  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='8r8m3ll6z4e421ti216z6306v0i7280d'          |
| 7919702 | ccpuser    | localhost | clickcartpro | Query   | 508  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='57795y72j5u072th400zv09o0ldf86q0'          |
| 7919710 | ccpuser    | localhost | clickcartpro | Query   | 507  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='90le79uj107e7lwbr45e13aef1525f5i'          |
| 7919715 | ccpuser    | localhost | clickcartpro | Query   | 506  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='7rlqiv5g9u6em6o4mhix20ln0iz5nd1c' O |
| 7919716 | ccpuser    | localhost | clickcartpro | Query   | 505  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='t1380163dule3155j1gj76q892ev6295' O |
| 7919719 | ccpuser    | localhost | clickcartpro | Query   | 505  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='hhlfn4lsm10j7i2477fhj480tse86o91'          |
| 7919726 | ccpuser    | localhost | clickcartpro | Query   | 504  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='p1a4672391sh37t141c4kue526v87t4e'          |
| 7919749 | ccpuser    | localhost | clickcartpro | Query   | 498  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='bc0i721i862o9z84578o340ass1j926e'          |
| 7919773 | ccpuser    | localhost | clickcartpro | Query   | 493  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7919780 | ccpuser    | localhost | clickcartpro | Query   | 493  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='24v24kc5865d001u3f8594n6nh40gym8'          |
| 7919797 | ccpuser    | localhost | clickcartpro | Query   | 486  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='12oz4e94k2g4tk7sl81v892l2m8p4fk9'          |
| 7919817 | ccpuser    | localhost | clickcartpro | Query   | 482  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7uszu69yzx5d720964h89ceqpl92oopv'          |
| 7919824 | ccpuser    | localhost | clickcartpro | Query   | 480  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7919827 | ccpuser    | localhost | clickcartpro | Query   | 479  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='fsfw8zbh0v15ynn4zp12274682m20840'          |
| 7919871 | ccpuser    | localhost | clickcartpro | Query   | 467  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='036759t28q18442ko6j8e83wrqfs2qs5'          |
| 7919884 | ccpuser    | localhost | clickcartpro | Query   | 464  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='8p4p6hg4i85u64en29340159y427xm78'          |
| 7919896 | ccpuser    | localhost | clickcartpro | Query   | 461  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0692k0hdg9qs331w0k56v1hom0499db2'          |
| 7919930 | ccpuser    | localhost | clickcartpro | Query   | 454  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='214p8e639s9vc2t7s8iavvy1173z2893'          |
| 7919962 | ccpuser    | localhost | clickcartpro | Query   | 446  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='wn49c656i83785093f06p8qw7w2w20gh'          |
| 7919975 | ccpuser    | localhost | clickcartpro | Query   | 443  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='9ar99m02j6ljf90675i7qj55zf7i1zoh'          |
| 7919981 | ccpuser    | localhost | clickcartpro | Query   | 442  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='wo088x8806hc55z2t98soq44i471x531'          |
| 7919990 | ccpuser    | localhost | clickcartpro | Query   | 440  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='c184q38q03qvo98cc8779y8y62jsmorc'          |
| 7919992 | ccpuser    | localhost | clickcartpro | Query   | 439  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i9479t17sj2kbr6f5677wm7ex67rd783' O |
| 7919994 | ccpuser    | localhost | clickcartpro | Query   | 438  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7920073 | ccpuser    | localhost | clickcartpro | Query   | 421  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='739da01kh6zy2p73sg8q3804h6u468h1'          |
| 7920080 | ccpuser    | localhost | clickcartpro | Query   | 420  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='i469356r6m0jten05g95v30oq9856j01'          |
| 7920081 | ccpuser    | localhost | clickcartpro | Query   | 420  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='t713a3erlt71wk3h22qg0e9246l4i516'          |
| 7920105 | ccpuser    | localhost | clickcartpro | Query   | 407  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='y0fi8z0vsdy9j9tz8br6tmk257535n8z'          |
| 7920150 | ccpuser    | localhost | clickcartpro | Query   | 397  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='515x528kj4cl9auc5051442oz0jc88ny'          |
| 7920156 | ccpuser    | localhost | clickcartpro | Query   | 396  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='2f6r8xf3535l3xw70kettdq2346ampy9'          |
| 7920171 | ccpuser    | localhost | clickcartpro | Query   | 394  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |
| 7920173 | ccpuser    | localhost | clickcartpro | Query   | 394  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='10659142qn204q3i9o7q09oaq9449952' O |
| 7920220 | ccpuser    | localhost | clickcartpro | Query   | 375  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='79y49u7vkv85ze05coahn9104g3znynr'          |
| 7920234 | ccpuser    | localhost | clickcartpro | Query   | 372  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='au1kw2hq9f4m4vq4sz1e7c40m8c2t75i'          |
| 7920258 | ccpuser    | localhost | clickcartpro | Query   | 363  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |
| 7920275 | ccpuser    | localhost | clickcartpro | Query   | 358  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7802u9310z66324rivhn1545sy752nf2'          |
| 7920276 | ccpuser    | localhost | clickcartpro | Query   | 358  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7920287 | ccpuser    | localhost | clickcartpro | Query   | 352  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='22zuf2uu068xdq0z9t25aasax6018t8f'          |
| 7920300 | ccpuser    | localhost | clickcartpro | Query   | 350  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='85e4hh93d0p4c0098n66jf8opajozion'          |
| 7920306 | ccpuser    | localhost | clickcartpro | Query   | 348  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='t1380163dule3155j1gj76q892ev6295' O |
| 7920345 | ccpuser    | localhost | clickcartpro | Query   | 343  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='j247182u8qyzdbg1k612sy2j779351bm'          |
| 7920358 | ccpuser    | localhost | clickcartpro | Query   | 338  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='14plar0950fyp9aom2i2b0ax65uk0660'          |
| 7920367 | ccpuser    | localhost | clickcartpro | Query   | 334  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7920369 | ccpuser    | localhost | clickcartpro | Query   | 330  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='23s095z6331ve8d8900iy655osd24761' O |
| 7920370 | ccpuser    | localhost | clickcartpro | Query   | 330  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='v8p9yxv2q4rd19r023b3079wx5hs30o1'          |
| 7920371 | ccpuser    | localhost | clickcartpro | Query   | 156  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |
| 7920373 | ccpuser    | localhost | clickcartpro | Query   | 143  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='7rlqiv5g9u6em6o4mhix20ln0iz5nd1c' O |
| 7920375 | ccpuser    | localhost | clickcartpro | Query   | 135  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='z46r38zz5eytel8e7293rodbh5z2wwq4'          |
| 7920385 | ccpuser    | localhost | clickcartpro | Query   | 129  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7533e22k3kkhcoc8c15n3b266g5c3l0q'          |
| 7920396 | ccpuser    | localhost | clickcartpro | Query   | 128  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7920397 | ccpuser    | localhost | clickcartpro | Query   | 127  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='m7095jq9vyl66l2p0mkd6k5321612gv6'          |
| 7920454 | ccpuser    | localhost | clickcartpro | Query   | 118  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i9479t17sj2kbr6f5677wm7ex67rd783' O |
| 7920461 | ccpuser    | localhost | clickcartpro | Query   | 117  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0srlwm602ybdiqtd6gp351r9o9s8x046'          |
| 7920475 | ccpuser    | localhost | clickcartpro | Query   | 116  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='w718p8bofs4720k3w57gzlhg4253a4di'          |
| 7920476 | ccpuser    | localhost | clickcartpro | Query   | 115  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='e9yk53tnq25r952zqndd60cu85707517'          |
| 7920479 | ccpuser    | localhost | clickcartpro | Query   | 111  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='hs5mg2702r9y214yx707x9q8bh5hx382'          |
| 7920495 | ccpuser    | localhost | clickcartpro | Query   | 109  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |hxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |
| 7920525 | ccpuser    | localhost | clickcartpro | Query   | 98   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='gyl2ppxk93pf824xe7t03w63v17q5r4c'          |
| 7920543 | ccpuser    | localhost | clickcartpro | Query   | 95   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='67yi74zwj985u93hyvr7ir06hianc02l'          |
| 7920577 | wdp46tu3_2 | localhost | f3z28m_2     | Sleep   | 90   |          |                                                                                                      |
| 7920591 | ccpuser    | localhost | clickcartpro | Query   | 89   | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='dzl6v49xq646ya7rhs3gg0h61u61pwt1' O |
| 7920616 | bdweb2111d | localhost | probe        | Sleep   | 84   |          |                                                                                                      |
| 7920645 | ccpuser    | localhost | clickcartpro | Query   | 73   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='n4308h8p10m800e145fc8zt7vgo3c71d'          |
| 7920690 | ccpuser    | localhost | clickcartpro | Query   | 63   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='orx230gs5nsz7bffe4p82b031dc80952'          |
| 7920715 | ccpuser    | localhost | clickcartpro | Query   | 60   | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i9479t17sj2kbr6f5677wm7ex67rd783' O |
| 7920742 | ccpuser    | localhost | clickcartpro | Query   | 56   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='1zy2gqi5j7kwyfw0913kj1u7x98e6256'          |
| 7920749 | ccpuser    | localhost | clickcartpro | Query   | 55   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='gt162p4mqv8bsqis2185i287tyjlti57'          |
| 7920841 | ccpuser    | localhost | clickcartpro | Query   | 38   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='9891n288b2kpajx883xk83761g2822gm'          |
| 7920870 | ccpuser    | localhost | clickcartpro | Query   | 35   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='t6ktlxtrjcz735pp4029z29943e3gk16'          |
| 7920886 | ccpuser    | localhost | clickcartpro | Query   | 33   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='z2k22d78670jmx64244075b1k4iml0y2'          |
| 7920899 | ccpuser    | localhost | clickcartpro | Query   | 31   | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7920936 | ccpuser    | localhost | clickcartpro | Query   | 20   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6j92dzz251um23ca7w97gr0awz706m4s'          |
| 7920979 | ccpuser    | localhost | clickcartpro | Query   | 10   | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7920992 | wdp46tu3_2 | localhost | f3z28m_2     | Sleep   | 9    |          |                                                                                                      |
| 7920996 | ccpuser    | localhost | clickcartpro | Query   | 8    | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7921004 | admin      | localhost |              | Query   | 0    |          | show processlist                                                                                     |
+---------+------------+-----------+--------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
Uptime: 1878677  Threads: 209  Questions: 59003715  Slow queries: 1672  Opens: 13496  Flush tables: 1  Open tables: 400  Queries per second avg: 31.407

Offline

 

#2 02-15-2011 19:45:40

CrownRoyal
Member
Registered: 01-10-2009
Posts: 716

Re: suffering from locked tables in CCP

I went back in and looked again after making the first post (seconds ago) and this:

mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` pr status
+---------+---------+-----------+--------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
| Id      | User    | Host      | db           | Command | Time | State    | Info                                                                                                 |
+---------+---------+-----------+--------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
| 7917229 | ccpuser | localhost | clickcartpro | Query   | 219  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262326'                                              |
| 7917318 | ccpuser | localhost | clickcartpro | Query   | 210  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262360'                                              |
| 7917321 | ccpuser | localhost | clickcartpro | Query   | 214  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262360'                                              |
| 7917357 | ccpuser | localhost | clickcartpro | Query   | 210  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262373'                                              |
| 7917359 | ccpuser | localhost | clickcartpro | Query   | 241  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262374'                                              |
| 7917400 | ccpuser | localhost | clickcartpro | Query   | 210  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262388'                                              |
| 7917525 | ccpuser | localhost | clickcartpro | Query   | 210  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262439'                                              |
| 7917556 | ccpuser | localhost | clickcartpro | Query   | 230  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262448'                                              |
| 7917754 | ccpuser | localhost | clickcartpro | Query   | 241  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262489'                                              |
| 7917765 | ccpuser | localhost | clickcartpro | Query   | 230  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262495'                                              |
| 7917766 | ccpuser | localhost | clickcartpro | Query   | 218  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262497'                                              |
| 7917773 | ccpuser | localhost | clickcartpro | Query   | 218  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262500'                                              |
| 7917794 | ccpuser | localhost | clickcartpro | Query   | 209  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262506'                                              |
| 7917809 | ccpuser | localhost | clickcartpro | Query   | 210  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262513'                                              |
| 7917909 | ccpuser | localhost | clickcartpro | Query   | 246  | updating | DELETE FROM khxc_sessions WHERE lastaccess<'1282262542'                                              |
| 7917920 | ccpuser | localhost | clickcartpro | Query   | 223  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262545'                                              |
| 7917982 | ccpuser | localhost | clickcartpro | Query   | 242  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262566'                                              |
| 7918066 | ccpuser | localhost | clickcartpro | Query   | 229  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262596'                                              |
| 7918116 | ccpuser | localhost | clickcartpro | Query   | 241  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262614'                                              |
| 7918156 | ccpuser | localhost | clickcartpro | Query   | 222  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262631'                                              |
| 7918173 | ccpuser | localhost | clickcartpro | Query   | 241  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262639'                                              |
| 7918298 | ccpuser | localhost | clickcartpro | Query   | 222  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262678'                                              |
| 7918511 | ccpuser | localhost | clickcartpro | Query   | 242  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262724'                                              |
| 7918535 | ccpuser | localhost | clickcartpro | Query   | 235  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262729'                                              |
| 7918573 | ccpuser | localhost | clickcartpro | Query   | 246  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262738'                                              |
| 7918750 | ccpuser | localhost | clickcartpro | Query   | 208  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262789'                                              |
| 7918760 | ccpuser | localhost | clickcartpro | Query   | 196  | Locked   | DELETE FROM khxc_sessions WHERE lastaccess<'1282262791'                                              |
| 7918767 | ccpuser | localhost | clickcartpro | Query   | 961  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='899iu6i3y2za096fy91z93w923j0z444' O |
| 7918780 | ccpuser | localhost | clickcartpro | Query   | 958  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9l4vb14gfp8l25477s7530vdc2w0mttl' O |
| 7918792 | ccpuser | localhost | clickcartpro | Query   | 954  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='05u743xy62q4441t823ms6tqlkat7i8z'          |
| 7918793 | ccpuser | localhost | clickcartpro | Query   | 954  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='d734x8imz4n350gd524z4r4crh1sp265'          |
| 7918811 | ccpuser | localhost | clickcartpro | Query   | 949  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7918836 | ccpuser | localhost | clickcartpro | Query   | 945  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='25x8px7a168y77647q7903iww17ec26r'          |
| 7918862 | ccpuser | localhost | clickcartpro | Query   | 941  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='01381944s0a1f55v5h21pfl6a1779qxz'          |
| 7918863 | ccpuser | localhost | clickcartpro | Query   | 941  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='6sd8pg08h9hj9k6ccowo0sdz837593j0' O |
| 7918870 | ccpuser | localhost | clickcartpro | Query   | 939  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='o9i177bfxpj9xv5kw60789gw1szhm4fe'          |
| 7918892 | ccpuser | localhost | clickcartpro | Query   | 935  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='234b40f98nbyd7w3g73t1e7ej96qf5e6'          |
| 7918905 | ccpuser | localhost | clickcartpro | Query   | 933  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='2k16fe2yxwz6g9d627mjxl7x885gjvi8'          |
| 7918920 | ccpuser | localhost | clickcartpro | Query   | 928  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='r5sgn559m0qye8z63witc1itvi0599ky'          |
| 7918926 | ccpuser | localhost | clickcartpro | Query   | 924  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='97hfb574748s29o3d5a68j959q6u7cca'          |
| 7918939 | ccpuser | localhost | clickcartpro | Query   | 915  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='wh915948d58v1i78j4i7jhd170g2xv8o'          |
| 7918954 | ccpuser | localhost | clickcartpro | Query   | 913  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6502h7kd22q3107hoz256404x5bf3akr'          |
| 7918960 | ccpuser | localhost | clickcartpro | Query   | 912  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='19p170947580x7qa046xn6nyta8th8ah'          |
| 7918983 | ccpuser | localhost | clickcartpro | Query   | 904  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='e48cza96054446m41575t19106dl3296' O |
| 7918999 | ccpuser | localhost | clickcartpro | Query   | 898  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='81ptw3179526r828718h407896190637'          |
| 7919020 | ccpuser | localhost | clickcartpro | Query   | 894  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='260v3p5jj5ijr838qy2tsd49ou9215i9'          |
| 7919030 | ccpuser | localhost | clickcartpro | Query   | 892  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='vb139n945w7kep188vs3338918d59254'          |
| 7919055 | ccpuser | localhost | clickcartpro | Query   | 886  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='1276o33yq86569l1wg27j5j0hqzt190b'          |
| 7919100 | ccpuser | localhost | clickcartpro | Query   | 876  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='5j114037k520mpti3m5ubk2ydzs6324o'          |
| 7919101 | ccpuser | localhost | clickcartpro | Query   | 876  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='dk2x8ar7azg7kw6jfz690o84u8jl4563'          |
| 7919121 | ccpuser | localhost | clickcartpro | Query   | 872  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='3ju82rk1w2ghauu601276vx4m4ovn590'          |
| 7919132 | ccpuser | localhost | clickcartpro | Query   | 871  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='646hqa6kqf2jahc97vft8a71zrk52472'          |
| 7919134 | ccpuser | localhost | clickcartpro | Query   | 870  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7919147 | ccpuser | localhost | clickcartpro | Query   | 863  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='83551f6ha4c0283s28gwowqcm08v6599'          |
| 7919178 | ccpuser | localhost | clickcartpro | Query   | 852  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='t3n30vn23717k84ky27w8mf1e00r2g2r'          |
| 7919192 | ccpuser | localhost | clickcartpro | Query   | 850  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='5a6t3xw60b6f71mmwi7h98g56o6f3558'          |
| 7919216 | ccpuser | localhost | clickcartpro | Query   | 847  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7919245 | ccpuser | localhost | clickcartpro | Query   | 834  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='ge901v8v1edf9xd55f6i97v16nzw5b1n'          |
| 7919253 | ccpuser | localhost | clickcartpro | Query   | 831  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='oa53em57bv422640c2r9i37705cl8n5l'          |
| 7919268 | ccpuser | localhost | clickcartpro | Query   | 827  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='9q7l63t482g134ia80s9n00s3dgphkje'          |
| 7919285 | ccpuser | localhost | clickcartpro | Query   | 819  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6jub1n52m01cu2low1f280ml72n1hzr6'          |
| 7919287 | ccpuser | localhost | clickcartpro | Query   | 818  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7919315 | ccpuser | localhost | clickcartpro | Query   | 810  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0slf44sqg70x9hsfg6n50iezq65117ce'          |
| 7919334 | ccpuser | localhost | clickcartpro | Query   | 806  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0zyj97y3q007f393wyy6g67a4x591zms'          |
| 7919413 | ccpuser | localhost | clickcartpro | Query   | 789  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6fxc6ueu492tit069ckg88bl189tku19'          |
| 7919434 | ccpuser | localhost | clickcartpro | Query   | 785  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7166r0ccg8a30v38bhhlwww77ade85pz'          |
| 7919438 | ccpuser | localhost | clickcartpro | Query   | 783  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='9suv8lpn995f1psb50p74m2925o4yzko' O |
| 7919477 | ccpuser | localhost | clickcartpro | Query   | 773  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='l9l1by0d0ivrmr7ei449y2g567i43wkn'          |
| 7919478 | ccpuser | localhost | clickcartpro | Query   | 773  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i7940cc77a8ad23kl75tk1c96g1b9k4y' O |
| 7919509 | ccpuser | localhost | clickcartpro | Query   | 768  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='7rlqiv5g9u6em6o4mhix20ln0iz5nd1c' O |
| 7919527 | ccpuser | localhost | clickcartpro | Query   | 765  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='mpk2map4w6638m0892zh52rwtoucq9n2'          |
| 7919537 | ccpuser | localhost | clickcartpro | Query   | 764  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='5j1317mr9511n2rt0v1979t2518y0380'          |
| 7919546 | ccpuser | localhost | clickcartpro | Query   | 764  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='35w0v0680ube1ta3zokaj53rvvsfk8nl'          |
| 7919608 | ccpuser | localhost | clickcartpro | Query   | 750  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7919636 | ccpuser | localhost | clickcartpro | Query   | 738  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i7940cc77a8ad23kl75tk1c96g1b9k4y' O |
| 7919646 | ccpuser | localhost | clickcartpro | Query   | 733  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='wr56zolw93woaw10sfssc1ze7550u956'          |
| 7919652 | ccpuser | localhost | clickcartpro | Query   | 734  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='21x99srdmfb61wa1i21wsh3clp9a886w'          |
| 7919686 | ccpuser | localhost | clickcartpro | Query   | 728  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='8r8m3ll6z4e421ti216z6306v0i7280d'          |
| 7919702 | ccpuser | localhost | clickcartpro | Query   | 724  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='57795y72j5u072th400zv09o0ldf86q0'          |
| 7919710 | ccpuser | localhost | clickcartpro | Query   | 723  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='90le79uj107e7lwbr45e13aef1525f5i'          |
| 7919715 | ccpuser | localhost | clickcartpro | Query   | 722  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='7rlqiv5g9u6em6o4mhix20ln0iz5nd1c' O |
| 7919716 | ccpuser | localhost | clickcartpro | Query   | 721  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='t1380163dule3155j1gj76q892ev6295' O |
| 7919719 | ccpuser | localhost | clickcartpro | Query   | 721  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='hhlfn4lsm10j7i2477fhj480tse86o91'          |
| 7919726 | ccpuser | localhost | clickcartpro | Query   | 720  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='p1a4672391sh37t141c4kue526v87t4e'          |
| 7919749 | ccpuser | localhost | clickcartpro | Query   | 714  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='bc0i721i862o9z84578o340ass1j926e'          |
| 7919773 | ccpuser | localhost | clickcartpro | Query   | 709  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7919780 | ccpuser | localhost | clickcartpro | Query   | 709  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='24v24kc5865d001u3f8594n6nh40gym8'          |
| 7919797 | ccpuser | localhost | clickcartpro | Query   | 702  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='12oz4e94k2g4tk7sl81v892l2m8p4fk9'          |
| 7919817 | ccpuser | localhost | clickcartpro | Query   | 698  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7uszu69yzx5d720964h89ceqpl92oopv'          |
| 7919824 | ccpuser | localhost | clickcartpro | Query   | 696  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7919827 | ccpuser | localhost | clickcartpro | Query   | 695  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='fsfw8zbh0v15ynn4zp12274682m20840'          |
| 7919871 | ccpuser | localhost | clickcartpro | Query   | 683  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='036759t28q18442ko6j8e83wrqfs2qs5'          |
| 7919884 | ccpuser | localhost | clickcartpro | Query   | 680  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='8p4p6hg4i85u64en29340159y427xm78'          |
| 7919896 | ccpuser | localhost | clickcartpro | Query   | 677  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0692k0hdg9qs331w0k56v1hom0499db2'          |
| 7919930 | ccpuser | localhost | clickcartpro | Query   | 670  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='214p8e639s9vc2t7s8iavvy1173z2893'          |
| 7919962 | ccpuser | localhost | clickcartpro | Query   | 662  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='wn49c656i83785093f06p8qw7w2w20gh'          |
| 7919975 | ccpuser | localhost | clickcartpro | Query   | 659  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='9ar99m02j6ljf90675i7qj55zf7i1zoh'          |
| 7919981 | ccpuser | localhost | clickcartpro | Query   | 658  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='wo088x8806hc55z2t98soq44i471x531'          |
| 7919990 | ccpuser | localhost | clickcartpro | Query   | 656  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='c184q38q03qvo98cc8779y8y62jsmorc'          |
| 7919992 | ccpuser | localhost | clickcartpro | Query   | 655  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i9479t17sj2kbr6f5677wm7ex67rd783' O |
| 7919994 | ccpuser | localhost | clickcartpro | Query   | 654  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7920073 | ccpuser | localhost | clickcartpro | Query   | 637  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='739da01kh6zy2p73sg8q3804h6u468h1'          |
| 7920080 | ccpuser | localhost | clickcartpro | Query   | 636  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='i469356r6m0jten05g95v30oq9856j01'          |
| 7920081 | ccpuser | localhost | clickcartpro | Query   | 636  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='t713a3erlt71wk3h22qg0e9246l4i516'          |
| 7920105 | ccpuser | localhost | clickcartpro | Query   | 623  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='y0fi8z0vsdy9j9tz8br6tmk257535n8z'          |
| 7920150 | ccpuser | localhost | clickcartpro | Query   | 613  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='515x528kj4cl9auc5051442oz0jc88ny'          |
| 7920156 | ccpuser | localhost | clickcartpro | Query   | 612  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='2f6r8xf3535l3xw70kettdq2346ampy9'          |
| 7920171 | ccpuser | localhost | clickcartpro | Query   | 610  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |
| 7920173 | ccpuser | localhost | clickcartpro | Query   | 610  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='10659142qn204q3i9o7q09oaq9449952' O |
| 7920220 | ccpuser | localhost | clickcartpro | Query   | 591  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='79y49u7vkv85ze05coahn9104g3znynr'          |
| 7920234 | ccpuser | localhost | clickcartpro | Query   | 588  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='au1kw2hq9f4m4vq4sz1e7c40m8c2t75i'          |
| 7920258 | ccpuser | localhost | clickcartpro | Query   | 579  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |
| 7920275 | ccpuser | localhost | clickcartpro | Query   | 574  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7802u9310z66324rivhn1545sy752nf2'          |
| 7920276 | ccpuser | localhost | clickcartpro | Query   | 574  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='r782ai7w3e2s6982c31136q745645w03' O |
| 7920287 | ccpuser | localhost | clickcartpro | Query   | 568  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='22zuf2uu068xdq0z9t25aasax6018t8f'          |
| 7920300 | ccpuser | localhost | clickcartpro | Query   | 566  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='85e4hh93d0p4c0098n66jf8opajozion'          |
| 7920306 | ccpuser | localhost | clickcartpro | Query   | 564  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='t1380163dule3155j1gj76q892ev6295' O |
| 7920345 | ccpuser | localhost | clickcartpro | Query   | 559  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='j247182u8qyzdbg1k612sy2j779351bm'          |
| 7920358 | ccpuser | localhost | clickcartpro | Query   | 554  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='14plar0950fyp9aom2i2b0ax65uk0660'          |
| 7920367 | ccpuser | localhost | clickcartpro | Query   | 550  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7920369 | ccpuser | localhost | clickcartpro | Query   | 546  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='23s095z6331ve8d8900iy655osd24761' O |
| 7920370 | ccpuser | localhost | clickcartpro | Query   | 546  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='v8p9yxv2q4rd19r023b3079wx5hs30o1'          |
| 7920371 | ccpuser | localhost | clickcartpro | Query   | 372  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |
| 7920373 | ccpuser | localhost | clickcartpro | Query   | 359  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='7rlqiv5g9u6em6o4mhix20ln0iz5nd1c' O |
| 7920375 | ccpuser | localhost | clickcartpro | Query   | 351  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='z46r38zz5eytel8e7293rodbh5z2wwq4'          |
| 7920385 | ccpuser | localhost | clickcartpro | Query   | 345  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7533e22k3kkhcoc8c15n3b266g5c3l0q'          |
| 7920396 | ccpuser | localhost | clickcartpro | Query   | 344  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7920397 | ccpuser | localhost | clickcartpro | Query   | 343  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='m7095jq9vyl66l2p0mkd6k5321612gv6'          |
| 7920454 | ccpuser | localhost | clickcartpro | Query   | 334  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i9479t17sj2kbr6f5677wm7ex67rd783' O |
| 7920461 | ccpuser | localhost | clickcartpro | Query   | 333  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0srlwm602ybdiqtd6gp351r9o9s8x046'          |
| 7920475 | ccpuser | localhost | clickcartpro | Query   | 332  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='w718p8bofs4720k3w57gzlhg4253a4di'          |
| 7920476 | ccpuser | localhost | clickcartpro | Query   | 331  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='e9yk53tnq25r952zqndd60cu85707517'          |
| 7920479 | ccpuser | localhost | clickcartpro | Query   | 327  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='hs5mg2702r9y214yx707x9q8bh5hx382'          |
| 7920495 | ccpuser | localhost | clickcartpro | Query   | 325  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='995we55od107d9123ee628e7j9n99al9' O |
| 7920525 | ccpuser | localhost | clickcartpro | Query   | 314  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='gyl2ppxk93pf824xe7t03w63v17q5r4c'          |
| 7920543 | ccpuser | localhost | clickcartpro | Query   | 311  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='67yi74zwj985u93hyvr7ir06hianc02l'          |
| 7920591 | ccpuser | localhost | clickcartpro | Query   | 305  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='dzl6v49xq646ya7rhs3gg0h61u61pwt1' O |
| 7920645 | ccpuser | localhost | clickcartpro | Query   | 289  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='n4308h8p10m800e145fc8zt7vgo3c71d'          |
| 7920690 | ccpuser | localhost | clickcartpro | Query   | 279  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='orx230gs5nsz7bffe4p82b031dc80952'          |
| 7920715 | ccpuser | localhost | clickcartpro | Query   | 276  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='i9479t17sj2kbr6f5677wm7ex67rd783' O |
| 7920742 | ccpuser | localhost | clickcartpro | Query   | 272  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='1zy2gqi5j7kwyfw0913kj1u7x98e6256'          |
| 7920749 | ccpuser | localhost | clickcartpro | Query   | 271  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='gt162p4mqv8bsqis2185i287tyjlti57'          |
| 7920841 | ccpuser | localhost | clickcartpro | Query   | 254  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='9891n288b2kpajx883xk83761g2822gm'          |
| 7920870 | ccpuser | localhost | clickcartpro | Query   | 251  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='t6ktlxtrjcz735pp4029z29943e3gk16'          |
| 7920886 | ccpuser | localhost | clickcartpro | Query   | 249  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='z2k22d78670jmx64244075b1k4iml0y2'          |
| 7920899 | ccpuser | localhost | clickcartpro | Query   | 247  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7920936 | ccpuser | localhost | clickcartpro | Query   | 236  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6j92dzz251um23ca7w97gr0awz706m4s'          |
| 7920979 | ccpuser | localhost | clickcartpro | Query   | 226  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7920996 | ccpuser | localhost | clickcartpro | Query   | 224  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7921017 | ccpuser | localhost | clickcartpro | Query   | 215  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='4lu23ezr9151v9is4058u0278260254t' O |
| 7921036 | ccpuser | localhost | clickcartpro | Query   | 203  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='814ek55bn4r6w2172lknlaqpr1w875xd'          |
| 7921037 | ccpuser | localhost | clickcartpro | Query   | 202  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='6h6s91n0020nbx831l1933c8zy0w8unj'          |
| 7921038 | ccpuser | localhost | clickcartpro | Query   | 201  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='5vb0e54x4yk6a1e8371f5yew6200tf7o'          |
| 7921069 | ccpuser | localhost | clickcartpro | Query   | 193  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='a9rv5459x56km0i758ni9j9o933b28ex'          |
| 7921086 | ccpuser | localhost | clickcartpro | Query   | 190  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='e260h44uw6042856tg3hh68f5d80q331'          |
| 7921103 | ccpuser | localhost | clickcartpro | Query   | 182  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='iheef5a8n2w40z3g3zk064y2r46509g9'          |
| 7921112 | ccpuser | localhost | clickcartpro | Query   | 180  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='j35osk80t1yd9wv9e10r9c66r0854187'          |
| 7921133 | ccpuser | localhost | clickcartpro | Query   | 176  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='r04ilc99d97wz86510563vge5s9f7w0q'          |
| 7921135 | ccpuser | localhost | clickcartpro | Query   | 176  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='1geqj319yy66qbd90j25dn1r5d9i8e3t'          |
| 7921136 | ccpuser | localhost | clickcartpro | Query   | 176  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='qw196mo6z3g072258427s992jqk1s4i2'          |
| 7921137 | ccpuser | localhost | clickcartpro | Query   | 175  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='s87884h0k0j22rr6hd643w9hog379j4v'          |
| 7921148 | ccpuser | localhost | clickcartpro | Query   | 171  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='66uu69nmc63f1f71v8d2w42100n63111'          |
| 7921149 | ccpuser | localhost | clickcartpro | Query   | 169  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='o8xa6c4ti8h5m0w59v2s4a098jfnsu68'          |
| 7921151 | ccpuser | localhost | clickcartpro | Query   | 167  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='gk72b51d0s3hpxr15m2icgvu8buu9xb1'          |
| 7921159 | ccpuser | localhost | clickcartpro | Query   | 166  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='4fn0p329l58n27pq52136943be20u0j7'          |
| 7921164 | ccpuser | localhost | clickcartpro | Query   | 165  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='xboybji72q188dl4ep6e29ju023tntlm'          |
| 7921170 | ccpuser | localhost | clickcartpro | Query   | 164  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='h2u6h0bwz1w72867617hlpfd1q41h28d'          |
| 7921196 | ccpuser | localhost | clickcartpro | Query   | 156  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='02tcz5x50yhq51y2p8f81513xoj56epc'          |
| 7921209 | ccpuser | localhost | clickcartpro | Query   | 152  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='h3337iqc63kyx013953ze3hgt74463bp'          |
| 7921212 | ccpuser | localhost | clickcartpro | Query   | 150  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='zzzor37c7y5s658rv4k518rg8qq7k314'          |
| 7921234 | ccpuser | localhost | clickcartpro | Query   | 142  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='y4l11kkynr2c0u7qb950v50699t38892'          |
| 7921240 | ccpuser | localhost | clickcartpro | Query   | 140  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='882v6u4ebl2p3368vh8vxly9s7ukfka6'          |
| 7921272 | ccpuser | localhost | clickcartpro | Query   | 126  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='a6kk7n67f1880x12fp965in44xdjqr6x'          |
| 7921278 | ccpuser | localhost | clickcartpro | Query   | 122  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='ysyjxhg5816yrulbka3092uata8i83a2'          |
| 7921282 | ccpuser | localhost | clickcartpro | Query   | 122  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7x8442uc9rlpaunc330c877zh8lcl0v6'          |
| 7921312 | ccpuser | localhost | clickcartpro | Query   | 112  | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='ovbm367654141cmp631v7l24g2ydf87v' O |
| 7921313 | ccpuser | localhost | clickcartpro | Query   | 112  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0n2963j4468lv1539769wp0ke4vzkqw9'          |
| 7921328 | ccpuser | localhost | clickcartpro | Query   | 101  | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='7q4iopc02939vr90gfsx707nrf4np5v9'          |
| 7921355 | ccpuser | localhost | clickcartpro | Query   | 91   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='1y3897fu12nq3y477h7kr0776e1o54o3'          |
| 7921363 | ccpuser | localhost | clickcartpro | Query   | 88   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='5707x8exc1vf77k1920ey7y959j8kb29'          |
| 7921364 | ccpuser | localhost | clickcartpro | Query   | 88   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='4j14u749v1l198aru091l9961r908885'          |ns WHERE id='4j14u749v1l198aru091l9961r908885'          |
| 7921437 | ccpuser | localhost | clickcartpro | Query   | 69   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='55wevm886191az0q22v0i15186y7e06r'          |
| 7921438 | ccpuser | localhost | clickcartpro | Query   | 68   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='osxph28l78r145afw70750w8i7qu5d3y'          |
| 7921505 | ccpuser | localhost | clickcartpro | Query   | 51   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='4i17lv0q2as6wb9wp097o4sk525pw90m'          |
| 7921514 | ccpuser | localhost | clickcartpro | Query   | 50   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0t37rpyq607311k9e7v3168mq5361oya'          |
| 7921516 | ccpuser | localhost | clickcartpro | Query   | 49   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='68925841935y553l1182y69o2k4d0526'          |
| 7921520 | ccpuser | localhost | clickcartpro | Query   | 47   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='c4744841n66vn10a2ip592f2hks2d688'          |
| 7921538 | ccpuser | localhost | clickcartpro | Query   | 44   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='d1bz6f2s223u67amx9oblngm73p2v1p1'          |
| 7921539 | ccpuser | localhost | clickcartpro | Query   | 44   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='908n60d6fp2c3p085g35v502ej7mki5t'          |
| 7921550 | ccpuser | localhost | clickcartpro | Query   | 41   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='0w047xo584r63j9g8m89dc2j11kp79x4'          |
| 7921562 | ccpuser | localhost | clickcartpro | Query   | 40   | Locked   | SELECT id, userid, data, lastaccess FROM khxc_sessions WHERE id='8458vq16u82i4r0pk1th966z1444dz4n' O |
| 7921615 | ccpuser | localhost | clickcartpro | Query   | 32   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='53r714076gy80p5g6cu3p4m49a4dwt45'          |
| 7921642 | ccpuser | localhost | clickcartpro | Query   | 26   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='k8vg432syvn5ps08vbg98175f97bxy63'          |
| 7921645 | ccpuser | localhost | clickcartpro | Query   | 25   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='eo84c46426l58212724xzm9739b890ws'          |
| 7921648 | ccpuser | localhost | clickcartpro | Query   | 24   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='15s44423nit7868e9i6i45745wap5q47'          |
| 7921701 | ccpuser | localhost | clickcartpro | Query   | 15   | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='1lcflar0282ch5p6231z861vd0t9vzl8'          |
| 7921720 | ccpuser | localhost | clickcartpro | Query   | 7    | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='c3yq2an69s6b92rsi81zq244dcbhskz0'          |
| 7921721 | ccpuser | localhost | clickcartpro | Query   | 5    | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='3f22j16c6m53f8e5060vy9ulwekw17f7'          |
| 7921722 | ccpuser | localhost | clickcartpro | Query   | 5    | Locked   | SELECT COUNT(*) AS khxccount FROM khxc_sessions WHERE id='4z8z307h6js34gpghw3904l16z0172jt'          |
| 7921739 | admin   | localhost |              | Query   | 0    |          | show processlist                                                                                     |
+---------+---------+-----------+--------------+---------+------+----------+------------------------------------------------------------------------------------------------------+
Uptime: 1878894  Threads: 200  Questions: 59009040  Slow queries: 1672  Opens: 13498  Flush tables: 1  Open tables: 400  Queries per second avg: 31.406

Offline

 

#3 02-15-2011 19:59:18

CrownRoyal
Member
Registered: 01-10-2009
Posts: 716

Re: suffering from locked tables in CCP

A side affect of this is the store is virtually inaccessible and its dragging down the rest of my server as well.

Offline

 

#4 02-16-2011 13:22:49

Design_Wholesale
Member
From: England!
Registered: 11-21-2008
Posts: 1104
Website

Re: suffering from locked tables in CCP

Usually when a table is locked it means that it is being written to, and it looks like something is overloading your MySQL server (okay, that part is obvious).

I have also noticed that you have been making several updates to your database recently, - have you tried rolling those changes back to eliminate them as a possible cause?

Also, is your database server accessible remotely, have you checked to ensure that you don't have any scripts in your webfolder (work in progress, etc.) that would give an attacker access to your database, and have you tried stopping the database and changing your login credentials?

Last edited by Design_Wholesale (02-16-2011 13:31:31)

Offline

 

#5 02-16-2011 13:42:41

CrownRoyal
Member
Registered: 01-10-2009
Posts: 716

Re: suffering from locked tables in CCP

Design_Wholesale wrote:

Usually when a table is locked it means that it is being written to, and it looks like something is overloading your MySQL server (okay, that part is obvious), but has this just started or is it something that has been building over, say, several days?

Been going on for weeks and months, off and on. Last week or so, it can be really bad like it was yesterday. Mostly involving CCP.

I have also noticed that you have been making several updates to your database recently, - have you tried rolling those changes back to eliminate them as a possible cause?

Changes being done are not reflective on store's db, although they run on the same server/engine. All changes are monitored for several days for performance issues.

Also, is your database server accessible remotely...,

All our web sites/dbs are remote. Our ISP does not allow servers to be run. We're in Canada, home to the highest ISP prices for the lowest services!!! sad  $115 a month I pay and the ISP has hourly caps on bandwidth. If i go over 100MB/hr, I am penalized with 1 hr of "dialup type" service. Oh Canada!

have you checked to ensure that you don't have any scripts in your webfolder (work in progress, etc.) that would give an attacker access to your database,

You are probably refering to local, not remote. With respect to remote, there are no sandbox environments.

and have you tried stopping the database and changing your login credentials?

Login creds for what?

Offline

 

#6 02-16-2011 13:51:21

Design_Wholesale
Member
From: England!
Registered: 11-21-2008
Posts: 1104
Website

Re: suffering from locked tables in CCP

Just a few ideas for things that have resolved issues with our server. - It also sounds as though you have a hosted site, - I found VPS prices for Canada to be quite reasonable compared with equivalent services in Britain.

...and you may not be able to run servers with your setup, but the database will still be running from a server and I strongly suspect that an overloaded server is responsible for the problems you are having.

Last edited by Design_Wholesale (02-16-2011 13:51:51)

Offline

 

#7 02-16-2011 14:21:11

CrownRoyal
Member
Registered: 01-10-2009
Posts: 716

Re: suffering from locked tables in CCP

I have a dedi serv in the US. Canadian prices are way way too expensive. Server bandwidth averages 10-12Gigs a day.
Its not unusal during the afternoon and evening to have 1,000 to 1,500 people online at any given time. I know that when I am monitoring the load via a SSH terminal window, all day long there's always a a slight overload to deal with. The cpu is a  dual core. Here's a snap shot of load average: 9.11, 7.26, 6.82. that's mild compared to peak times. No doubt its an overloaded server at times.

Offline

 

#8 02-16-2011 14:34:12

Design_Wholesale
Member
From: England!
Registered: 11-21-2008
Posts: 1104
Website

Re: suffering from locked tables in CCP

Knowing what you have just told me I would be looking to apply some kind of rate limiting to the database (changing the memory allocation, connection limits, etc.). - I don't know enough about MySQL to say how you would go about that for something the size of what you have, but that would seem to be the most sensible solution.

Offline

 

#9 02-16-2011 14:42:50

CrownRoyal
Member
Registered: 01-10-2009
Posts: 716

Re: suffering from locked tables in CCP

We already have tweaked the sql and apache for connections and memory allocs. We're pretty much maxed out the cpu which is why we may have to get a couple other servers just for the sql queries. Its got to happen anyway because we are adding new site services that will be sql intensive. I'm not savvy with tech aspects of servers, or efficient code for that matter. I'm the "idea guy". smile  I know one thing, it sure is difficult to find someone to do the work without them either a) wanting tens of thousands of dollars and/or b) wanting to grab copyrights on any code developed.  I don't mind paying fair wage for results but c'mon!

Offline

 

#10 02-16-2011 14:48:43

Design_Wholesale
Member
From: England!
Registered: 11-21-2008
Posts: 1104
Website

Re: suffering from locked tables in CCP

Well in my business I'm the ideas and the tech in one and, whilst I agree that the prices for even small tweaks are completely crazy, I can sympathise with the people working on some of these things. - Spending all day/night working with the things these people do, as a living, is certainly not something I would want to do as a living, even with the wage that some of them are on ...and I can understand the copyright thing ...if was you putting in several days/weeks to fix something on someone's server that could be deployed on thousands of other servers to fix similar problems I bet that you would want to copyright the software, too smile .

Anyway, I hope that the new setup fixes the problems for you and brings your database server back in line, too.

Last edited by Design_Wholesale (02-16-2011 14:53:04)

Offline

 

Board footer