Hello all,
MySQL 3.23.51 Apache 1.3.26 In my php connection to MySQL I send a message if there is a problem. Today for the first time in 3 years of MySQL/Apache use I received the following error message: [26-Sep-2002 15:49:14] ERROR: Couldn't connect to the DB while drawing the main page quicklinks. Unknown database 'ADMIN' [26-Sep-2002 18:41:41] ERROR: Couldn't connect to the DB while drawing the main page quicklinks. Unknown database 'ADMIN' Yet any other time or when I connect manually to the database, it's there: mysql> use ADMIN; Database changed mysql> show tables; +-----------------+ | Tables_in_ADMIN | +-----------------+ | QUICKLINKS | +-----------------+ 1 row in set (0.00 sec) The only thing I could see off the top is the duplicate times of connection (My Apache Logs in both cases showed duplicate timestamps), but this can't be? It connected, just couldn't talk to the Database... I/O issue? The database server is on a PII 450 with 384MB's of ram. 100Mb/s Full-Duplex running SCSI-3... FreeBSD 4.6.2-RELEASE. Data is the only thing using that drive. My Cron job showing uptime shows 0.00 0.00 0.00 across the board with little spiking, and then only to 0.02 - 0.04. MySQL status: Threads: 1 Questions: 1860358 Slow queries: 5 Opens: 2004 Flush tables: 1 Open tables: 256 Queries per second avg: 0.524 MySQL show status: | Table_locks_immediate | 3052077 | | Table_locks_waited | 0 | | Open_tables | 256 | <-- This??? | Open_files | 479 | | Opened_tables | 2004 | Any suggestions? Did I run out of file descriptors? Currently some sysctl's are: kern.maxfiles: 13542 (Max can be: 65536) kern.maxfilesperproc: 12187 (Max can be: 32768) Thank you in advance... Rob B. --------------------------------------------------------------------- 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
