Not sure how that happens, but I just ran into it on a couple images on my dev server the other day ironically. It means that some of images in the ewwwio table have larger optimized sizes than the originals. Like I said, no idea how that happens, if you can track down the images, and send me original copies of them (if you still have such a thing), I’ll double-check to make sure we aren’t missing something. Otherwise, just delete those records from the database, and it should fix things. I’ve already put a fix in dev to make sure those errors don’t break the savings counter (which is when they occur). You should be looking somewhere between record 46000, and 47000.
I tried to look at the record but it killing my eyes ~.~
Is there any sql code to let me easily to found out which image?
Thanks
I found another problem, I am using cloud optimize, and I found the usage go up so quick.
So I decide to use local server to process png optimize, but I found the png optimization use up all my cpu resource.
It seems keeping optimize something.
I tried reboot my server but it start optimize again after boot up.
I had changed to dev version 2.1.01 but it doesn’t help.
Do you have scheduled optimization turned on?
Try this for finding those images: SELECT * FROM wp_ewwwio_images WHERE image_size > orig_size
I discovered (using that query) the problem in my case was that I had optimized a them, and the author apparently replaced a few images with larger version, and then the next time I optimized them, the optimized size was larger than the original size from the first time they were optimized. That’s mostly speculation, as those are images I optimized a long time ago, so it is hard to say for sure.
No, I haven’t enable scheduled optimization.
So I am not sure what image was sent to the server
When I write this post, the image Cloud optimization rise from 5752 to 5754.
I found there are 53 images have this problem.
Most of them are resized image, but not all from same image.
For example, /wp-content/uploads/2014/07/Cloudflare-change-name-server-700×348.png . This image have problem, but onther size and original copy don’t have problem.
What plugins are you using? It sounds like one of them is generating resizes on the fly, which would kick off optimization as soon as you get any traffic. Not too big of a deal, unless it is not caching those resizes to disk properly (and I’ve seen plenty of plugins that do this).
I installed 2 plugins in last week, may be they are the source of problem.
1) Cachify
2) WordPress Social Sharing Optimization (WPSSO)
I will try to figure out which one cause the problem
