Professional Web Applications Themes

Problem with very large tables in phpMyadmin - MySQL

Hi, we have tables with >100 mio rows. If we use phpMyadmin to display the darabase there is a far too long running query to count the rows of the table. Is there a easy way to accomplish this? How do i look whats the size of my MaxExactCount? Thanks, Toni -- Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner...

  1. #1

    Default Problem with very large tables in phpMyadmin

    Hi,

    we have tables with >100 mio rows.

    If we use phpMyadmin to display the darabase
    there is a far too long running query to count the rows of the table.

    Is there a easy way to accomplish this?

    How do i look whats the size of my MaxExactCount?

    Thanks,

    Toni

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

  2. #2

    Default Re: Problem with very large tables in phpMyadmin

    On 20 Feb, 09:56, "A. Dischner" <uni-muenchen.de>
    wrote: 

    If you are using MyISAM you could use the table_rows value from the
    information schema table

    http://dev.mysql.com/doc/refman/5.0/en/tables-table.html

    Captain Guest

  3. #3

    Default Re: Problem with very large tables in phpMyadmin

     

    Hmm. We are using InnoDB.

    Looking just for a way not to get stale with phpMyAdmin every thime we
    look into DB

    Thanks,

    Toni

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

Similar Threads

  1. Split large tables
    By Daniel Onnen in forum MySQL
    Replies: 1
    Last Post: March 8th, 08:10 PM
  2. Tables in phpmyadmin
    By Make it so! in forum Macromedia Dynamic HTML
    Replies: 2
    Last Post: March 1st, 05:22 PM
  3. Scalability with large numbers of tables
    By Phil in forum PostgreSQL / PGSQL
    Replies: 11
    Last Post: March 17th, 05:22 AM
  4. Replies: 5
    Last Post: February 16th, 09:04 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139