DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Last post Author Topic: I need a physics/chemistry/engineering/science forum  (Read 17,703 times)

rgdot

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 2,197
Re: I need a physics/chemistry/engineering/science forum
« Reply #25 on: August 04, 2015, 08:45 PM »
Thanks for the help, I will try and see what happens.

rgdot

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 2,197
Re: I need a physics/chemistry/engineering/science forum
« Reply #26 on: August 04, 2015, 10:49 PM »
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

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 11,205
    • Participated in NANY Challenge Fourteen Times
    • Coding Snacks
    • Writer
    • Hardware Hacker
Re: I need a physics/chemistry/engineering/science forum
« Reply #27 on: August 04, 2015, 11:36 PM »
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....

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

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 2,197
Re: I need a physics/chemistry/engineering/science forum
« Reply #28 on: August 05, 2015, 12:26 AM »
Thanks. Done and all was/is ok, no difference.

(btw replace root with actual database user, for checking individual databases)
« Last Edit: August 05, 2015, 12:43 AM by rgdot »

Original address: https://www.donationcoder.com/forum/index.php?topic=41278.0