juanchi
05-17-2006, 09:23 PM
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.
| 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.