Main Area and Open Discussion > Living Room
I need a physics/chemistry/engineering/science forum
rgdot:
Thanks for the help, I will try and see what happens.
rgdot:
Also installed query monitor plugin to see what it sees
the slow query is
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN
update_meta_cache() calls it, I wonder if I can prevent it from running....
wraith808:
Also installed query monitor plugin to see what it sees
the slow query is
SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN
update_meta_cache() calls it, I wonder if I can prevent it from running....
-rgdot (August 04, 2015, 05:49 PM)
--- End quote ---
It's something to do with your database. Not sure what it is, but that's in *every* installation of wordpress by default. So, if it was a problem because of the number of posts, there would be more hue and cry about it.
Check the indices on that table, and repair them- especially if they are on post_id. You might also try to run mysqlcheck on all of the tables, i.e.
mysqlcheck -u root -p --check --all-databases
or...
mysqlcheck -u root -p --auto-repair --check --all-databases
if you're going to trust it to check. Or you can just run the auto-repair after the check.
rgdot:
Thanks. Done and all was/is ok, no difference.
(btw replace root with actual database user, for checking individual databases)
Navigation
[0] Message Index
[*] Previous page
Go to full version