Pay Attention to Your WordPress Database (19.5GB down to 159MB)

In general, I am quite good at maintaining my WordPress websites. I use the fantastic update service WP Remote to ensure all plugins and themes are kept up to date and I regularly remove plugins that I am not using. However, I am only human.
From time to time some things do slip through the net and I don’t realise I have missed anything until much later.
When I started getting automatic disk warning emails from my server telling me that this blog was using most of its allocated block, I knew something was wrong.
The Investigation Begins
I began looking into where the storage was being used up and saw that phpMyAdmin was reporting that this blog’s database is 19.5GB in size. When I sorted the database by row size I started to get a better picture of what was happening.
The top four rows all had profiler in the name. The profiler_functions table was taking up 9.3GB, profiler_queries was taking up 8.8GB, profiler_requests was taking up 607.6MB, and profiler_plugins was taking up 583.8MB.
To put into perspective how large these tables are, you need to look at the next tables. The next largest table is the prli_clicks table created by the link tracker Pretty Links Lite. After
Source: https://managewp.org/articles/14363/pay-attention-to-your-wordpress-database-19-5gb-down-to-159mb

source https://williechiu40.wordpress.com/2017/02/09/pay-attention-to-your-wordpress-database-19-5gb-down-to-159mb/