Tables size = 0

Hey Fabio,

That’s strange…

Can you please run the following query on your database (phpMyAdmin)?

SELECT engine, (
data_length + index_length
) AS size, table_rows
FROM information_schema.TABLES
WHERE table_schema = '<your database name>'
AND   table_name   = '<one of your tables>'

Please let me know the result.

Ciao,
Rolf

This is the result:

MyISAM 67988 572

I have recently moved the DB from MySql 5.0 to 5.5

Hey Fabio,

Okay, so the query works… Thanks for testing.

I have to look further into it to see what can be the problem.

I’ll get back to you when I know more.

Ciao,
Rolf

Thanks Rolf,

Ciao

Hey Fabio,

The result after optimization shows for instance:

# - table name - optimization result - engine - table rows - table size
1   wp_options   OK                    myISAM   586          773.2 KB

Is it correct that for you it only shows the first 3 columns? (#, table name and optimization result) and leaves out the last 3 columns? (engine, table rows and table size)

Ciao,
Rolf

Correct. The first 3 columns are OK. Then it shows an empty value for “engine” and 0 both for table rows and size.

Hey Fabio,

Is is possible to switch your site into ‘debug-mode’ for moment and check if using my plugin generates any errors?

To switch to ‘debug-mode’ make a change to the wp-config.php file in the root of your WP installation:

define(‘WP_DEBUG’, true);

Grazie!
Rolf

Hi Rolf,

yes I am getting a lot of errors.

First this one, at the very beginning:

Notice: Undefined offset: 0 in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1835

Notice: Trying to get property of non-object in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1835

Then, in the “engine” column of every row:

Notice: Undefined offset: 0 in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1633

Notice: Trying to get property of non-object in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1633

In table rows column:

Notice: Undefined offset: 0 in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1634

Notice: Trying to get property of non-object in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1634

and in table size column:

Notice: Undefined offset: 0 in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1635

Notice: Trying to get property of non-object in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1635

Thank you for your assistance.

Fabio

Hey Fabio,

Thanks for your testing!

It’s a strange problem but I did an attempt to fix it.
I created a new (BETA) version for you: v3.1.4

You can download it from:
https://cagewebdev.com/fabio/rvg-optimize-database-3.1.4.zip

First uninstall the current version (v3.1.3) and add v3.1.4 by uploading the zip file (‘add new plugin – upload’)

Please let me know if that fixes your problem!

Ciao,
Rolf

The site is in production… Do I risk to break things?

Good question, but the answer is ‘no, no risk’.
Just minor changes and only at the backend (not frontend)
Besides I, of course, tested it on my own sites ??

Nope…

The page doesn’t load and the browser hangs.
Enabled debug, I got this in the log:

[Fri Feb 27 16:23:21 2015] [warn] [client 94.34.60.246:60444] - AH01220: Timeout waiting for output from CGI script /web/htdocs/www.atopon.it/home/wp-admin/tools.php, referer https://www.atopon.it/wp-admin/tools.php?page=rvg-optimize-db.php

Interesting thing is that I ran it on another site, with the same mysql version, and it works…
Could be something in mysql settings?

Yes, it definitely has to do something with MySQL settings.

Question: is your database name mixed case (upper and lowercase characters mixed?) on the site with the problem?