mysql> mysql> show processlist; +-------+------------+------------------------------------+---------------+----- ----+------+----------------+--------------------------------------------------- ---------------------------------------------------+ | Id | User | Host | db | Comm and | Time | State | Info | +-------+------------+------------------------------------+---------------+----- ----+------+----------------+--------------------------------------------------- ---------------------------------------------------+ | 24785 | root | localhost:3408 | masterfulkids | Quer y | 4207 | NULL | show table status like 'b\_forums' | | 24786 | cvweb | esvr-web7:3913 | studio84k | Quer y | 4207 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24787 | cvweb | esvr-web7:3934 | studio84k | Quer y | 4199 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24788 | cvweb | esvr-web7:3967 | studio84k | Quer y | 4185 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24789 | cvweb | esvr-web7:3968 | studio84k | Quer y | 4182 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24790 | cvweb | esvr-web7:4039 | studio84k | Quer y | 4157 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24791 | cvweb | esvr-web7:4040 | studio84k | Quer y | 4152 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24792 | cvweb | esvr-web7:4041 | studio84k | Quer y | 4152 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24793 | cvweb | esvr-web7:4042 | studio84k | Quer y | 4151 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24794 | cvweb | esvr-web7:4043 | studio84k | Quer y | 4151 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24795 | cvweb | esvr-web7:4044 | studio84k | Quer y | 4151 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24796 | cvweb | esvr-web7:4045 | studio84k | Quer y | 4150 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24797 | cvweb | esvr-web7:4118 | studio84k | Quer y | 4118 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24798 | root | webecsbak1:4284 | mysql | Conn ect | NULL | login | NULL | | 24799 | lfcuser1 | esvr-web8:2722 | lfsqldb1 | Init DB | 4094 | NULL | NULL | | 24800 | cvweb | esvr-web7:4122 | studio84k | Quer y | 4088 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24801 | lfcuser1 | esvr-web8:2798 | lfsqldb1 | Init DB | 4082 | NULL | NULL | | 24802 | cvweb | esvr-web7:4161 | studio84k | Quer y | 4078 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24803 | lfcuser1 | esvr-web8:2928 | lfsqldb1 | Init DB | 4061 | NULL | NULL | | 24804 | cvweb | esvr-web7:4193 | studio84k | Quer y | 3998 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24805 | lfcuser1 | esvr-web8:3498 | lfsqldb1 | Init DB | 3995 | NULL | NULL | | 24806 | cvweb | esvr-web7:4225 | studio84k | Quer y | 3968 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24808 | cvweb | esvr-web7:4241 | studio84k | Quer y | 3937 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24809 | cvweb | esvr-web7:4305 | studio84k | Quer y | 3895 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24810 | cvweb | esvr-web7:4371 | studio84k | Quer y | 3865 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24811 | pawsclient | esvr-web6:1034 | pawssitedb | Init DB | 3849 | NULL | NULL | | 24812 | pawsclient | esvr-web6:1066 | pawssitedb | Init DB | 3840 | NULL | NULL | | 24813 | cvweb | esvr-web7:4884 | studio84k | Quer y | 3763 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24814 | cvweb | esvr-web7:4948 | studio84k | Quer y | 3748 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24815 | lfcuser1 | esvr-web8:2145 | lfsqldb1 | Init DB | 3676 | NULL | NULL | | 24816 | lfcuser1 | esvr-web8:2202 | lfsqldb1 | Init DB | 3671 | NULL | NULL | | 24818 | lfcuser1 | esvr-web8:2284 | lfsqldb1 | Init DB | 3657 | NULL | NULL | | 24819 | lfcuser1 | esvr-web8:2357 | lfsqldb1 | Init DB | 3655 | NULL | NULL | | 24820 | cvweb | esvr-web7:1112 | studio84k | Quer y | 3633 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24821 | cvweb | esvr-web7:1167 | studio84k | Quer y | 3619 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24822 | cvweb | esvr-web7:1221 | studio84k | Quer y | 3603 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24823 | cvweb | esvr-web7:1244 | studio84k | Quer y | 3582 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24824 | user | esvr-web9:1414 | exclusive | Quer y | 3529 | Opening tables | select count(*) from items where category='g_unit' | | 24825 | pawsclient | esvr-web6:2626 | pawssitedb | Init DB | 3503 | NULL | NULL | | 24826 | cvweb | esvr-web7:1313 | studio84k | Quer y | 3488 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24827 | cvweb | esvr-web7:1315 | studio84k | Quer y | 3478 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24828 | pawsclient | esvr-web6:2685 | pawssitedb | Init DB | 3473 | NULL | NULL | | 24829 | pawsclient | esvr-web6:2817 | pawssitedb | Init DB | 3434 | NULL | NULL | | 24830 | pawsclient | esvr-web6:3104 | pawssitedb | Init DB | 3401 | NULL | NULL | | 24832 | pawsclient | esvr-web6:3760 | pawssitedb | Init DB | 3306 | NULL | NULL | | 24833 | pawsclient | esvr-web6:3798 | pawssitedb | Init DB | 3300 | NULL | NULL | | 24834 | user | esvr-web9:1638 | exclusive | Quer y | 3298 | Opening tables | select count(*) from items where category='g_unit' | | 24835 | pawsclient | esvr-web6:4613 | pawssitedb | Init DB | 3151 | NULL | NULL | | 24837 | lfcuser1 | esvr-web8:1723 | lfsqldb1 | Init DB | 3062 | NULL | NULL | | 24838 | lfcuser1 | esvr-web8:1724 | lfsqldb1 | Init DB | 3058 | NULL | NULL | | 24839 | lfcuser1 | esvr-web8:1755 | lfsqldb1 | Init DB | 3054 | NULL | NULL | | 24840 | pawsclient | esvr-web6:1028 | pawssitedb | Init DB | 3051 | NULL | NULL | | 24841 | lfcuser1 | esvr-web8:1767 | lfsqldb1 | Init DB | 3050 | NULL | NULL | | 24842 | pawsclient | esvr-web6:1092 | pawssitedb | Init DB | 3016 | NULL | NULL | | 24843 | pawsclient | esvr-web6:2167 | pawssitedb | Init DB | 2917 | NULL | NULL | | 24844 | user | ip70-174-30-199.hr.hr.cox.net:3803 | exclusive | Quer y | 2877 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24845 | pawsclient | esvr-web6:2972 | pawssitedb | Init DB | 2845 | NULL | NULL | | 24846 | cvweb | esvr-web7:2448 | studio84k | Quer y | 2829 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24847 | cvweb | esvr-web7:2475 | studio84k | Quer y | 2798 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24848 | lfcuser1 | esvr-web8:2815 | lfsqldb1 | Init DB | 2795 | NULL | NULL | | 24850 | cvweb | esvr-web7:2485 | studio84k | Quer y | 2751 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24851 | user | ip70-174-30-199.hr.hr.cox.net:3807 | exclusive | Quer y | 2726 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24852 | cvweb | esvr-web7:2493 | studio84k | Quer y | 2721 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24853 | user | ip70-174-30-199.hr.hr.cox.net:3809 | exclusive | Quer y | 2693 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24854 | user | esvr-web9:2586 | exclusive | Quer y | 2547 | Opening tables | select count(*) from items where category='g_unit' | | 24855 | user | esvr-web9:2624 | exclusive | Quer y | 2514 | Opening tables | select count(*) from items where category='g_unit' | | 24856 | user | esvr-web9:2632 | exclusive | Quer y | 2505 | Opening tables | select count(*) from items where category='g_unit' | | 24857 | user | esvr-web9:2634 | exclusive | Quer y | 2503 | Opening tables | select count(*) from items where category='g_unit' | | 24858 | lfcuser1 | esvr-web8:4440 | lfsqldb1 | Init DB | 2492 | NULL | NULL | | 24859 | lfcuser1 | esvr-web8:4601 | lfsqldb1 | Init DB | 2473 | NULL | NULL | | 24861 | lfcuser1 | esvr-web8:4804 | lfsqldb1 | Init DB | 2445 | NULL | NULL | | 24862 | lfcuser1 | esvr-web8:1099 | lfsqldb1 | Init DB | 2414 | NULL | NULL | | 24863 | lfcuser1 | esvr-web8:1126 | lfsqldb1 | Init DB | 2402 | NULL | NULL | | 24864 | lfcuser1 | esvr-web8:1200 | lfsqldb1 | Init DB | 2393 | NULL | NULL | | 24865 | lfcuser1 | esvr-web8:1546 | lfsqldb1 | Init DB | 2379 | NULL | NULL | | 24866 | lfcuser1 | esvr-web8:1776 | lfsqldb1 | Init DB | 2365 | NULL | NULL | | 24867 | lfcuser1 | esvr-web8:2112 | lfsqldb1 | Init DB | 2337 | NULL | NULL | | 24868 | lfcuser1 | esvr-web8:2681 | lfsqldb1 | Init DB | 2280 | NULL | NULL | | 24869 | cvweb | esvr-web7:2853 | studio84k | Quer y | 2243 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24870 | cvweb | esvr-web7:2887 | studio84k | Quer y | 2212 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24871 | user | esvr-web9:2966 | exclusive | Quer y | 2200 | Opening tables | select count(*) from items where category='g_unit' | | 24872 | lfcuser1 | esvr-web8:4847 | lfsqldb1 | Init DB | 2174 | NULL | NULL | | 24875 | user | ip70-174-30-199.hr.hr.cox.net:3010 | exclusive | Quer y | 1807 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24876 | user | esvr-web9:3567 | exclusive | Quer y | 1740 | Opening tables | select count(*) from items where category='g_unit' | | 24878 | cvweb | esvr-web7:3667 | studio84k | Quer y | 1473 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24879 | cvweb | esvr-web7:3674 | studio84k | Quer y | 1444 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24880 | cvweb | esvr-web7:3675 | studio84k | Quer y | 1438 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24881 | cvweb | esvr-web7:3750 | studio84k | Quer y | 1341 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24883 | cvweb | esvr-web7:3991 | studio84k | Quer y | 1017 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24884 | cvweb | esvr-web7:4061 | studio84k | Quer y | 968 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24886 | lfcuser1 | esvr-web8:1654 | lfsqldb1 | Init DB | 909 | NULL | NULL | | 24887 | lfcuser1 | esvr-web8:1662 | lfsqldb1 | Init DB | 905 | NULL | NULL | | 24888 | lfcuser1 | esvr-web8:1668 | lfsqldb1 | Init DB | 900 | NULL | NULL | | 24889 | cvweb | esvr-web7:4617 | studio84k | Quer y | 807 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24890 | cvweb | esvr-web7:4621 | studio84k | Quer y | 777 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24891 | pawsclient | esvr-web6:2313 | pawssitedb | Init DB | 738 | NULL | NULL | | 24892 | pawsclient | esvr-web6:2351 | pawssitedb | Init DB | 722 | NULL | NULL | | 24893 | pawsclient | esvr-web6:2401 | pawssitedb | Init DB | 689 | NULL | NULL | | 24894 | cvweb | esvr-web7:4775 | studio84k | Quer y | 684 | Opening tables | SELECT sum(hits) AS count FROM jos_stats_agents WH ERE type='1' | | 24895 | pawsclient | esvr-web6:2500 | pawssitedb | Init DB | 668 | NULL | NULL | | 24896 | pawsclient | esvr-web6:2501 | pawssitedb | Init DB | 665 | NULL | NULL | | 24898 | pawsclient | esvr-web6:2510 | pawssitedb | Init DB | 660 | NULL | NULL | | 24899 | pawsclient | esvr-web6:2519 | pawssitedb | Init DB | 653 | NULL | NULL | | 24900 | pawsclient | esvr-web6:2520 | pawssitedb | Init DB | 652 | NULL | NULL | | 24901 | cvweb | esvr-web7:4777 | studio84k | Quer y | 636 | Opening tables | SELECT sum(hits) AS count FROM jos_stats_agents WH ERE type='1' | | 24902 | cvweb | esvr-web7:4778 | studio84k | Quer y | 632 | Opening tables | SELECT sum(hits) AS count FROM jos_stats_agents WH ERE type='1' | | 24903 | pawsclient | esvr-web6:2552 | pawssitedb | Init DB | 631 | NULL | NULL | | 24904 | pawsclient | esvr-web6:2555 | pawssitedb | Init DB | 629 | NULL | NULL | | 24905 | pawsclient | esvr-web6:2556 | pawssitedb | Init DB | 623 | NULL | NULL | | 24906 | pawsclient | esvr-web6:2560 | pawssitedb | Init DB | 607 | NULL | NULL | | 24907 | pawsclient | esvr-web6:2561 | pawssitedb | Init DB | 605 | NULL | NULL | | 24908 | cvweb | esvr-web7:4814 | studio84k | Quer y | 597 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24909 | pawsclient | esvr-web6:2568 | pawssitedb | Init DB | 593 | NULL | NULL | | 24910 | cvweb | esvr-web7:4851 | studio84k | Quer y | 560 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24911 | pawsclient | esvr-web6:2607 | pawssitedb | Init DB | 545 | NULL | NULL | | 24912 | pawsclient | esvr-web6:2608 | pawssitedb | Init DB | 533 | NULL | NULL | | 24913 | user | ip70-174-30-199.hr.hr.cox.net:3172 | exclusive | Quer y | 515 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24914 | pawsclient | esvr-web6:2642 | pawssitedb | Init DB | 514 | NULL | NULL | | 24915 | pawsclient | esvr-web6:2643 | pawssitedb | Init DB | 502 | NULL | NULL | | 24916 | user | ip70-174-30-199.hr.hr.cox.net:3173 | exclusive | Quer y | 495 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24917 | user | ip70-174-30-199.hr.hr.cox.net:3175 | exclusive | Quer y | 475 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24918 | pawsclient | esvr-web6:2729 | pawssitedb | Init DB | 471 | NULL | NULL | | 24919 | pawsclient | esvr-web6:2730 | pawssitedb | Init DB | 471 | NULL | NULL | | 24920 | user | ip70-174-30-199.hr.hr.cox.net:3176 | exclusive | Quer y | 460 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24921 | cvweb | esvr-web7:4892 | studio84k | Quer y | 440 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24922 | pawsclient | esvr-web6:2815 | pawssitedb | Init DB | 433 | NULL | NULL | | 24923 | cvweb | esvr-web7:4896 | studio84k | Quer y | 393 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24925 | user | ip70-174-30-199.hr.hr.cox.net:3181 | exclusive | Quer y | 311 | Opening table | SHOW TABLE STATUS FROM `exclusive` | | 24926 | cvweb | esvr-web7:1042 | studio84k | Quer y | 294 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24927 | cvweb | esvr-web7:1044 | studio84k | Quer y | 287 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24928 | cvweb | esvr-web7:1046 | studio84k | Quer y | 265 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24929 | masterful | esvr-web10:3127 | masterfulkids | Quer y | 216 | Opening tables | select distinct prog_id from program | | 24930 | lfcuser1 | esvr-web8:3671 | lfsqldb1 | Init DB | 188 | NULL | NULL | | 24931 | lfcuser1 | esvr-web8:3771 | lfsqldb1 | Init DB | 164 | NULL | NULL | | 24932 | lfcuser1 | esvr-web8:3773 | lfsqldb1 | Init DB | 162 | NULL | NULL | | 24933 | masterful | esvr-web10:3146 | masterfulkids | Quer y | 147 | Opening tables | select distinct prog_id from program | | 24934 | cvweb | esvr-web7:1173 | studio84k | Quer y | 119 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24935 | cvweb | esvr-web7:1174 | studio84k | Quer y | 117 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24936 | cvweb | esvr-web7:1175 | studio84k | Quer y | 112 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24937 | cvweb | esvr-web7:1177 | studio84k | Quer y | 106 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24938 | cvweb | esvr-web7:1179 | studio84k | Quer y | 97 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24939 | cvweb | esvr-web7:1180 | studio84k | Quer y | 95 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24940 | cvweb | esvr-web7:1184 | studio84k | Quer y | 91 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24941 | masterful | esvr-web10:3223 | masterfulkids | Quer y | 88 | Opening tables | select distinct prog_id from program | | 24943 | cvweb | esvr-web7:1233 | studio84k | Quer y | 65 | Opening tables | SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 | | 24945 | lfcuser1 | esvr-web8:4108 | lfsqldb1 | Init DB | 36 | NULL | NULL | | 24946 | root | localhost:3443 | NULL | Quer y | 0 | NULL | show processlist | +-------+------------+------------------------------------+---------------+----- ----+------+----------------+--------------------------------------------------- ---------------------------------------------------+ 147 rows in set (0.00 sec) mysql>