Al Bundy Al Bundy - 5 months ago 12
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

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.

Comments