Developer Tools > Optimization [PRO]

Although WP ULike’s performance has been greatly optimized using advanced algorithms to date, and all queries have an optimal structure, this does not diminish the importance of database optimization.

If you check your database, you will see the 5 tables listed below which has been created by the WP ULike plugin:

  • wp_ulike – Stores post types logs
  • wp_ulike_comments – Stores comments logs
  • wp_ulike_activities – Stores BuddyPress logs
  • wp_ulike_forums – Stores bbPress logs
  • wp_ulike_meta – Stores meta-information about counters, stats, user status, etc.

All of these tables have their own specific structure and store various information such as user_id, user_ip, status, date_time, etc.

Optimize Database Tables

In this panel, you can manage your database tables with just one click.

Posts

  1. Delete All Logs:  Delete all votings logs. (Located in wp_ulike table)
  2. Delete Orphaned Rows: Drop all rows in the logs table where its related table row no longer exists. (Don't try this option if you're using custom IDs)
  3. Delete Meta Counter Values: You Are About To Delete All Meta Counter Data. (Located in wp_ulike_meta table with "posts" group name.)
  4. Delete Dulicate Rows: Delete all duplicate rows generated by the spam users.
  5. Optimize Table Overhead: Overhead is a temporary disk space that is used by your database to store queries. Over time, a table’s overhead will increase.
  6. Migrate Counter Metadata: You are about to migrate counter values to the WordPress "wp_postmeta" table.

Comments

  1. Delete All Logs:  Delete all votings logs. (Located in wp_ulike_comments table)
  2. Delete Orphaned Rows: Drop all rows in the logs table where its related table row no longer exists. (Don't try this option if you're using custom IDs)
  3. Delete Meta Counter Values: You Are About To Delete All Meta Counter Data. (Located in wp_ulike_meta table with "comments" group name.)
  4. Delete Dulicate Rows: Delete all duplicate rows generated by the spam users.
  5. Optimize Table Overhead: Overhead is a temporary disk space that is used by your database to store queries. Over time, a table’s overhead will increase.
  6. Migrate Counter Metadata: You are about to migrate counter values to the WordPress "wp_commentmeta" table.

BuddyPress

  1. Delete All Logs:  Delete all votings logs. (Located in wp_ulike_activities table)
  2. Delete Orphaned Rows: Drop all rows in the logs table where its related table row no longer exists. (Don't try this option if you're using custom IDs)
  3. Delete Meta Counter Values: You Are About To Delete All Meta Counter Data. (Located in wp_ulike_meta table with "activity" group name.)
  4. Delete Dulicate Rows: Delete all duplicate rows generated by the spam users.
  5. Optimize Table Overhead: Overhead is a temporary disk space that is used by your database to store queries. Over time, a table’s overhead will increase.

bbPress

  1. Delete All Logs:  Delete all votings logs. (Located in wp_ulike_forums table)
  2. Delete Orphaned Rows: Drop all rows in the logs table where its related table row no longer exists. (Don't try this option if you're using custom IDs)
  3. Delete Meta Counter Values: You Are About To Delete All Meta Counter Data. (Located in wp_ulike_meta table with "topic" group name.)
  4. Delete Dulicate Rows: Delete all duplicate rows generated by the spam users.

Other cases

  1. Delete All Meta User Status:  Delete all users' meta status.
  2. Delete All Meta Statistics Values: Delete all users' meta stats logs.
  3. Delete Empty Post Meta Rows: Drop all Metabox rows in the post meta table where its value is empty.
Warning: All options in this panel work directly on optimizing and modifying database table rows. It is best to have a backup before doing anything.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us