Hi, please monitor what happened with mysql
show processlist
show innodb status
and also ps aux
because maybe some application makes your mysql busy
On Jan 2, 2008 7:31 AM, Gunnar R. <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am running a community site mainly based on phpBB. It has about 9.300
Hi,
On Jan 1, 2008 6:22 PM, Miguel Vaz <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am trying to import a big database of around 140 tables from xls
> to mysql. It works fine using navicat mysql, but i am running into a problem:
>
> Navicat tries to predict the field types, but
Hi,
On Jan 1, 2008 6:31 PM, Gunnar R. <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am running a community site mainly based on phpBB. It has about 9.300
> registered users, 650.000 posts and about 200.000 visitors/month (12 mill
> "hits"). The SQL database is about 700MB.
>
> It's all running on a co
I'm using pretty standard approach to sorting search results by relevancy:
SELECT DISTINCT product_name,
MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS
rate
FROM _TT
WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN
MODE ) >0
ORDER BY rate DES
Hello,
I am running a community site mainly based on phpBB. It has about 9.300
registered users, 650.000 posts and about 200.000 visitors/month (12 mill
"hits"). The SQL database is about 700MB.
It's all running on a couple of years old Dell box with two P4 Xeon 1.7Ghz
CPUs, 1GB of RAMBUS memory
Hi,
I am trying to import a big database of around 140 tables from xls
to mysql. It works fine using navicat mysql, but i am running into a problem:
Navicat tries to predict the field types, but makes a mistake on
long text fields whose type needs to be "text", instead it m
I really hope I'm not overlooking something simple...
I'm writing a cleanup script to remove database items created by my
application. One of the things I would like to remove are all user
accounts created through my application... This is proving to be
harder than it sounds.
I should note that i
