Plugin Contributor
cageehv
(@cageehv)
Hi Spiril,
Do you happen to know which version of MySQL is being used?
Best,
Rolf
Thread Starter
Spiril
(@spiril)
Hi Rolf,
Thanks for your speedy reply! I found this in phpMyAdmin:
Database server
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.32-cll – MySQL Community Server (GPL)
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
Web server
cpsrvd 11.38.2.3
Database client version: libmysql – 5.0.96
PHP extension: mysql Documentation
Maybe that can help you?
Thanks again.
Plugin Contributor
cageehv
(@cageehv)
Hey,
What do you get when running the following query (PHPMyAdmin):
SELECT SUM(data_length + index_length) size
FROM information_schema.TABLES
WHERE table_schema = 'xxxxxxxxxxxxx'
GROUP BY table_schema
(replace the xxxxxxxxxxxxx with the name of your database)
Rolf
Thread Starter
Spiril
(@spiril)
Hey,
I get this:
“This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.”
and below that:
“Size:
3411671″
Do you think I did something wrong? I replaced xxxxxxxxxxxxxx with the name of my database (copy/pasted it from the line above the query field: “SQL query on database: mydatabasename” so it should be the right one…)
Plugin Contributor
cageehv
(@cageehv)
Weird, that warning…
Can you please try the following query:
SELECT sum( ist.data_length + ist.index_length ) size
FROM information_schema.TABLES ist
WHERE ist.table_schema = 'xxxxxxxxxxxxx'
Thread Starter
Spiril
(@spiril)
I get the exact same message only this time the size is: 3411830
Not sure what is going on… but don’t you think my database has been optimized since the second time I tried to optimize I got the “Optimization Result: Table is already up to date” message?
Plugin Contributor
cageehv
(@cageehv)
Hey Spiril,
Sounds like the optimization is working fine.
Something is wrong with the reporting about the database operations.
Maybe some unusual MySQL setting. That’s my best guess.
I will do some more research on it later (hard to fix it if I cannot reproduce it myself…)
Rolf
Thread Starter
Spiril
(@spiril)
Hey Rolf,
Yes, your plugin is probably working fine. I haven’t changed any of the MySQL settings but maybe my host have? Let me know if you need more information from me – I will continue to use your plugin.
Thanks for your help,
Spiril :o)
I had a similar experience today, when I installed and ran the plugin. It seemed to delete revisions successfully. I etimate that at least 25,000-50,000 revisions were deleted. I have 85,000 posts, many with 3-10 revisions.
When I ran it a 2nd time, it reported that there was nothing to delete, so the first pass seems to have succeeded in deleting all my old data.
But the plugin only reports having deleted 0.7 KB (that is 700 bytes) which is normally just 2-3 posts worth of data. And it reports 4024.924 MB as the database size both before and after optimization
So, I agree there seems to be a reporting problem. BTW, I’m running WP 3.6 and MySQL version 5.1.70-cll
Plugin Contributor
cageehv
(@cageehv)
Weird, pcullum
Not sure what is going on with the reporting…
For me it seems to work fine
It’s hard to fix it when I cannot reproduce it
At least it seems to do the cleanup nicely.
Keep me posted.
Rolf
Plugin Contributor
cageehv
(@cageehv)
Closed because of no more feedback…
KK
(@aclops001)
Here is more feedback. I have the same issue – Reporting is not working.
My db reads 0 size before and after. I have the same SQL as the OP. If reporting is not working, not sure how we use this plugin. THanks
