WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Multisite DB optimizer (9 posts)

  1. WPtesting
    Member
    Posted 2 years ago #

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

  2. Define 'unwanted/useless data'

    If you can't come up with an exact set of parameters, no :) If you can, then probably.

  3. WPtesting
    Member
    Posted 2 years ago #

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

  4. 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.

  5. WPtesting
    Member
    Posted 2 years ago #

    Any other recommendation for DB optimization for fast query processing?

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

  7. WPtesting
    Member
    Posted 2 years ago #

    Can you please elaborate?

  8. 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.

  9. WPtesting
    Member
    Posted 2 years ago #

    Thank you very much :)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.