How can I find the source of slow queries in WordPress?

Try using this plugin http://wordpress.org/extend/plugins/debug-queries/ for checking performance of your database queries. It shows lots of detatils about each and every query made and time the query needed to complete and the time needed to make the whole page.

Related Posts:

  1. WordPress MySQL & PHP Performance
  2. Is it useful to turn on MySQL query cache for performance
  3. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  4. Concurrent / simultaneous MySQL connections
  5. Slow Mysql Queries
  6. Best settings for MySQL to speed up site? [closed]
  7. How do I join a $wpdb query with user meta using default value if not exist?
  8. Alter wp_post table vs. post_meta performance/speed
  9. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  10. WordPress plugin overloading with tmp tables
  11. How to simulate web traffic to test performance of a website
  12. Regular XML-RPC timeouts
  13. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  14. Cannot add or update a child row: a foreign key constraint fails
  15. How to make MySQL table primary key auto increment with some prefix
  16. MySQL error 2006: mysql server has gone away
  17. sql query with multiple where statements
  18. Cannot delete or update a parent row: a foreign key constraint fails
  19. Syntax error due to using a reserved word as a table or column name in MySQL
  20. MySQL root password change
  21. Installation of MySQL for Visual Studio 1.2.8 failed
  22. How do I import an SQL file using the command line in MySQL?
  23. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  24. Select from multiple tables without a join?
  25. SQL Query Where Field DOES NOT Contain $x
  26. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  27. Mysql command not found in OS X 10.7
  28. MySQL – UPDATE query based on SELECT Query
  29. grabbing first row in a mysql query only
  30. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  31. Order a MySQL table by two columns
  32. MySQL AS keyword
  33. Should I use the datetime or timestamp data type in MySQL?
  34. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  35. How do I change the data type for a column in MySQL?
  36. Generating a random & unique 8 character string using MySQL
  37. MySQL > Table doesn’t exist. But it does (or it should)
  38. Unknown Column In Where Clause
  39. Cannot connect to Database server (mysql workbench)
  40. mysqld: Can’t change dir to data. Server doesn’t start
  41. How to solve “Error: MySQL shutdown unexpectedly”?
  42. Can you do a For Each Row loop using MySQL?
  43. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  44. Drop all databases in MySQL
  45. How to properly create composite primary keys – MYSQL
  46. MySQL – count total number of rows in php
  47. How to get the count of each distinct value in a column?
  48. Data is not constantly loading from custom wordpress table
  49. How to run WordPress across 2 VMs for high availability
  50. Mysqldump add drop table?
  51. SQL query to update post_date (one post = one single date & time)
  52. My WordPress site always displays a cached version of its homepage
  53. How to solve slow WordPress site caused by attachment_metadata
  54. How to copy post titles to post slug in phpmyadmin
  55. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  56. Database slowdown after update to 3.4.1
  57. Inserting Hundreds of Thousands of Posts at Once
  58. wp_admin edit.php slow with lots of queries
  59. Database: Custom table: sprintf value for DateTime column
  60. What is the most secure way to set up the MySQL user in WPMU?
  61. WP_USE_EXT_MYSQL
  62. Which is more efficient? Using usermeta, or creating a new MySQL table?
  63. Distinction on meta value on pre_get_posts
  64. How to get data from WordPress site sql file
  65. WordPress with php5-fpm and nginx
  66. MySQL Rank & $wpdb
  67. WordPress post_status is future, manually added
  68. How are multiple WordPress WPDB queries handled?
  69. Regarding “Insert query error” in wordpress
  70. Site not responding error – taking long to load [closed]
  71. Copyright: Get first and last date of post type
  72. WordPress(wpdb class) and mysql stored procedures
  73. WordPress plugins for database queries
  74. WordPress doesn’t display accents after migration
  75. Replace a character in all post titles and slugs
  76. Understanding custom php that reads from WP MYSQL
  77. $wpdb->get_var multiple queries in one database check
  78. List users with the most posts in the last 30 days
  79. Way to extract wordpress data from folder backup
  80. Data is not constatntly loading from custom wordpress table
  81. Mysql Server keeps crashing
  82. How to search usermeta table
  83. How to add virtual column in wpdb get_result statement
  84. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  85. I want to share local developement and staging DB — Is this very smart or very stupid?
  86. Extract all users along with yoast metadata description
  87. WordPress asks to install, but is already installed?
  88. Deleting a table row through query
  89. An SQL query to find orphaned image attachments and their meta
  90. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  91. Weird characters displayed when importing WordPress MySQL db
  92. Simple SQL Query in wordpress
  93. optimise SQL wordpress call
  94. problem with quotes on new post
  95. WP_Query with LIKE returns strange query
  96. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  97. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  98. How do I load a sql.gz file to my database? (importing)
  99. How can I show mysql locks?
  100. Batch Replace URLs in WordPress Database

Leave a Comment

tech