Is it useful to turn on MySQL query cache for performance

General speaking yes for read-only applications (until MySQL 5.7, it’s deprecated since version 8.0), it enables equal SELECTs to return data extremely fast if identical calls are already stored in cache. You should consider that:

  • Only exact same clauses can benefit from the cache engine (no spaces, no comments, no actual differences in WHERE expressions);
  • If you are updating often the table you will not benefit much of it, since the queries get invalidated, and the invalidation algorithms can also reduce performance, in some cases.

Excellent alternatives are:

I think also if you combine those with a good web server like NGINX or Apache2 and an HTTP accelerator like Varnish you can fly.

As I know, these are also the best current practices but I might have ignored something, please share it in case.

Related Posts:

  1. How can I find the source of slow queries in WordPress?
  2. WordPress MySQL & PHP 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. Cannot add or update a child row: a foreign key constraint fails
  14. Cannot add or update a child row: a foreign key constraint fails
  15. Cannot delete or update a parent row: a foreign key constraint fails
  16. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  17. Rename a column in MySQL
  18. Syntax error due to using a reserved word as a table or column name in MySQL
  19. MySQL root password change
  20. Not unique table/alias
  21. Install mysql-python (Windows)
  22. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  23. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  24. SQL Query Where Field DOES NOT Contain $x
  25. Disable ONLY_FULL_GROUP_BY
  26. MySQL WHERE IN ()
  27. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  28. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  29. difference between primary key and unique key
  30. Mysql command not found in OS X 10.7
  31. How to export a mysql database using Command Prompt?
  32. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  33. MySQL Error #1133 – Can’t find any matching row in the user table
  34. How can I prevent SQL injection in PHP?
  35. Best way to store an array in MySQL database?
  36. MySQL date formats – difficulty Inserting a date
  37. Cannot connect to Database server (mysql workbench)
  38. How to grant remote access permissions to mysql server for user?
  39. How to check if mysql database exists
  40. #1062 – Duplicate entry for key ‘PRIMARY’
  41. How can I convert a string to a float in mysql?
  42. Is there a Profiler equivalent for MySql?
  43. How to use greater than operator with date?
  44. How to replace the domain name in a WordPress database?
  45. Optimize WordPress Query that take 5 seconds to execute
  46. MySQL Replication Latency Issues in wp-admin pages
  47. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  48. #1115 – Unknown character set: ‘utf8mb4’
  49. How to copy post titles to post slug in phpmyadmin
  50. WordPress Deadlock Error
  51. How to do a MySQL dump from production site without using a search and replace script for local development?
  52. How to bulk edit canonical url’s in SQL?
  53. How to check for empty and not a failure
  54. Database: Custom table: sprintf value for DateTime column
  55. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  56. Keeping database within limits, please help!
  57. WP_USE_EXT_MYSQL
  58. HTML Entities in Post Title
  59. Can’t find my wordpress DB in phpmyadmin
  60. Deprecated: mysql_connect():
  61. Improve performance by removing unnecessary database queries
  62. WordPress post_status is future, manually added
  63. How are multiple WordPress WPDB queries handled?
  64. $wpdb select all meta for each post
  65. Calculate average crossing post categories
  66. Replacing link URL ending strings via MySQL
  67. Many slow queries post_type = ‘attachment’;
  68. SQL command to convert all tags in lowercase?
  69. Problem with admin login after deployment
  70. Find out how many times the user has logged in
  71. WordPress plugins for database queries
  72. Is it possible to create a WordPress table using array and loop?
  73. Can’t run database query
  74. How to stop $wpdb from prepending database name
  75. Match tag names with form titles
  76. Error missing MySQL extension
  77. Getting Error Trying to Create Table
  78. Best approach for a custom database filling in WP custom post types
  79. Why doesn’t custom mysql query return results? Is syntax correct?
  80. Insert two row in wordpress database
  81. SQL statement using placeholder is not returning results
  82. How to Bulk find and replace MySQL for post image url
  83. Wpdb query with dynamic table name
  84. How to search usermeta table
  85. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  86. update multiple rows in mysqli table base on two values
  87. How can I verify WordPress nonce from the following code?
  88. How to write in MySQL more characters in user_nicename
  89. $wpdb->get_var not returning count
  90. Custom user query – orderby meta_key (that may not exist)
  91. How to get Attachments(image) with specific width\height ratio
  92. What is the cron doing?
  93. Apache Redirect based on WordPress permissions
  94. SQL error on restoring database
  95. MySQL database gives blank page (white screen of death)
  96. Datatabase error: Commands out of sync
  97. why is $wpdb->update() causing a DB error from within wp_set_password()
  98. Global MySQL replacing of text patterns/matches
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?

Leave a Comment