I'm experiencing the same problem. Everytime when I shut down mysql and use
myisamchk to do the maintenance, I'll get a few tables crashed. In
phpmyadmin they showed a status of in use. I have to repair them to get
the db working.
Rainer
- Original Message -
From: Brian Moon [EMAIL
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there are 450
concurrent uers hanging on the site. Mytop showed that the queries per second maxed at
500. I believe this could be higher, provided that I have it running on a
modules with 1G modules). In fact
there are always about 5-800MB of unused/buffered memory. The machine is
equipped with hardware raid, and 4 19GB SCSI disks.
Cheers,
Rainer
- Original Message -
From: Rainer Sip [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 5
19.21 42.54
12:00:01 HK all 57.51 0.00 28.40 14.09
12:10:00 HK all 50.69 0.00 26.55 22.76
Average: all 15.37 0.00 7.33 77.30
- Original Message -
From: David Griffiths [EMAIL PROTECTED]
To: Rainer Sip [EMAIL
Hi there,
This is my first message to this mailing list.
I just upgraded Mysql from 3.23.54 to 4.0.14. Everything were fine after the upgrade,
but I experienced something strange:
- When I telnet to the localhost, the response says 3.23.54 is running.
- However, when I do a mysqladmin -V, it