Menu

#2556 (ok 2.11.2) Wrong database Size

2.11.1.1
fixed
Interface (555)
1
2013-06-11
2007-10-16
warforge00
No

This morning I checkout out the size of the database and noticed something strange about the size column.

76 table(s) Sum 10,028,725 MyISAM latin1_swedish_ci 0.0 k GiB 29.1 KiB

Notice the Summary Size is 0.0 k GiB???

Discussion

  • warforge00

    warforge00 - 2007-10-16
    • labels: --> Interface
    • milestone: --> 2.11.1.1
     
  • Sebastian Mendel

    • status: open --> pending
     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    version of PHP and MySQL?
    can you attach a screenshot or paste the whole table?

     
  • warforge00

    warforge00 - 2007-10-16

    Database Size

     
  • warforge00

    warforge00 - 2007-10-16
    • status: pending --> open
     
  • warforge00

    warforge00 - 2007-10-16

    Logged In: YES
    user_id=1914403
    Originator: YES

    MySQL: 5.0.48
    PHP: 5.2.4
    File Added: database_size.jpg

     
  • warforge00

    warforge00 - 2007-10-16

    Logged In: YES
    user_id=1914403
    Originator: YES

    Here's the sizes of the tables listed...

    1.0 KiB
    1.0 KiB
    1.0 KiB
    42.7 KiB
    7.9 KiB
    14.2 KiB
    71.6 KiB
    707.5 KiB
    9.1 KiB
    14.0 MiB
    1.6 MiB
    24.5 MiB
    107.9 MiB
    1.0 KiB
    129.3 KiB
    4.4 MiB
    9.2 KiB
    398.9 KiB
    129.0 MiB
    1.0 KiB
    11.8 MiB
    10.6 MiB
    60.4 MiB
    58.5 MiB
    1.0 KiB
    8.7 MiB
    10.2 MiB
    17.8 MiB
    2.6 KiB
    12.0 MiB
    3.4 MiB
    1.0 KiB
    1.0 KiB
    1.0 KiB
    1.0 KiB
    2.1 KiB
    1.0 KiB
    4.8 KiB
    3.5 KiB
    1.0 KiB
    1.0 KiB
    3.1 KiB
    6.4 KiB
    5.7 KiB
    1.0 KiB
    4.5 MiB
    1.0 KiB
    51.0 KiB
    19.6 KiB
    524.7 KiB
    2.1 KiB
    2.1 KiB
    151.4 KiB
    224.2 KiB
    1.0 KiB
    1.0 KiB
    400.8 KiB
    1.0 KiB
    13.7 MiB
    74.9 MiB
    65.3 MiB
    46.4 MiB
    2.5 MiB
    85.8 MiB
    47.2 MiB
    145.8 MiB
    93.7 KiB
    1.0 KiB
    1.0 KiB
    2.0 KiB
    58.6 KiB
    1.0 KiB
    35.8 KiB
    146.7 KiB
    33.9 KiB
    36.2 KiB
    16.9 KiB

     
  • Sebastian Mendel

    Logged In: YES
    user_id=326580
    Originator: NO

    cannot reproduce

    can you please add some code on file ./db_structure.php
    after line #403: list($sum_formatted, $unit) = PMA_formatByteDown($sum_size, 3, 1);

    please add:
    var_dump($sum_size);
    var_dump($sum_formatted);

    and post the output here?

    and which of the following pow function does your system support: pow(), bcpow() and/or gmp_pow()?

     
  • Sebastian Mendel

    • status: open --> pending
     
  • warforge00

    warforge00 - 2007-10-17
    • status: pending --> open
     
  • warforge00

    warforge00 - 2007-10-17

    Logged In: YES
    user_id=1914403
    Originator: YES

    float(1003077684) string(5) "0.0 k"

    pow() and gmp_pow() are supported
    bcpow() is undefined

     
  • Marc Delisle

    Marc Delisle - 2007-10-20
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2007-10-20

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2007-10-20
    • summary: Database Size --> (ok 2.11.2) Wrong database Size
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-10-27
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed