topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Thursday March 28, 2024, 6:58 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

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

rgdot

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

rgdot

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 2,192
    • View Profile
    • Donate to Member
Re: I need a physics/chemistry/engineering/science forum
« Reply #26 on: August 04, 2015, 05: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
  • **
  • default avatar
  • Posts: 11,186
    • View Profile
    • Donate to Member
Re: I need a physics/chemistry/engineering/science forum
« Reply #27 on: August 04, 2015, 06: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,192
    • View Profile
    • Donate to Member
Re: I need a physics/chemistry/engineering/science forum
« Reply #28 on: August 04, 2015, 07:26 PM »
Thanks. Done and all was/is ok, no difference.

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