Databases
StackOverflow2013
Postsdbo
POVery slow wp-admin. Help diagnosing fault by displaying mysql queries and query times
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVery slow wp-admin. Help diagnosing fault by displaying mysql queries and query times
    primarykey
    data
    text
    <p>I have noticed that my wp-admin is extremely slow. The front-end of the site is lightning fast.</p> <p>e.g. if I visit <code>https://domain.co.uk/wordpress/wp-admin/edit-comments.php</code>, the page takes between 10-30 seconds to load.</p> <p>I ran a script to see if I can diagnose the problem:</p> <pre><code>add_filter( 'admin_footer_text', 'performance', 20 ); if (is_admin()) { function performance( $visible = false ) { $stat = sprintf( '%d queries in %.3f seconds, using %.2fMB memory', get_num_queries(), timer_stop( 0, 3 ), memory_get_peak_usage() / 1024 / 1024 ); echo $visible ? $stat : " {$stat} " ; }} </code></pre> <p>To find the following: <code>119 queries in 21.929 seconds, using 57.43MB memory</code> on the <code>edit-comments.php</code> page. There are only 49 comments awaiting moderation so I cannot imagine that this is a problem with mysql reading the comments.</p> <p>Is there a way of displaying individual mysql scripts and query times in that same footer of wp-admin so I can find out what's wrong?</p> <p>I have tried modifying the above code to the following, but that just overlays all queries over the entire page and is entirely unreadable:</p> <pre><code>function performance( $visible = false ) { global $wpdb; $stat = sprintf( '%d queries in %.3f seconds, using %.2fMB memory', get_num_queries(), timer_stop( 0, 3 ), memory_get_peak_usage() / 1024 / 1024 ); echo $visible ? $stat : "&lt;!-- {$stat} --&gt;" ; if (SAVEQUERIES) { foreach ($wpdb-&gt;queries as $query) { echo '&lt;ul&gt;'; foreach ($query as $q) { echo '&lt;li&gt;'. $q .'&lt;/li&gt;'; } echo '&lt;ul&gt;'; } } } </code></pre> <p>If the numerical values in $wpdb->queries are mysql query times, then the excessive php load time is caused by something in one of the PHP scripts.</p> <p>Is there a way that I can do something similar but with each plugin to determine what the cause is? </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGravy
    1. USGravy
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POVery slow wp-admin. Help diagnosing fault by displaying mysql queries and query times
      1. USMTahir
      1. VTFavorite
    2. VO
      singulars
      1. POVery slow wp-admin. Help diagnosing fault by displaying mysql queries and query times
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou should really enable query logging on mysql. See [this thread](http://stackoverflow.com/questions/303994/log-all-queries-in-mysql).
      singulars
      1. POVery slow wp-admin. Help diagnosing fault by displaying mysql queries and query times
      1. USeis
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload