Announcement

#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

http://s01.geekpic.net/di-L89QI6.jpeg

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
192

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
191

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?

Offline

 

#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
13123

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.


Latest blog post (November 28th 2017) Server failures in october and november 2017

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2018 · Contact