List:General Discussion« Previous MessageNext Message »
From:Vibol Hou Date:May 15 2001 12:45am
Subject:RE: Error 1049 - Unknown database...
View as plain text  
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.

Vibol Hou

-----Original Message-----
From: Vibol Hou [mailto:vhou@stripped]
Sent: Monday, May 14, 2001 4:54 PM
To: MySQL List
Subject: Error 1049 - Unknown database...


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

Before posting, please check:   (the manual)           (the list archive)

To request this thread, e-mail <mysql-thread73741@stripped>
To unsubscribe, e-mail <>
Trouble unsubscribing? Try:

Error 1049 - Unknown database...Vibol Hou15 May
  • Re: Error 1049 - Unknown database...Samuel Chen15 May
  • RE: Error 1049 - Unknown database...Vibol Hou15 May