I'm going to add that there is nothing wrong with the database name that is
in the query. If the same query, with slightly different constraints and
the _exact_ same database name, is run 1000 times and 3 of them give the
Unknown database error, that rules out an application error.
Furthermore, if it is a SQL error, then MySQL would likely return an error
that indicates a SQL error rather than an Unknown database error.
Thanks,
--
Vibol Hou
KhmerConnection
http://khmer.cc
-----Original Message-----
From: Vibol Hou [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 4:54 PM
To: MySQL List
Subject: Error 1049 - Unknown database...
Hi,
I have a MySQL 3.23.37 server that runs on a FreeBSD 4.2 SMP box which runs
some semi-intensive web applications. The system itself has 1GB memory.
A few times a minute, I get the following error from my applications:
MySQL Error: 1049 (Unknown database 'databasename')
The server receives about 105 queries/sec. The queries range from simple
select statements to joins between several tables on databases no larger
than a total of 800MB and also include insert, delete, and update
statements. A good mix of everything.
The application is able to connect, but the queries run against the database
indicate the above error 2-3 times a minute.
I've experienced this with 3.23.32 as well and upgraded to 3.23.37.
Does anyone experienced with MySQL internals know what's going on?
--
Vibol Hou
KhmerConnection
http://khmer.cc
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
