Cliff,
- Original Message -
From: ""Cliff"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, March 13, 2004 11:32 PM
Subject: Re: InnoDB tables using 90% cpu
> Well I recompiled with Linuxthreads with the same result. I ran explain o
Chris Nolan" <[EMAIL PROTECTED]>
To: "Sasha Pachev" <[EMAIL PROTECTED]>
Cc: "Cliff" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 09, 2004 7:14 PM
Subject: Re: InnoDB tables using 90% cpu
> Sasha Pachev wrote:
>
> > Cliff
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 09, 2004 4:56 PM
Subject: Re: InnoDB tables using 90% cpu
> The query is running dramatically slower than the MyISAM query,
sometimes
> even causing mysql to freeze for a while. I searched this list and
found a
> few people saying that
Sasha Pachev wrote:
Cliff wrote:
The query is running dramatically slower than the MyISAM query,
sometimes
even causing mysql to freeze for a while. I searched this list and
found a
few people saying that on FreeBSD mysql should be compiled using linux
pthreads if you are using InnoDB or else I
Cliff wrote:
The query is running dramatically slower than the MyISAM query, sometimes
even causing mysql to freeze for a while. I searched this list and found a
few people saying that on FreeBSD mysql should be compiled using linux
pthreads if you are using InnoDB or else I would get this exact pr
this been resolved or is should I recompile? I am using native freebsd
threads.
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
To: "Cliff" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 08, 2004 9:18 AM
Subject: Re:
Cliff wrote:
Hi, I have a whole database I wanted to convert to InnoDB from MyISAM, but
do not want to use alter table because of the problems I had last time. I
made a whole dump of the table using mysqldump and changed all of the table
create definitions from MyISAM to InnoDB. Theoretically this
Hi, I have a whole database I wanted to convert to InnoDB from MyISAM, but
do not want to use alter table because of the problems I had last time. I
made a whole dump of the table using mysqldump and changed all of the table
create definitions from MyISAM to InnoDB. Theoretically this should be jus
