Al Bundy Al Bundy - 1 year ago 117
MySQL Question

Weird table size in PhpMyAdmin database overview

This problem persists since "years". Currently I have PMA 4.6.1. The values under the

Size
column have very weird values. I could not find anything regarding this in the internet.

Metro
theme:
enter image description here

Original
theme:
enter image description here

Any idea what is going wrong?

Update:

The table
app_codes
has this structure and as you can see it has only 2 rows.
enter image description here

When you check the displayed number you see the decimal point is before the thousand separator...

Update:

As suggested I ran the
repair
command but
app_codes
did not really changed.
app_codes_items
seems to be fixed.
enter image description here

Update:

As requested the output for
SHOW TABLE STATUS
:
enter image description here

Answer Source

The developer nijel posted my question as issue on github and he mentioned something regarding rounding problem.

I remembered that I have in my php.ini this setting: precision = 20

After playing around I found out that the value of 20 causes this issue. Up to the value 16 the size is displayed correctly. Above 16 the weird size output starts.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download