If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?

There’s quite a lot of information on here about switching to InnoDB

https://wordpress.stackexchange.com/search?q=innodb

There are a number of things to think about:

  • InnoDB is helpful with you’re faced with contention – ie when you have tables that are being written to as well as being read
  • InnoDB does not support FULLTEXT indexes so plugins that rely on that will either break or work slowly.
  • You can choose which tables to convert to InnoDB – it’s not an all or nothing deal – on some of my sites, wp_comments is the only table that’s InnoDB because of the massively bursty nature of comments on those sites.

However, it sounds like you’ve got more fundamental issues that need to be sorted out before you worry about switching to InnoDB.

  • you really need to log your slow queries and then EXPLAIN them to understand what’s going on – you might just need to optimise tables or add additional indexes – it’s quite likely that some of your plugins are executing queries that are forcing sequential searches on your database. Find out and add indexes to speed these up, if that’s the case.
  • Once that’s done, you can then look at optimising Apache or switching to a more advanced setup (eg nginx + PHP-FPM).
  • Check your caching. If the site isn’t changing much, most content should be served up from the cache instead of hitting the database. Find out why this isn’t happening.

In short, it doesn’t feel like you’ve really got to the root causes of the problem. Until you get a better handle on that, anything you do is going to be a bit random.

Related Posts:

  1. How do I quickly rename a MySQL database (change schema name)?
  2. MySQL DROP all tables, ignoring foreign keys
  3. How can I rebuild indexes and update stats in MySQL innoDB?
  4. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  5. What’s a good strategy for planning WordPress DB growth?
  6. Optimize Multiple Taxonomy Term MySQL Query?
  7. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  8. WordPress UPDATE queries on MySQL database stuck
  9. Using queries in and i see 7000+queries?
  10. InnoDB: Error: log file ./ib_logfile0 is of different size
  11. How to reduce uncached page generation time?
  12. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  13. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  14. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  15. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  16. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  17. When to use SELECT … FOR UPDATE?
  18. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  19. Column ‘user_id’ in field list is ambiguous
  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. Would switching to InnoDB from MyISAM improve performance of comments table?
  44. Scanning Database for malicious Data
  45. how to refresh wordpress permalink settings? (without admin panel)
  46. Ordering posts by day (not time) AND meta value
  47. wpdb->prepare function remove single quote for %s in SQL statment
  48. Problems with DBDelta with FOREIGN key?
  49. Is it useful to turn on MySQL query cache for performance
  50. Programmatically changing role information; editing role name and deleting
  51. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  52. Search and replace in post content
  53. MySQL LIKE not working
  54. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  55. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  56. Join new table with SQL query
  57. 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)
  58. Improve wp query perfomance on large db
  59. MySQL crashed because of the large number of requests
  60. Why doesn’t this code add a table to my database?
  61. SQL database export-import
  62. Can Someone Help Me Fix This WordPress Missing Argument Error?
  63. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  64. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  65. SQL Database, repeated tables?
  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. WordPress create database not working
  70. database optimization and server errors
  71. Setting up WordPress Locally on WAMP for a new site (with one already)
  72. Calling mysql_query() on another database, assumes WordPress using that database
  73. WordPress VIP realpath Alternative?
  74. querying user bookmarks from a large number of bookmarks
  75. Pull post name from value of a specific meta key
  76. PHP variables in mysql query
  77. Export SQL query based on custom field?
  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 simulate web traffic to test performance of a website
  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. WordPress Query optimaization for slow query
  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. WP Meta Query – mixed AND / OR query doesn’t work
  90. Geographical proximity query using post_meta
  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. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database