MyISAM locks the whole page for writes and is not ACID compliant, while InnoDB sticks to locking rows as you point out, and is ACID compliant.
This makes it sturdier when you’ve a lot of writes, as in faster and less prone to data corruption.
It’s slower for reads in my experience, though it handles concurrent connections better.
It also clutters the catalog. (I had a large DB one day which I switched to InnoDB from MyISAM, and the catalog ballooned by 2GB, or the size of my DB, for reasons I never understood, though I’m suspecting it had to do with temporary data such as index creation and the like, which didn’t get flushed properly.)
Anyway… With your current load, InnoDB is an option, as is memcached alongside an object cache.
Related Posts:
- Resetting comment count
- Recent comments from my blogs only
- How do I quickly rename a MySQL database (change schema name)?
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- comment_post_ID 0 (cannot remove from dashboard)
- What for is the table “wp_commentmeta” exactly?
- Does WordPress use the InnoDB engine for MySQL by default?
- Can I store my custom comment_type into wp_comments table?
- Using Disqus, how to stop storing comments in wp database?
- Can I explicitly specify ENGINE=InnoDB in WordPress?
- What are the additional fields in wp_comments used for?
- How to Delete Old Comments by Date?
- SQL query to delete comments older than 90 days?
- Large database causes slow load
- migrate comments from old database to new database
- WordPress unresponsive after calling wp_update_comment()
- What is the correct/safe way to delete all comments?
- Is it safe to convert tables from MyISAM to InnoDB?
- Add action on delete comments?
- How can I get a list of comments by target
- Log file reports SQL Error processing child comments
- Delete all one-word comments
- WordPress ‘comment counts’ got messed up, because of a plugin – DISQUS
- Control panel loads slowly due to 2 slow queries on comment table
- Is MariaDB’s Aria storage engine suitable for WordPress?
- delete duplicate comments
- What do these phpMyAdmin errors mean on my WordPress databaes?
- Export Pervasive to MySQL (C#)
- MySQL SELECT increment counter
- How do we remove the H3 tag for the reply-title I.D
- How to use “TRUNCATE TABLE” MySQL statement?
- show number of open comments on custom dashboard
- Slow SQL_CALC_FOUND_ROWS Query
- How to hide “Trackback” on paginated comments
- Is it possible to show custom comment metadata in the admin panel?
- how to have 2 comments_template() in one post
- Display comment meta data after quick update
- How to hide “Comments are disabled”
- Get number of comments per page
- Custom disqus_identifier not properly changing default value
- Edit Comment_Field while using T5 Comment Textarea On Top-Plugin
- How to import only certain comments from post[s]
- Select Multiple meta_value from WP DB; Single Query
- Make wordpress comments work with include templatepath
- Is it possible to split database tables using HyperDB?
- Callback function argument which is required for wp_list_comments ()
- Custom WP Comments Query with Nested Comments Possible? (Hierarchy/Depth)
- how to properly use comments-template.php
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- How do I query wp_options for expired transient pairs with MySQL commands?
- Reply By Email to comment notifications
- Get Post ID within wp_set_comment_status hook
- How to implement comments on specific fields in wordpress?
- WordPress running SQL query to update database from form
- How to fix database error duplicate entry
- Comments are invisible, what’s the problem with wp_list_comments?
- WP confusing “links to my articles” with “comments”?
- How to check if a comment has replies?
- Can I have Comments open to specific users only?
- How do I convert a MySQL database from utf8mb4 to utf8 encoding?
- Alternative functions for mysql_free_result and mysql_ping in wordpress functions
- Why this query is not showing any result on wordpresss home page?
- Commentlist: bypostauthor problem with children list
- Comments does not work?
- How do I disable the discussion notification emails to us when a comment is “approved” and when an adiministrator replies?
- Review count per product
- Moving post’s content to post’s comments section
- comment_notes_before not working
- Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
- wp_usermeta – Read from database, but save function broken
- How to get product order by two custom taxonomy in wordpress
- Having problem creating local instance of wordpress site
- Returning error upon comment being flagged as spam
- JetPack comment threads are displaying above comment box? [closed]
- How do i remove approved spam comments by date?
- Insert ads between comments
- get_query_var(‘paged’) for WP_Comment_Query always return 1 when using paginate_comments_links()
- How to only show current user’s comments and comments on current user’s posts in wp admin
- How to show username in reply to comment?
- Display date and time into post edit comments section
- WordPress database problem wp_posts, primary key
- Disallowed Tag Present in AMP WordPress ()
- Fire Social Annex Code on Comment Approval
- Change Comment Text [duplicate]
- Comments closed but enabled on edit screen
- Let user delete comment on front end only
- jQuery to Create Button to Show/Hide WordPress Comments and to Hide Comments by Default
- Comment form – different title if no comment yet
- Loop not displaying comments_popup_link
- Display of comment_date within get_comments?
- How to batch convert comments to posts?
- prevent duplicate comments using wp_insert_comment
- I need help about wordpress of members section
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- How can I delete the options from DB when the plugin is deleted?
- SQL query into to WP query
- InnoDB: Error: log file ./ib_logfile0 is of different size
- Add ACF Quick Edit Columns on Comments
- How to find fresh (last modified) and sql backup?
- Putting form result in my database