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
frequently as the database grew over 6 GB. I end up rebooting the computer
each time this happens (since I can shutdown MySQL normally) and the problem
goes away for about 10 hours. Here's a list of what I am running:
MySQL version: mysql-3.23.36-sun-solaris2.7-sparc
OS: Solaris 8 (04/01)
System: SunFire 280; Single 750 MHz; 512 MB RAM; 18 GB 10,000 RPM
internal drive
Number of Tables in database: approx. 8,000
Last database size: 6.3 GB
The reason I think my problem has to do with the size of the database is
that we have another system that has not had any problems. It has ten times
the number of tables (about 80,000), but the database size is only 3.2 GB.
Again, no problems with this machine at all.
Has anyone else seen this problem? I would like to try version 3.23.43.
Unfortunately these are full production systems that I can't take offline
(and I don't have a spare SunFire). I've read about tables growing over 4 GB
so I don't know why I should be having this problem. My temporary fix is to
remove tables not immediately needed to keep the database size under 3 GB.
However we add about 500 MB of data every 24 hours so it doesn't last long.
(One other quick note: On the system with 80,000 tables, running "SHOW
TABLES" takes about 2 minutes on a dual SunFire box (maxing out one of the
CPUs). Is that amount of time normal? I know 80,000 tables is a lot, but
it's either that or create fewer tables having more than 1 billion rows
each.)
Thanks in advance for any help!
David DeCesare
_____________________________________________________________________
David DeCesare Email: mailto:[EMAIL PROTECTED]
Lifetouch Phone: (952) 826-5580
7800 Picture Drive Fax: (952) 826-4551
Minneapolis, MN 55439 Web: http://www.lifetouch.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
