Hi.
I ask for help from Piwigo developers, as well as from advanced users of this script.
Periodically, additional tables of this type are created in my database:
piwigo_images_xxxxxxxxxxxxxxxx
piwigo_user_cache_categories_xxxxxxxxxxxxxxxx
(where instead of xxxxxxx are numbers)
For example:
piwigo_images_1515692595958460
piwigo_user_cache_categories_1516439593141910
Because of these tables, I often do not have a website.
Why are they created?
What are they created?
Do they really need it?
How can I turn them off or get rid of them?
Piwigo 2.9.2
Operating System: Linux
PHP: 7.0.12
MySQL: 5.5.5-10.1.20-MariaDB
Image Library: ImageMagick 6.7.8-9
Last edited by alekseen (2018-01-30 19:17:42)
Offline
I checked my database, and I don't have the tables with xxxxx numbers in the name. "cache" suggests they were created to speed up loading time. Are they still persisting? Perhaps something is preventing them from being deleted when they're no longer needed. Did you give the piwigo user full access to the DB?
alekseen wrote:
Because of these tables, I often do not have a website.
Can you please elaborate on this?
Offline
Definitely seems suspicious ... I've never seen these "extra" tables appear in my piwigo databases.
Maybe they have something to do with MySQL maintenance jobs (like integrity checks?) or upgrades?
Offline
executive wrote:
I checked my database, and I don't have the tables with xxxxx numbers in the name. "cache" suggests they were created to speed up loading time. Are they still persisting? Perhaps something is preventing them from being deleted when they're no longer needed. Did you give the piwigo user full access to the DB?
alekseen wrote:
Because of these tables, I often do not have a website.
Can you please elaborate on this?
In my gallery there are 110,000 photographs and attendance of about 2000 people per day. Perhaps that's why there are extra tables.
Periodically I go to phpMyAdmin and manually delete extra tables.
Now I do not watch them.
The database user has full access to the database.
As soon as once again the site breaks and errors appear, I'll show you the screenshots.
Offline
windracer wrote:
Definitely seems suspicious ... I've never seen these "extra" tables appear in my piwigo databases.
Maybe they have something to do with MySQL maintenance jobs (like integrity checks?) or upgrades?
In order for my site to work more or less normally, I have to periodically log into the "Service" and perform "correct and optimize the database", as well as other items.
The size of my database is 80-130 megabytes, so there are constant problems with it.
Offline
These tables are created by Piwigo by the mass_updates function. They are temporary, ie you should never see them in PhpMyAdmin. If they are still visible, it means the update operation failed and these tables are no longer useful. You can delete them.
Offline