List:General Discussion« Previous MessageNext Message »
From:Ryan McCullough Date:February 15 2005 12:13am
Subject:Re: queries slower on InnoDB
View as plain text  
what about other functions like doing a min() or max()? are those slow
limitations of innodb tables as well?


On Mon, 14 Feb 2005 15:52:21 -0600, Eric Bergen <eric.bergen@stripped> wrote:
> Total row count is cached in the header for MyISAM tables. InnoDB has
> no such mechanism for this because transactions make it impossible to
> keep an exact row count.  In order for InnoDB to get a row count it
> has to do a full scan inside a transaction which will take a long
> time. One way around this is to maintain row count in another table.
> 
> For show table status it's better to only check the tables you need.
> Example: show table status like 'my_table'
> 
> I'm not aware of any plans to speed up either of these commands on InnoDB.
> 
> 
> On Mon, 14 Feb 2005 12:06:09 -0500, Zhe Wang <zwang@stripped> wrote:
> > Hi, there,
> >
> >       I am in the middle of replacing a MyISAM database with InnoDB.
> > Queries "show table status" and "select count" are extremely slow which
> > gave me some pain. I am wondering if there are any other queries on
> > InnoDB that are significantly slower than those on MyISAM other than
> > these two? And does MySQL have any plan to speed up this kind of queries?
> >
> >       Thank you very much in advance for your reply!
> >
> > Regards,
> > Zhe
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >
> >
> 
> --
> Eric Bergen
> eric.bergen@stripped
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 


-- 
Ryan McCullough
mailto:rmccullough@stripped
Thread
queries slower on InnoDBZhe Wang14 Feb
  • Re: queries slower on InnoDBEric Bergen14 Feb
    • Re: queries slower on InnoDBRyan McCullough15 Feb
      • Re: queries slower on InnoDBEric Bergen15 Feb