![]() |
Mysql problem with a table
I noticed in the last days that my server was experiencing high loads to the point that the server was unresponsive, I started looking at Top and there where many mysql processes, and I took at the process list, and this is what I found:
| 4315 | xxxxxx | localhost | xxxxxxx | Query | 0 | Locked | UPDATE vbb_games_league SET mid='2122',gid='16',position='1560',points='0',cat ='1' WHERE gid=16 AND | | 4411 | xxxxxx | localhost | xxxxxxx | Query | 0 | Locked | UPDATE vbb_games_league SET mid='1831',gid='16',position='1476',points='0',cat ='1' WHERE gid=16 AND | The list contain many process like the ones above running and running and I don't see what they mean or if this o.k., honestly I don't think so, the only thing that I know is that it is putting my server in a heavy load, anyone know how can I fix this? Thanks. The size of the record of the table is 530,994, right now, and increasing by the second. Is this o.k. |
All times are GMT. The time now is 05:14 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|