CPU 100%

2002-09-26 Thread Peter Zuidema
Hello all, We use MySQL 3.23.51 on a NT Server and a Win2000 Server. On the Win2000 server all works fine. But wen we install MySQl on the NT Server CPU Usage goes through 100% for a while (20-30 seconds). What could be the reason of this? And how can we fix it? Regards Peter Zuidema [EMAIL

Performance problem

2002-10-24 Thread Peter Zuidema
about 10 seconds a cpu of 100%. We use MyISAM tables and have checked indexes and we have checked if tables need to be repaired. Is there someone who can give advise to get a better performance of mysql? Met vriendelijke groeten, IBT Groep BV, Peter Zuidema

RE: Performance problem

2002-10-24 Thread Peter Zuidema
ersnaam 26 a.UserCreated 1 aty eq_ref PRIMARY PRIMARY 8 a.AfspraakTypeID1 r eq_ref PRIMARY PRIMARY 8 a.RelatieID 1 -Original Message- From: Thomas Spahni [mailto:tsp@;lawb