Find what makes wp-admin slow, from the database
Look for the usual database causes of a slow dashboard, such as oversized settings loaded on every page, with read-only queries. Nothing is changed.
- Difficulty
- Advanced
- Time
- about 20 min
My WordPress dashboard has become slow, especially [where, e.g. the orders screen]. Look at the database for the usual causes: the biggest tables, the site options loaded on every page and their total size, the largest of them and which plugin each belongs to, and large cached values. Use only read-only queries. Give me a short list of likely causes, biggest first, with what I or my developer could do about each.
Already connected?
If SAR is already in your AI app, this is enough:
wp-admin is slow: check the database for the usual causes and list them, biggest first.
What happens
- The AI app lists the database tables with their row counts and sizes.
- It runs read-only queries, such as which options load on every page and how big they are; each runs in a read-only transaction with a 10-second limit.
- It lists large cached values by name and size, never their contents.
- It matches what it finds to the installed plugins.
- It gives you the likely causes, biggest first, with what to do about each. Nothing on the site changes.
Approvals involved
Nothing here changes your site: no approval needed.
wordpress_list_db_tablesDatabase tablesNonewordpress_query_databaseQuery the databaseNonewordpress_list_transientsCached valuesNonewordpress_list_pluginsList pluginsNone
What you get
A short, specific list of what weighs your dashboard down, to act on yourself or hand to a developer.
Related recipes
- Maintenance · about 15 minSee what fills your database and clean out expired cached valuesFind the biggest tables in your WordPress database, count what is in them and delete expired cached values that plugins left behind. Nothing visitors see is lost.
- Maintenance · about 15 minSort out overdue scheduled tasksSee which of WordPress's scheduled tasks are overdue, run a stuck one now and remove leftovers from plugins you no longer have, each with your approval.
- Maintenance · about 15 minRemove the plugins and themes you no longer useList the inactive plugins and unused themes still on your site, decide which go, and delete them one by one with your password after a backup check.
Try it on your own site
Install the plugin, add SAR to your AI app and paste the prompt. Free to start.