Piwigo.org

ciel · 2015-01-20 11:04:05

Hello/Hi/Greetings,

How to split the table piwigo_images in Mysql? My site has almost 30 million images. And piwigo_images crashed sometimes. The tabel has been reached 69m size. Upload speed is very slow. Can I solve this problem by splitting the table?

Piwigo version: 2.7.3
PHP version: 5.2.17p1
MySQL version: 5.1.63
Piwigo URL: http://www.sxlux.com

mistic100 · 2015-01-20 11:08:34

Hello

splitting the table won't help in any way... It will even be slower because you will have three or more indexes instead of one (one for each sub-tables and one master)

what you have to do is optimize your MySQL server to support the load

I don't think anybody here can help but I know people achieved tables with billion records with very good performances, there are numerous articles on the net about that.

And perhaps the table lacks some indexes

plg · 2015-01-20 11:15:48

Hi ciel,

I have sent you an email. We can try different things to improve performances, but first we need to know which SQL queries are slow...

plg · 2015-01-20 11:23:48

Very first advice to improve performances : deactivate the random picture in the menu (provided by plugin Advanced Menu Manager)

ciel · 2015-01-20 12:02:59

plg wrote:
Very first advice to improve performances : deactivate the random picture in the menu (provided by plugin Advanced Menu Manager)

Thks. That would be good work for the speed. But did not solve the problem of slow upload.

By the way, When I batch upload 1000 pictures, there are always a few pictures with HTTP error icon. But when I seart them, find duplicate uploaded two. Does it matter with database overload?

flop25 · 2015-01-20 15:30:44

- slow queries can be easily tracked ; ask to your hoster or check slow_query log on google
- i don't thing slow upload is related but you can check what are the slowest query to be sure about that

Piwigo.org

Announcement

#1 2015-01-20 11:04:05

How to split the table piwigo_images in Mysql?

#2 2015-01-20 11:08:34

Re: How to split the table piwigo_images in Mysql?

#3 2015-01-20 11:15:48

Re: How to split the table piwigo_images in Mysql?

#4 2015-01-20 11:23:48

Re: How to split the table piwigo_images in Mysql?

#5 2015-01-20 12:02:59

Re: How to split the table piwigo_images in Mysql?

plg wrote:

#6 2015-01-20 15:30:44

Re: How to split the table piwigo_images in Mysql?

Board footer