MySQL Processes Locking Up

Print Thread

Hop To

Re: MySQL Processes Locking Up #38927 01/09/2004 10:58 AM
Joined: Jun 2006 Posts: 73 C cdavis journeyman
cdavis journeyman C Joined: Jun 2006 Posts: 73	Here's the process list as copied from phpMyAdmin. Notice that nearly every process is locked. This was copied while MySQL was not responding. 76134 root localhost ubb-realtree Query 567 Locked SELECT t1.Bo_Title, t1.Bo_Description, t1.Bo_Keyword, t1.Bo_Total, t1.Bo_Last, t1.Bo_Number, t1.Bo_Moderat 76151 root localhost ubb-realtree Query 581 Locked SELECT t1.Bo_Title, t1.Bo_Description, t1.Bo_Keyword, t1.Bo_Total, t1.Bo_Last, t1.Bo_Number, t1.Bo_Moderat 76157 root localhost ubb-realtree Query 582 Locked SELECT t1.Bo_Title, t1.Bo_Description, t1.Bo_Keyword, t1.Bo_Total, t1.Bo_Last, t1.Bo_Number, t1.Bo_Moderat 76158 root localhost ubb-realtree Query 644 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76160 root localhost ubb-realtree Query 598 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76161 root localhost ubb-realtree Query 598 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76162 root localhost ubb-realtree Query 598 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76164 root localhost ubb-realtree Query 644 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76165 root localhost ubb-realtree Query 598 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76166 root localhost ubb-realtree Query 598 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76167 root localhost ubb-realtree Query 598 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76168 root localhost ubb-realtree Query 598 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76169 root localhost ubb-realtree Query 598 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76170 root localhost ubb-realtree Query 644 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76172 root localhost ubb-realtree Query 644 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76177 root localhost ubb-realtree Query 644 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76180 root localhost ubb-realtree Query 644 Sorting result SELECT U_Username, U_Number FROM w3t_Users WHERE U_Approved = 'yes' ORDER BY U_Number DESC 76181 root localhost ubb-realtree Query 513 Locked SELECT COUNT( * ) FROM w3t_Users WHERE U_Approved = 'yes' 76183 root localhost ubb-realtree Query 518 Locked SELECT COUNT( * ) FROM w3t_Users WHERE U_Approved = 'yes' 76186 root localhost ubb-realtree Query 513 Locked SELECT COUNT( * ) FROM w3t_Users WHERE U_Approved = 'yes' 76188 root localhost ubb-realtree Query 511 Locked SELECT COUNT( * ) FROM w3t_Users WHERE U_Approved = 'yes' 76189 root localhost ubb-realtree Query 509 Locked SELECT COUNT( * ) FROM w3t_Users WHERE U_Approved = 'yes' 76190 root localhost ubb-realtree Query 503 Locked SELECT COUNT( * ) FROM w3t_Users WHERE U_Approved = 'yes' 76191 root localhost ubb-realtree Query 517 Locked SELECT COUNT( * ) FROM w3t_Users WHERE U_Approved = 'yes' 76193 root localhost ubb-realtree Query 586 Locked UPDATE w3t_Users SET U_SessionId = 'ff49cc40a8890e6a60f40ff3026d2730'WHE 76194 root localhost ubb-realtree Query 565 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76195 root localhost ubb-realtree Query 562 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76196 root localhost ubb-realtree Query 546 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76198 root localhost ubb-realtree Query 533 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76199 root localhost ubb-realtree Query 525 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76200 root localhost ubb-realtree Query 512 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76201 root localhost ubb-realtree Query 483 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76202 root localhost ubb-realtree Query 440 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76203 root localhost ubb-realtree Query 427 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76204 root localhost ubb-realtree Query 413 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76205 root localhost ubb-realtree Query 383 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76206 root localhost ubb-realtree Query 380 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76207 root localhost ubb-realtree Query 356 Locked SELECT U_Display, U_Groups, U_Sort, U_View, U_PostsPer, U_TempRead, U_FlatPosts, U_TimeOffset, U_Acti 76208 root localhost ubb-realtree Query 348 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76210 root localhost ubb-realtree Query 309 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76211 root localhost ubb-realtree Query 307 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76212 root localhost ubb-realtree Query 305 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76214 root localhost ubb-realtree Query 285 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76217 root localhost ubb-realtree Query 261 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76219 root localhost ubb-realtree Query 247 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76220 root localhost ubb-realtree Query 239 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76221 root localhost ubb-realtree Query 236 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76222 root localhost ubb-realtree Query 229 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76224 root localhost ubb-realtree Query 211 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76225 root localhost ubb-realtree Query 206 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76226 root localhost ubb-realtree Query 202 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76228 root localhost ubb-realtree Query 187 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76230 root localhost ubb-realtree Query 182 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76232 root localhost ubb-realtree Query 163 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76233 root localhost ubb-realtree Query 153 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76234 root localhost ubb-realtree Query 135 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76235 root localhost ubb-realtree Query 135 Locked SELECT U_Display, U_Groups, U_PostsPer, U_PicturePosts, U_FlatPosts, U_TempRead, U_TimeOffset, U_Show 76243 root localhost ubb-realtree Query 110 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76245 root localhost ubb-realtree Query 105 Locked SELECT U_Groups, U_TimeOffset, U_Display, U_Username, U_Password, U_SessionId, U_StyleSheet, U_Status, U_ 76246 root localhost ubb-realtree Query 98 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76247 root localhost ubb-realtree Query 97 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76248 root localhost ubb-realtree Query 82 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76249 root localhost ubb-realtree Query 79 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76250 root localhost ubb-realtree Query 76 Locked SELECT U_Display, U_Groups, U_PostsPer, U_PicturePosts, U_FlatPosts, U_TempRead, U_TimeOffset, U_Show 76251 root localhost ubb-realtree Query 67 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76253 root localhost ubb-realtree Query 53 Locked SELECT U_Display, U_Groups, U_PostsPer, U_PicturePosts, U_FlatPosts, U_TempRead, U_TimeOffset, U_Show 76255 root localhost ubb-realtree Query 36 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76259 root localhost ubb-realtree Query 29 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76260 root localhost ubb-realtree Query 22 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76261 root localhost ubb-realtree Query 18 Locked SELECT U_FrontPage, U_Groups, U_TimeOffset, U_Display, U_Favorites, U_WhichForums, U_Categories, U_Userna 76267 root localhost mysql Query 0

Entire Thread
Subject	Posted By	Posted
MySQL Processes Locking Up	cdavis	01/08/2004 5:34 PM
Re: MySQL Processes Locking Up	J.C.	01/08/2004 10:30 PM
Re: MySQL Processes Locking Up	cdavis	01/09/2004 2:58 PM
Re: MySQL Processes Locking Up	cdavis	01/10/2004 6:54 PM
Re: MySQL Processes Locking Up	J.C.	01/10/2004 11:22 PM
Re: MySQL Processes Locking Up	cdavis	01/11/2004 2:30 AM
Re: MySQL Processes Locking Up	J.C.	01/11/2004 3:23 AM
Re: MySQL Processes Locking Up	cdavis	01/12/2004 5:19 PM
Re: MySQL Processes Locking Up	Rick	01/12/2004 6:32 PM
Re: MySQL Processes Locking Up	cdavis	01/14/2004 2:17 PM
Re: MySQL Processes Locking Up	David Dreezer	01/14/2004 11:09 PM
Re: MySQL Processes Locking Up	cdavis	01/15/2004 1:24 PM
Re: MySQL Processes Locking Up	David Dreezer	01/15/2004 11:01 PM
Re: MySQL Processes Locking Up	johngibbons	03/01/2004 7:03 PM
Re: MySQL Processes Locking Up	Rick	03/01/2004 11:43 PM
Re: MySQL Processes Locking Up	johngibbons	03/02/2004 12:37 AM
Re: MySQL Processes Locking Up	johngibbons	03/02/2004 10:00 PM
Re: MySQL Processes Locking Up	Rick	03/03/2004 12:40 AM
Re: MySQL Processes Locking Up	johngibbons	03/04/2004 6:22 PM
Re: MySQL Processes Locking Up	JoshPet	03/05/2004 1:40 AM
Re: MySQL Processes Locking Up	johngibbons	03/08/2004 8:20 PM
Re: MySQL Processes Locking Up	JoshPet	03/09/2004 4:57 AM

Link Copied to Clipboard

ShoutChat

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support MySQL Processes Locking Up