Best settings for MySQL to speed up site? [closed]

Speed up a wordpress site is not a MySQL settings issue. One site in order to perform well is to USE MySQL with the best efficient way (limit your queries results, get only what you need)

Default wordpress database schema have been already set up (primary keys, indexes e.t.c) to be used by the default scripts (e.x. WP_Query) with the more efficient way.

The best thing to do if you own a low performance wp site is to check the server itself (you can install many plugins to monitor you php and mysql performance) and if you are pretty sure that is not a script issue that causes the latency then contact with your hosting provider in order to check your machine.

Now if you are using custom queries in your wordpress installation you must always have in mind the default db schema because it is very easy to create a slow (sometimes very slow) custom query.

Related Posts:

  1. How can I find the source of slow queries in WordPress?
  2. WordPress MySQL & PHP Performance
  3. Is it useful to turn on MySQL query cache for performance
  4. Same option_id=0 for 2 options in wp_options?
  5. WordPress Deadlock Error
  6. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  7. Concurrent / simultaneous MySQL connections
  8. Slow Mysql Queries
  9. How do I join a $wpdb query with user meta using default value if not exist?
  10. Alter wp_post table vs. post_meta performance/speed
  11. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  12. WordPress plugin overloading with tmp tables
  13. How to simulate web traffic to test performance of a website
  14. Regular XML-RPC timeouts
  15. update_option returns false in AJAX, how to debug?
  16. What is the cron doing?
  17. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  18. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  19. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  20. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  21. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  22. When to use SELECT … FOR UPDATE?
  23. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  24. Database sharding vs partitioning
  25. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  26. Search for all occurrences of a string in a mysql database
  27. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  28. How to convert a string to date in MySQL?
  29. MySQL COUNT DISTINCT
  30. How to update a record using sequelize for node?
  31. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  32. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  33. Convert MySQL to SQlite [closed]
  34. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  35. Convert partially non-numeric text into number in MySQL query
  36. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  37. MySQL: What’s the difference between float and double?
  38. How can I search (case-insensitive) in a column using LIKE wildcard?
  39. MySQL Select Multiple VALUES
  40. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  41. How to unblock with mysqladmin flush hosts
  42. Node.js MySQL – Error: connect ECONNREFUSED
  43. Solution to “subquery returns more than 1 row” error
  44. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  45. How To have Dynamic SQL in MySQL Stored Procedure
  46. MySQL – UPDATE query with LIMIT
  47. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  48. What SQL Query to do a simple find and replace
  49. Scanning Database for malicious Data
  50. how to refresh wordpress permalink settings? (without admin panel)
  51. Ordering posts by day (not time) AND meta value
  52. wpdb->prepare function remove single quote for %s in SQL statment
  53. Problems with DBDelta with FOREIGN key?
  54. Programmatically changing role information; editing role name and deleting
  55. Search and replace in post content
  56. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  57. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  58. Join new table with SQL query
  59. 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)
  60. Improve wp query perfomance on large db
  61. MySQL crashed because of the large number of requests
  62. Why doesn’t this code add a table to my database?
  63. SQL database export-import
  64. Can Someone Help Me Fix This WordPress Missing Argument Error?
  65. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  66. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  67. SQL Database, repeated tables?
  68. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  69. Code to remove authors with no posts connected to them
  70. SQL Query in WordPress – Getting Impossible WHERE error
  71. WordPress create database not working
  72. Import CSV to MySQL, with custom registration field information
  73. database optimization and server errors
  74. Setting up WordPress Locally on WAMP for a new site (with one already)
  75. Calling mysql_query() on another database, assumes WordPress using that database
  76. WordPress VIP realpath Alternative?
  77. querying user bookmarks from a large number of bookmarks
  78. Pull post name from value of a specific meta key
  79. PHP variables in mysql query
  80. How to fix the amount of comments displayed for each post?
  81. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  82. SQL query to change custom field in WordPress database
  83. SQL. Select category descendants
  84. MySQL Actibity without any active visitors via Google Analytics
  85. How to configure WordPress Database for CentOS 7
  86. Why is local wordpress install calling live site executions?
  87. Display MySQL as part of a Page
  88. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  89. Use custom query if main search query returns zero results in wordpress
  90. WP Meta Query – mixed AND / OR query doesn’t work
  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. Using queries in and i see 7000+queries?
  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?