List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:February 15 2005 12:40am
Subject:Re: queries slower on InnoDB
View as plain text  
min() and max() can use indexes so they shouldn't be slower. 


On Mon, 14 Feb 2005 17:13:07 -0700, Ryan McCullough
<rmccullough@stripped> wrote:
> 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
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
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