Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Does MySQL have meta-tables?

    I have a number of large tables (who doesn’t) and often need to pick the smallest of a subset of these. Does MySQL store any kind of system meta-table with information on the size of user-created tables? Then I could query that instead of re-counting each row each time I need to find the smallest. How is this information best accessed?

    Many thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    MySQL doesn't expose any MetaData that I know about, but I'd love to hear if you find any!

    -PatP

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Just because a table has the "smallest" row count, does NOT mean that this table is necessarily the smallest in total size.
    A table with only two rows which contain "large" BLOB datatypes
    could easily be the largest table in the DB.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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