David,
I don't know the answers to your biggest problem, but do know the answer to
your last question: Yes, it seems perfectly normal to nail one CPU and take
2 minutes to show tables with 80,000 tables. Somewhere on your system is a
directory that has 240,000 files (80,000 tables times 3
I have run into an intermittent problem since one of our MySQL databases
grew over 5 GB. Basically, about once to twice a day the CPU will hit 100%
utilization (and stay there) and MySQL will stop accepting queries (I
couldn't even do a normal shutdown of MySQL). The problem happened more
Hi David,
DAVID DECESARE writes:
I have run into an intermittent problem since one of our MySQL databases
grew over 5 GB. Basically, about once to twice a day the CPU will hit 100%
utilization (and stay there) and MySQL will stop accepting queries (I
couldn't even do a normal shutdown of