ChronoMyAdmin

Update table statistics after truncating in ChronoMyAdmin.

Overview

The row count and size values displayed do not update immediately because the database caches table statistics.
Wait for the database to automatically update its statistics cache, or manually trigger a statistics update to see the correct values.

Answered
Bugs
Jo JoCo 28 Dec, 2024

Hello Max,

i installed ChronoMyAdmin. Very nice and helpful tool.

I truncate a table. The table has 2 rows but the value for rows and size are not changed. 

Still the old values.

ChronoMyAdmin image 1

ChronoMyAdmin image 2

Jo JoCo 29 Dec, 2024

Hello Max,

don't bother trying to fix this. I see the same problem in PhpMyAdmin.

So your extension works fine.

Max_admin Max_admin 30 Dec, 2024

What is the error when trying to truncate in phpmyadmin ? by default the truncate should work fine

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Jo JoCo 30 Dec, 2024

Hello Max,

as I already indicated, in phpmyadmin and ChronoMyAdmin the truncate worked but the value for the number of rows and size did not changed.

I look now and i see the value for rows and size are correct.

ChronoMyAdmin works fine. No problems.

Max_admin Max_admin 30 Dec, 2024
Answer

the value of rows number and size is cached in the database, so it does not change unless the tables statistics are updated

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.