OK.
so i'm working on a dedicated server. at the moment, this project is the only site running of the machine...i just viewed the process list and there are all kinds of processes which appear locked or timed out....one has a time value of nearly 2,000,000 seconds!
is it safe to kill these? what might be causing these problems?
this is from php myadmin:
ID User Host Database Command Time Status SQL-query
Kill 68739 root localhost myplan_1 Query 1995658 Copying to tmp table on disk SELECT DISTINCT t1.id, t1.name, u.name AS uber_name
FROM myplan_majors_category t1, myplan_majors_u
Kill 75770 wpphpadmin localhost None Sleep 1660 --- ---
Kill 75771 myplanadmin localhost myplan_1 Query 1660 Locked UPDATE myplan_majors SET title = 'Electroneurodiagnostic / Electroencephalographic Technology/Te
Kill 75772 myplanadmin localhost myplan_1 Query 1590 Locked Array
Kill 75773 wpphpadmin localhost None Sleep 1541 --- ---
Kill 75774 myplanadmin localhost myplan_1 Query 1541 Locked Array
Kill 75777 wpphpadmin localhost None Sleep 1516 --- ---
Kill 75778 myplanadmin localhost myplan_1 Query 1516 Locked Array
Kill 75781 wpphpadmin localhost None Sleep 1489 --- ---
Kill 75782 myplanadmin localhost myplan_1 Query 1489 Locked Array
Kill 75783 myplanadmin localhost myplan_1 Query 1432 Locked Array
Kill 75785 myplanadmin localhost myplan_1 Query 1418 Locked Array
Kill 75788 wpphpadmin localhost None Sleep 1393 --- ---
Kill 75789 myplanadmin localhost myplan_1 Query 1393 Locked Array
Kill 75798 wpphpadmin localhost None Sleep 1273 --- ---
Kill 75799 myplanadmin localhost myplan_1 Query 1273 Locked Array
Kill 75806 wpphpadmin localhost None Sleep 1124 --- ---
Kill 75807 myplanadmin localhost myplan_1 Query 1124 Locked Array
Kill 75810 myplanadmin localhost myplan_1 Query 515 Locked Array
Kill 75819 wpphpadmin localhost None Sleep 488 --- ---
Kill 75820 root localhost test Query 488 Locked Array
Kill 75823 myplanadmin localhost myplan_1 Query 399 Locked Array
Kill 75856 wpphpadmin localhost None Sleep 0 --- ---
Kill 75857 root localhost mysql Query 0 --- Array
