Welcome Guest, Not a member yet? Register   Sign In
Site Is So Slow!
#21

[eluser]Jay Logan[/eluser]
I ran that command with Putty on my Windows machine and this was the output:


Code:
login as: root
[email protected]'s password:
Last login: Thu Jan  8 13:07:57 2009 from 70.87.80.194
[root@stratus ~]# mysqladmin -u ptentry_dba -p processlist
Enter password:
+--------+-------------+-----------+---------------------+---------+------+-----                 -----------------+--------------------------------------------------------------                 ----------------------------------------+
| Id     | User        | Host      | db                  | Command | Time | Stat                 e                | Info                                                                                                                  |
+--------+-------------+-----------+---------------------+---------+------+-----                 -----------------+--------------------------------------------------------------                 ----------------------------------------+
| 103703 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 1442 | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 103805 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 1133 | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 103872 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 960  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 103878 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 941  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 103896 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 876  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 103964 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 645  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 103990 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 581  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 104108 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 252  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 104123 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 195  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 104130 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 182  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 104166 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 126  | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 104195 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 65   | Copy                 ing to tmp table | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 104215 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 38   | Lock                 ed               | UPDATE coaches SET roster = 'men' WHERE id = '1001363' LIMIT                  1                                       |
| 104234 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 4    | Lock                 ed               | SELECT *
FROM (`coaches`)
WHERE `id` = '1001363'                                                     |
| 104237 | ptentry_dba | localhost | ptentry_entrysystem | Query   | 3    | Lock                 ed               | SELECT Meet_Event.*, Event.*, COUNT(Meet_Athlete.id) AS Total                 , COUNT(Coach.id) AS Coach FROM meet_ev |
| 104239 | ptentry_dba | localhost |                     | Query   | 0    |                                       | show processlist                                                                                                      |
+--------+-------------+-----------+---------------------+---------+------+-----                 -----------------+--------------------------------------------------------------                 ----------------------------------------+
[root@stratus ~]#


Messages In This Thread
Site Is So Slow! - by El Forum - 01-09-2009, 08:20 AM
Site Is So Slow! - by El Forum - 01-09-2009, 10:47 AM
Site Is So Slow! - by El Forum - 01-09-2009, 02:10 PM
Site Is So Slow! - by El Forum - 01-09-2009, 03:23 PM
Site Is So Slow! - by El Forum - 01-12-2009, 09:02 AM
Site Is So Slow! - by El Forum - 01-12-2009, 09:30 AM
Site Is So Slow! - by El Forum - 01-12-2009, 10:23 AM
Site Is So Slow! - by El Forum - 01-12-2009, 10:27 AM
Site Is So Slow! - by El Forum - 01-12-2009, 11:46 AM
Site Is So Slow! - by El Forum - 01-12-2009, 11:58 AM
Site Is So Slow! - by El Forum - 01-12-2009, 12:04 PM
Site Is So Slow! - by El Forum - 01-12-2009, 12:10 PM
Site Is So Slow! - by El Forum - 01-12-2009, 12:36 PM
Site Is So Slow! - by El Forum - 01-12-2009, 12:55 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:02 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:03 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:03 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:06 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:09 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:16 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:17 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:23 PM
Site Is So Slow! - by El Forum - 01-12-2009, 01:35 PM
Site Is So Slow! - by El Forum - 01-12-2009, 02:07 PM
Site Is So Slow! - by El Forum - 01-12-2009, 03:52 PM
Site Is So Slow! - by El Forum - 01-12-2009, 04:28 PM
Site Is So Slow! - by El Forum - 01-12-2009, 05:00 PM
Site Is So Slow! - by El Forum - 01-12-2009, 05:28 PM
Site Is So Slow! - by El Forum - 01-12-2009, 05:45 PM
Site Is So Slow! - by El Forum - 01-12-2009, 06:20 PM
Site Is So Slow! - by El Forum - 01-12-2009, 06:47 PM
Site Is So Slow! - by El Forum - 01-12-2009, 07:21 PM
Site Is So Slow! - by El Forum - 01-12-2009, 09:38 PM
Site Is So Slow! - by El Forum - 01-13-2009, 03:22 AM
Site Is So Slow! - by El Forum - 01-13-2009, 04:13 AM
Site Is So Slow! - by El Forum - 01-13-2009, 06:14 AM
Site Is So Slow! - by El Forum - 01-13-2009, 07:20 AM



Theme © iAndrew 2016 - Forum software by © MyBB