-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
I've got a small database (16 tables, a few thousand rows total) running 3.23.48-max w/ 3 of the tables Berkeley DB (for transactions) on Solaris 7/SPARC. One of these tables (the largest of the 3) has a little over 1,000 rows and occasionally sometime during the night when nobody is using the DB, MySQL get's really confused and fails to do any SELECT's against the table and thinks there are *10,000,000* rows (at least that's what PHPMyAdmin is reporting). Problem goes away once I restart mysqld and as far as I can tell, there's no corruption. I've checked the logs, and as far as I can tell the only thing that happens during the night is the backups. However, the backup scripts shutdown the daemon, do the backup, and then restart. I've verified the backup and mysql logs and it shows the daemon being stopped/started properly. I'm really at a loss to explain what's going on. Thoughts anyone? - -- Aaron D. Turner Security Architect, OneSecure http://www.onesecure.com/ [EMAIL PROTECTED] work: 408-992-8045 cell: 408-314-9874 pub 1024D/1B57EB4D 2000-09-27 Aaron D. Turner <[EMAIL PROTECTED]> Key fingerprint = F90C BFB4 4404 5504 295D 4435 578B 1DD5 1B57 EB4D All emails by me are PGP signed; an invalid signature indicates a forgery. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: Public key 0x1B57EB4D at: http://www.keyserver.net/en/ Filter: gpg4pine 4.1 (http://azzie.robotics.net) iEYEARECAAYFAjySVT8ACgkQV4sd1RtX600q4gCeI172L0PtL1M4UH8BQwjy/i9G NKQAn3ky3JMge21+h3zVrCFDka6aQryp =zQzD -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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