WordPress MySQL & PHP Performance

Hi Matthew Paulson,

I see your using W3 Total Cache but your database and object cache is set to disk. Caching objects and your database to disk can actually have a negative performance effect especially if your getting that much traffic.

You can read more about the effects on caching database and objects to disk in an article I wrote on how to set up W3 Total Cache The plugin author agreed with the instructions in my settings.

To really see the benefit of database and object caching you need to be using a PHP opcode cache like APC. You can follow the copy and paste instructions in the plugin FAQ to compile and set up APC. If your on Ubuntu or Debian you can simply run the command: apt-get apc-php5 to install.

Like others have also mentioned you will get a huge performance boost and enable your site to scale much larger by setting up a reverse proxy with Nginx.

I give detailed instructions on how to configure and set it up in my WordPress Performance Stack. article.

You should also read some of the other questions and answers on here. A lot of good performance and scaling advice has been given.

Good luck on your quest. Managing your own server can be very stressful sometimes.

Edit

Just to show the performance you can gain by installing Nginx as a reverse proxy I’m posting an Apache Benchmark test I just ran on my server:

x-wing ~: ab -n 1000 -c 80 http://wp-performance.com/
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking wp-performance.com (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Completed 1000 requests
Finished 1000 requests


Server Software:        nginx/0.8.54
Server Hostname:        wp-performance.com
Server Port:            80

Document Path:          /
Document Length:        3132 bytes

Concurrency Level:      80
Time taken for tests:   0.066 seconds
Complete requests:      1000
Failed requests:        0
Write errors:           0
Total transferred:      3605000 bytes
HTML transferred:       3132000 bytes
Requests per second:    15164.15 [#/sec] (mean)
Time per request:       5.276 [ms] (mean)
Time per request:       0.066 [ms] (mean, across all concurrent requests)
Transfer rate:          53385.52 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        0    2   0.6      1       3
Processing:     1    4   0.8      4       5
Waiting:        1    3   0.8      3       5
Total:          3    5   0.6      5       7

Percentage of the requests served within a certain time (ms)
  50%      5
  66%      5
  75%      6
  80%      6
  90%      6
  95%      6
  98%      6
  99%      6
 100%      7 (longest request)

Theoretically it’s able to handle over 15,000 requests per second. (Same Network)

Related Posts:

  1. How can I find the source of slow queries in WordPress?
  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. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  14. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  15. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  16. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  17. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  18. When to use SELECT … FOR UPDATE?
  19. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  20. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  21. Search for all occurrences of a string in a mysql database
  22. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  23. How to convert a string to date in MySQL?
  24. MySQL COUNT DISTINCT
  25. How to update a record using sequelize for node?
  26. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  27. Convert MySQL to SQlite [closed]
  28. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  29. Convert partially non-numeric text into number in MySQL query
  30. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  31. MySQL: What’s the difference between float and double?
  32. How can I search (case-insensitive) in a column using LIKE wildcard?
  33. MySQL Select Multiple VALUES
  34. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  35. How to unblock with mysqladmin flush hosts
  36. Node.js MySQL – Error: connect ECONNREFUSED
  37. Solution to “subquery returns more than 1 row” error
  38. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  39. How To have Dynamic SQL in MySQL Stored Procedure
  40. MySQL – UPDATE query with LIMIT
  41. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  42. What SQL Query to do a simple find and replace
  43. Scanning Database for malicious Data
  44. how to refresh wordpress permalink settings? (without admin panel)
  45. Ordering posts by day (not time) AND meta value
  46. Alternative to mysql_real_escape_string
  47. Extending the database
  48. Same option_id=0 for 2 options in wp_options?
  49. How to let a user choose an authors and save it to the database?
  50. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  51. MySQL LIKE not working
  52. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  53. Mysql / WordPress killing my server with 80k users [closed]
  54. Performance issues with large website [closed]
  55. Join new table with SQL query
  56. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  57. Improve wp query perfomance on large db
  58. MySQL crashed because of the large number of requests
  59. Why doesn’t this code add a table to my database?
  60. SQL database export-import
  61. Can Someone Help Me Fix This WordPress Missing Argument Error?
  62. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  63. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  64. SQL Database, repeated tables?
  65. Backing up and restoring multiple sites efficiently
  66. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  67. Code to remove authors with no posts connected to them
  68. SQL Query in WordPress – Getting Impossible WHERE error
  69. Are these WordPress tables safe to add indexes to?
  70. WordPress create database not working
  71. database optimization and server errors
  72. Setting up WordPress Locally on WAMP for a new site (with one already)
  73. Calling mysql_query() on another database, assumes WordPress using that database
  74. WordPress VIP realpath Alternative?
  75. querying user bookmarks from a large number of bookmarks
  76. Pull post name from value of a specific meta key
  77. PHP variables in mysql query
  78. How to fix the amount of comments displayed for each post?
  79. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  80. How to install WordPress from hosting service with mysql database from Compute Engine GCP?
  81. SQL query to change custom field in WordPress database
  82. SQL. Select category descendants
  83. MySQL Actibity without any active visitors via Google Analytics
  84. How to configure WordPress Database for CentOS 7
  85. Why is local wordpress install calling live site executions?
  86. Display MySQL as part of a Page
  87. SELECT statement wrong?
  88. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  89. WP Meta Query – mixed AND / OR query doesn’t work
  90. How to Import Multiple Values in custom field
  91. Second completely independent and disposable WordPress installation in subdirectory?
  92. get_results suddenly not working on a single table
  93. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  94. Query sql for truncate post_content in wp_posts table
  95. Foreach only outputs if id is 0
  96. SQL – Pull products of particular category from a remote WordPress woocommerce db
  97. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  98. Why does the MySQL command line tool ignore the –port parameter?
  99. Postgres equivalent to MySQL’s \G?
  100. Possible SQL injection. How to locate and fix?

Leave a Comment