There were 300 images in this gallery. I don’t know what you consider normal?
Hi @jondaley,
I’m not entirely sure I understand the issue. Is your hosting provider limiting database updates or the number of inodes?
Could you please share a screenshot of the error or show what it looks like on your end?
I am the host provider.
There isn’t really a screenshot, other than “mysqladmin processlist” shows 20 or 30 queries for updating the same wp_options key as mentioned above.
So, there aren’t any actual database limits in place, but I’m questioning a design decision to have over a million characters in one meta_value row – seems like there would be a better place to store all of those image names.
and the symptom was that the whole server’s CPU load went through the roof, because mysql was basically hung, due to timeouts, and then the user would reload the page when getting a 504 error, thus starting the whole gallery upload over again.
But, the other higher level question is – does your plugin support 300+ images per gallery? He has multiple galleries with that many images – I hadn’t noticed a problem before, so presumably it is fine, but I’m wondering what you consider “normal” and what would you consider “too many” photos in one gallery?
