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.
Unimin Corporation - Spruce Pine
"Ulrich Seppi" <seppi@stripped> wrote on 10/13/2004 12:29:22 PM:
> >> does anybody know if Foreign keys increase the performance of select
> >> 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 I have the hole database with MyIsam tables but there is
> much data on it.
> I have more tables with over 500.000 record and over 100 MB but until
> all queries are fast.
> The problem is that sometime happens that tables are corrupt and I have
> REPAIR they.
> (mysql 4.1.5).
> All operations on the corrupt tables until REPAIR will fail and this is
> big problem because
> more hundred people are working on the database at the same time and
> much data will be lost.
> Now, I tried on a testdatabase to convert the tables to InnoDB to be
> stable and to have
> transactions. The result is that all operations (select queries) are
> verry slow.
> Not as fast as on MyISAM.
> How could I increase the performance of my InnoDB, now? I hoped that it
> could be done with
> foreign keys but it not seems so...
> does anybody have other ideas for solving the problem?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1