Support » Networking WordPress » Multisite DB optimizer

  • Resolved WPtesting

    (@wptesting)


    Is there any good plugin or service by which we can optimize our multisite DB by flushing unwanted/useless data from DB?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    Define ‘unwanted/useless data’

    If you can’t come up with an exact set of parameters, no 🙂 If you can, then probably.

    WPtesting

    (@wptesting)

    for example old revision, empty tables, etc.
    One more thing is, can i use multiple DB for better experience? if yes, how?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    for example old revision, empty tables, etc.

    Old Revision: Read http://wpengineer.com/2382/wordpress-constants-overview/

    That has some constants you can set in your wp-config.php to handle revisions, trash etc.

    Leave the empty tables alone, they have a purpose, even if you aren’t using them today.

    MultipleDBs doesn’t give a better experience unless you have a huge database.

    WPtesting

    (@wptesting)

    Any other recommendation for DB optimization for fast query processing?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    Anything I’d do would be on SQL’s end, not WordPress’s.

    WPtesting

    (@wptesting)

    Can you please elaborate?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Halfelf Rogue & Plugin Review Team Rep

    This is high level passthrough, just FYI. If I were to go into depth I’d be applying for a job 😉

    1) Know how WP works with DBs. http://www.onextrapixel.com/2010/05/19/a-detailed-look-into-wordpress-database-optimization/

    2) Make sure you have CACHING installed on your sevrer for php and SQL

    3) Get a caching plugin (w3TC does DB caching and object caching)

    4) Make sure you installed PHP and SQL with the best settings for your server, tweak the heck out of mysql and httpd configs.

    WPtesting

    (@wptesting)

    Thank you very much 🙂

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Multisite DB optimizer’ is closed to new replies.