-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Curtis Maurand schrieb: > > I've been having the same trouble in a Xen virtual machine. After about > an hour and a half, mysql will be consuming 100% of cpu. There is > nothing wrong with the tables. I'm assuming its a dynamic vs. fix > amount of memory available to mysql. I'm guaranteed x amount of ram, > but that might get reduced due to server load. I'm assuming mysql > doesn't like having ram taken away from it and get into a tizzy about it. > > I've been forced to restart mysql hourly in order to get smooth operation.
You are dealing with the impact, not with the reason. It can only be a workaround. Did you have a look at you machine regarding paging activity? Uwe -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJJGHNwAAoJEEJXG7BUuynnZLwP/j2DaZ4ffqvQDXJm9xhpR8RR IX/X4eycsa42PAGCmvRkD10WgxTzTdIBA8euNX56sY8nS9GWanUzrBJ2fzmb6BKF Ype1HnyQfBjktTlAnb/WMZ0GfwTyL9+xPcD22lpaDSp4wlPvCq11TWMBDHC7HO3s 7VIMz44FTrgeiuNFOCv5ZPLRY1yIonJm7aJpUOdJE329zQmkkECOi7E0dQTGH9hi F5MWaymhIG4OrULiVbo+rBTzAhzHRYE7pv7y/q07vVLLpJ4mIM/9gBVS+p5ovrZE yskucJyvoMx9YUNx22iSUp5NhoA67RS2Ov5y1JdeVeKzFGIsxRziYx2BNXWJo+zl iY8XI5bcB2rx9wbmDqA413MyM/EdLlNmAUbwc4QnzIQLf7+cJ2u93FiZ0gtsNjWb d/r+thxO6EpOlnrkt9vn4pe9Rjp/7KYAOSTJz+FG2CP9fkpnrArMSoegDIZFxE6T s3NLmD5pPMdl1piwL5488F4f+AYuH5UNiZTOvbMr6NnQ9WL5LB1mDjRF+4/+BiW7 9nyfr7XcIdMWlED9dNR0fXU9rnbhi/ZOJhJbMFMKJaPPmZW6+cd7G5yqBe3UOGAd 3JD2IVPIz2NkpI1kGo4XnqxdAZS2/MXavDTVB+1tMOjMSkkJN5bkwRitZai9rb3Z Ca2df0HdK0T7tIC1Kxmq =5Xsj -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
