WordPress Database Clean-Up & Optimization

I am working with importing several custom post types / fields & require regular optimization (ie. selecting tables with overhead and optimizing them via phpMyAdmin currently). I would like something simple for my client to run prior to import or mass adjustment of posts. I read this article (https://premium.wpmudev.org/blog/wordpress-maintenance-101-how-to-optimize-and-repair-database-tables/) and am looking at these two plugins: http://wordpress.org/plugins/wp-optimize/ AND http://wordpress.org/plugins/wp-database-optimizer/

Has anyone had experience with these plugins? The client will be manually optimizing prior to import and I would like this to be effective and simple to use.

  • Jack Kitterhing

    Hi there @applemarketing

    I hope you are well today and thank you for your question.

    I personally prefer to do this manually, but i of course from a developers point of view, letting a client loose on the database is never a good idea! :slight_smile:

    I have used this before myself http://wordpress.org/plugins/wp-optimize/ and found that it worked well and didn't break anything, as some database plugins...well they aren't that good :slight_smile:

    But that worked great, you may want to test it out on a sandbox install first, before installing it and using it on a live site.

    Thank you!

    Kind Regards
    Jack.

  • Netz

    Hi
    I want to clean out my OPTIONS - Anyone have some tips?
    The tools above can drop / empty the table but that would be a bad solution :slight_smile:
    I can see that a lot of templates and plugins left garbage in the options table!

    I have like 3200 lines... And not that familiar to delete lines?
    So a tool... would be nice!

    If not... Can I just delete full lines and import the table again?

    Here's a sample:
    INSERT INTOxxxoptions` VALUES('557', 'quotescollection', 'a:10:{s:5:\"title\";s:28:\"Lidt visdom med på vejen...\";s:11:\"show_author\";i:1;s:11:\"show_source\";i:1;s:12:\"ajax_refresh\";i:1;s:12:\"auto_refresh\";i:0;s:14:\"random_refresh\";i:1;s:16:\"refresh_interval\";s:2:\"15\";s:4:\"tags\";s:0:\"\";s:10:\"char_limit\";s:3:\"700\";s:10:\"db_version\";s:3:\"1.4\";}', 'yes');
    INSERT INTO xxxoptions VALUES('43822', 'dbem_location_list_item_format', '#_LOCATIONLINK

    <ul>
    <li>#_ADDRESS</li>
    <li>#_TOWN</li>
    </ul>
    ', 'yes');
    INSERT INTO xxxoptions VALUES('43823', 'dbem_list_date_title', 'Events - #j #M #y', 'yes');
    INSERT INTO xxxoptions VALUES('43824', 'dbem_small_calendar_event_title_format', '#_NAME', 'yes');
    INSERT INTO xxxoptions VALUES('43825', 'dbem_small_calendar_event_title_separator', ', ', 'yes');
    INSERT INTO xxxoptions VALUES('43827', 'dbem_import_fail', '0', 'yes');
    INSERT INTO xxxoptions VALUES('3799', 'A2A_SHARE_SAVE_display_in_posts_on_front_page', '1', 'yes');
    INSERT INTO xxxoptions VALUES('284', 'visitor_map_db_version', '0.1.0', 'yes');
    INSERT INTO xxxoptions VALUES('162', 'ame_show_orderoptions', '1', 'yes');
    INSERT INTO xxxoptions VALUES('163', 'ame_toggle_showinvisposts', '1', 'yes');
    INSERT INTO xxxoptions VALUES('164', 'ame_version', '2.3.9.2', 'yes');`

    Can I just delete every line I think is wrong? - But if my guesswork is off... KABOOMMM Bye bye ?? :slight_smile:

    Peter

  • Vinod Dalvi

    Hi @Netz,

    Thanks for posting on the forums.

    Ideally its not a good process to post on a thread a year old. The WordPress has changed since.

    To help keep support tickets separate, could you please open a new thread for your new question https://premium.wpmudev.org/forums/#question If you want to you can add URL of this topic in your new created topic for reference.

    This helps to prevent any confusion (for us) as I'm sure you understand. Also this might help other members looking for a similar answer. :slight_smile:

    We would be more than happy to help you on your new topic.

    Thank you for being a WPMU DEV member and have a fantastic day!

    Cheers,
    Vinod Dalvi

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.