RE: CPU intensive query

2002-02-25 Thread Tauren Mills
a problem with the java connection to it for now. Unless what I've sent above raises any concerns for anyone on the list. Tauren > On Mon, Feb 25, 2002 at 03:24:25PM -0800, Tauren Mills wrote: > > I am hosting websites that use the mysql database. One of my > customers has &

CPU intensive query

2002-02-25 Thread Tauren Mills
I am hosting websites that use the mysql database. One of my customers has a query that they run occasionally that really bogs down the entire server. The load sometimes jumps up into the double digits (on a Red Hat 6.2 server). Here is their query: select count(*) from aptreviews, aptcomplexes

Server configuration denies access to the data source

2001-02-15 Thread Tauren Mills
Within the last few days we've started having serious problems with our database. We have no problems connecting to it using "mysql" and "mysqladmin". For instance, this command lets us into the database just fine: mysql -ucustomer -p customer_database The database seems to be working correctly