Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5

Thread: InnoDB rows

  1. #1
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,169
    Thanks
    19
    Thanked 65 Times in 64 Posts

    InnoDB rows

    How can you tell how many rows are in an innodb table? I tried running a count(*) on it and it told me 467,535 but phpMyAdmin lists 802,759 and varies the cardinality of a unique field from 450k - 1.2million so is there any reliable way to tell how many rows there are?

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i never had any reason to distrust the returned value from a
    SELECT COUNT(*) FROM tablename
    for any storage-engine, so i'd rather trust that statistic then whatever phpmyadmin throws at you.

    why do you think this value would be incorrect for that innodb-table? just the phpmyadmin stats?
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #3
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,169
    Thanks
    19
    Thanked 65 Times in 64 Posts
    Yeah - just phpMyAdmin - with myIsam its usually fairly reliable. I guess that would explain why it timed out when I tried to look at pages that went beyond the actual number of rows

  • #4
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    phpmyadmin sure has it's flaws + it's ugly. (i try to never use it...)
    i'd trust what the commandline, MySQL Query Browser or query-tab gives you.
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #5
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,169
    Thanks
    19
    Thanked 65 Times in 64 Posts
    I like phpMyAdmin - less typing. Ok its not that pretty but it does its job


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •