Dev4Press No Script

Database Management

Panel for Database management in SweepPress Pro allows you to see all the database tables based on the table prefix set for your website installation. More information about the panel is here.

Which tables are displayed

Database panel in SweepPress Pro will display all database tables with the table names prefix set in the wp-config.php file.

Multisite installations

If you have Multisite installation, prefix in wp-config.php is called Base Prefix, and each individual blog has own tables prefix. To learn more about activating plugin on Multisite installation, check out the Install & Update article.

On Multisite installation, if you use SweepPress Pro on the main blog of the network, you will see all the database tables that belong to that main blog, and also will show all other database tables that use Base Prefix, and don’t belong to other individual blogs. And, if you use SweepPress Pro on any other blog in the network, you will only see tables with the Blog Prefix. This means that shared network tables (like wp_users, wp_usermeta, wp_sitemeta…), will be listed on the Database panel only when with SweepPress Pro on the main blog in the network.

Tables Source Detection

There is no full-proof method to know which plugin adds which database table. Parsing plugins code to discover that is not universally possible, and would be very complicated. But, SweepPress Pro maintains a list of database tables added by popular WordPress plugins, and list of tables added by all Dev4Press plugins. This list is expanded with every new plugin version, and more plugins will be supported in this way.

WordPress Core tables will have the WordPress logo and will be colored differently.

Data displayed for every Table

Every table displayed in the list will show various information. If you look the image below, showing detail from this panel, you can see how this list looks like.

Database Tables List

You can see how big is each table, how big the index is, and how much free space there is in the table. Free space is usually a bad thing, and if there is a lot of free space compared to the total table size, table should be optimized to remove that free space. Unoptimized table can be slower in some types of queries. Free space usually happens when the records are often deleted.

  • Optimizing table doesn’t guarantee that free space will optimize at all, especially with the InnoDB tables!
  • Free space should be optimized only for large database tables where MySQL can actually achieve proper optimization. Small tables are hard to optimize.
  • SweepPress Pro has a Sweeper that does tables optimization, if the tables free space reaches predefined levels. It is highly recommended to use that sweeper, and not directly run optimizations from the Database panel.

Available Table Actions

For each table, there are several actions that can be displayed and used. Some of the actions need to be enabled in the plugin Settings.

  • Optimize: plugin will attempt to optimize table free space. This action is available only for columns that have free space.
  • Repair: plugin will attempt to fix the table. In some cases, tables can be broken or unavailable due to some internal server issue. If the table reports status other than ‘OK’, repair will be available. There is no guarantee it will work, because some table statuses may be beyond repair, or the table may absent due to server issues outside of MySQL control.
  • Truncate: this action will remove all data from the table! This action has to be enabled in the plugin settings. It will not be visible for the WordPress Core tables!
  • Drop: this action will remove table from the database, along all of the data in that table! This action has to be enabled in the plugin settings. It will not be visible for the WordPress Core tables!

Do not use any of these actions, unless you fully understand what these actions will do! Make sure you have a backup of the database before using any of these actions!!!

Rate this article

You are not allowed to rate this post.

Leave a Comment