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?
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- How do I comment out a block of tags in XML?
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Rename a table in MySQL
- getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Case statement in MySQL
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t find mysqladmin on Mac OSX 10.6.8
- Export Pervasive to MySQL (C#)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- How do I restore a dump file from mysqldump?
- Authentication plugin ‘caching_sha2_password’ cannot be loaded
- MySQL DROP all tables, ignoring foreign keys
- MySQL SELECT increment counter
- Create a new database with MySQL Workbench
- Error Code: 2013. Lost connection to MySQL server during query
- How to get size of mysql database?
- how to drop partition without dropping data in MySQL?
- 1052: Column ‘id’ in field list is ambiguous
- 1052: Column ‘id’ in field list is ambiguous
- difference between primary key and unique key
- Creating a search form in PHP to search a database?
- phpMyAdmin – Error > Incorrect format parameter?
- Create mysql table directly from CSV file using the CSV Storage engine?
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- MySQL equivalent of DECODE function in Oracle
- How to create a foreign key in phpmyadmin
- importing a CSV into phpmyadmin
- How can I rebuild indexes and update stats in MySQL innoDB?
- How to check if mysql database exists
- R: Comment out block of code
- Is there a Profiler equivalent for MySql?
- How to do a batch insert in MySQL
- MySQL: Cloning a MySQL database on the same MySql instance
- How get value from URL
- Error: Duplicate entry ‘0’ for key ‘PRIMARY’
- WordPress site migration – icons missing
- Data is not constantly loading from custom wordpress table
- Using wpdb to connect to a separate database
- MySQL Database User: Which Privileges are needed?
- Why is my database import losing text widget data?
- Why do I get comment spam even with Akismet and Captcha?
- What tools are available for managing/writing to WordPress? [closed]
- How to rearrange fields in comment_form()
- How to return number of found rows from SELECT query
- setting comments off as default for pages and custom post types?
- Will it break my site if I delete all transient records in wp_options table?
- Checking if Database Table exists
- Is it possible to pull comments from facebook into your blog?
- Please explain how WordPress works with MySQL character set and collation at a low level
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- How to fetch Data in WordPress using MySQLi or $wpdb
- Filtering the Admin Comments List to Show Only Comments from the Current User?
- Non-threaded comment replies with link to original comment
- WordPress Database lost auto increment
- Approve comment hook?
- Connect to database using wordpress wp-config file
- Commenting in user profile page?
- How to change “You must be logged in to post a comment.”
- What’s a good strategy for planning WordPress DB growth?
- Disable comments on all posts/pages
- How do I delete all comments from a specific old blog post?
- Get url of product’s images (woocommerce)
- Removing the “Website” Field from Comments and Replies?
- wpdb->insert multiple record at once
- Stop WordPress redirecting comment-page-1 to the post page?
- Reset Post IDs to less than 64bit integer
- Importing old Disqus comments into WordPress
- How to add a class to the comment submit button?
- How to wrap submit button of comment form with div