Baron,
Thanks alot for your reply - I am trying out these tools today.
Lukas
Lukas C. C. Hempel
CEO
Delux Group - Approaching future.
www.delux.me
Postfach 10 02 10
D-48051 Münster
Mail: lu...@delux.me
This e-mail may contain confidential and/or privileged in
If you could post your table schema (SHOW CREATE TABLE table_name) and
then give an example of the query that is slow on InnoDB that would help
us give a better analysis. Right now it sounds like something is wrong,
InnoDB is likely to be slightly slower than MyISAM because of
transaction overhead
Suggestions? Check your indexes. It sounds as though they aren't what they
used to be. When you converted to InnoDB, did you accidentally move the
data to a slower drive? If so, you may want to move it back to where you
had the MyISAM tables.
Shawn Green
Database Administrator
Unimin Corporatio
HELLO
>> does anybody know if Foreign keys increase the performance of select
querys?
>> example.
>> DB1 has only INNODB tables.
>> DB2 has the same structure as DB1 with all possible foreign keys.
>>
> is the same query faster on DB1 or DB2?
>
>Why should it increase performance?
At the moment
thanks a lot, I managed it now.
was just a little misconfigured my.cnf-file
> -Ursprüngliche Nachricht-
> Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 19. Februar 2003 14:34
> An: [EMAIL PROTECTED]
> Betreff: re: InnoDB
>
>
> On Wednesday 19 February 2003 13
to another tablespace.
Regards,
Christian
-Ursprungliche Nachricht-
Von: Rick Flower [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. Marz 2002 19:17
An: MySQL Mailing List
Cc: Heikki Tuuri
Betreff: AW: InnoDB frightens me...
Christian Rabe writes:
>Are there plans on creating more than o
Christian Rabe writes:
>Are there plans on creating more than on tablesspace plus making them
>selectable ?
>So that I can tell the DB:
>- in which datafiles to store the tablespace X
>- in which tablespace to store table Y
This is one of the things I was wondering about.. If I have multiple Inn
Hi :)
Are there plans on creating more than on tablesspace plus making them
selectable ?
So that I can tell the DB:
- in which datafiles to store the tablespace X
- in which tablespace to store table Y
With MYISAM we could simply move the data+index files to a separate disc,
create symlinks and
