🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#1 2018-01-30 19:01:52
- alekseen
- Member
- 2018-01-30
- 3
Extra tables piwigo_images_ in the MySQL database
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
#2 2018-01-30 21:20:46
- executive
- Member
- 2017-08-16
- 1214
Re: Extra tables piwigo_images_ in the MySQL database
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
#3 2018-01-30 22:17:05
- windracer
- Member
- St. Pete, FL
- 2014-12-28
- 448
Re: Extra tables piwigo_images_ in the MySQL database
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?
Online
#4 2018-02-01 01:18:22
- alekseen
- Member
- 2018-01-30
- 3
Re: Extra tables piwigo_images_ in the MySQL database
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
#5 2018-02-01 01:25:33
- alekseen
- Member
- 2018-01-30
- 3
Re: Extra tables piwigo_images_ in the MySQL database
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
#6 2018-02-01 11:58:22
- plg
- Piwigo Team
- Nantes, France, Europe
- 2002-04-05
- 13791
Re: Extra tables piwigo_images_ in the MySQL database
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