Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

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

Login with username, password and session length
  • December 04, 2016, 08:33:14 PM
  • Proudly celebrating 10 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 4325 times)

rgdot

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

rgdot

  • Supporting Member
  • Joined in 2009
  • **
  • Posts: 1,879
    • View Profile
    • Donate to Member
Re: I need a physics/chemistry/engineering/science forum
« Reply #26 on: August 04, 2015, 05:49:42 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: 8,405
  • "In my dreams, I always do it right."
    • View Profile
    • Donate to Member
Re: I need a physics/chemistry/engineering/science forum
« Reply #27 on: August 04, 2015, 06:36:51 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: 1,879
    • View Profile
    • Donate to Member
Re: I need a physics/chemistry/engineering/science forum
« Reply #28 on: August 04, 2015, 07:26:32 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:22 PM by rgdot »