List:General Discussion« Previous MessageNext Message »
From:Daniel Kasak Date:March 26 2007 11:06pm
Subject:Re: Why doesn't the InnoDB count() match table status?
View as plain text  
Daevid Vincent wrote:

> Is mySQL planning on fixing this BUG. YES -- it is a BUG. A BIG FAT HARRY
> ONE. 
>   

I think you mean 'hairy', not 'harry'. There are no 'harry' bugs, apart 
from that British fool who's in line for the throne.

> It's completely stupid that I can't query and get an accurate total of
> records in a table in under a second.
>   

If it's so important to you, why not maintain your OWN count. Cache the 
figure somewhere, or update a figure when you insert a record.

> A deviation of 40-50% is SIGNIFICANT! 
> You might as well just use RAND() at that point.
>   

Fine. Use rand() if it makes you happy.

> This is absolutely baffling and astonishing how a company so seemingly smart
> could make such an incredible blunder.  :-\
>   

Oh the melodrama! Won't someone please think of the children!

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@stripped
website: http://www.nusconsulting.com.au
Thread
Why doesn't the InnoDB count() match table status?Daevid Vincent26 Mar
  • Re: Why doesn't the InnoDB count() match table status?Dan Nelson27 Mar
    • RE: Why doesn't the InnoDB count() match table status?Daevid Vincent27 Mar
      • Re: Why doesn't the InnoDB count() match table status?Dan Nelson27 Mar
        • RE: Why doesn't the InnoDB count() match table status?Daevid Vincent27 Mar
          • RE: Why doesn't the InnoDB count() match table status?Wm Mussatto27 Mar
          • Re: Why doesn't the InnoDB count() match table status?Jeremy Cole27 Mar
      • Re: Why doesn't the InnoDB count() match table status?Daniel Kasak27 Mar
        • RE: Why doesn't the InnoDB count() match table status?Daevid Vincent27 Mar
        • Re: Why doesn't the InnoDB count() match table status?Maciej Dobrzanski27 Mar
          • RE: Why doesn't the InnoDB count() match table status?Tim Lucia27 Mar
            • Re: Why doesn't the InnoDB count() match table status?Jochem van Dieten27 Mar