Title: Minimum MySQL version needed?
Last modified: September 1, 2022

---

# Minimum MySQL version needed?

 *  Resolved [bluedogranch](https://wordpress.org/support/users/bluedogranch/)
 * (@bluedogranch)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/minimum-mysql-version-needed/)
 * What’s the minimum MySQL version needed for this plugin? Your other plugin requires
   5.5.62+ [https://wordpress.org/plugins/index-wp-mysql-for-speed/#which%20versions%20of%20mysql%20and%20mariadb%20does%20this%20support%3F](https://wordpress.org/plugins/index-wp-mysql-for-speed/#which%20versions%20of%20mysql%20and%20mariadb%20does%20this%20support%3F)
 * And does this support MyISAM tables? Or only InnoDB?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/minimum-mysql-version-needed/#post-15975199)
 * I test it with 5.5.62, because that’s the oldest version I could manage to install
   on a virtual machine.
 * It should work with MyISAM. But I don’t test with that, because I haven’t had
   anybody with tens of thousands of users on their WordPress installation ask me
   to.
 * Let me know if this is something you need. And, thanks for your interest.
    -  This reply was modified 3 years, 9 months ago by [OllieJones](https://wordpress.org/support/users/olliejones/).
 *  Thread Starter [bluedogranch](https://wordpress.org/support/users/bluedogranch/)
 * (@bluedogranch)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/minimum-mysql-version-needed/#post-15984417)
 * Thanks for the info! I’ve got a client site with 500K users, using MySQL 5.5.6,
   and the host won’t update MySQL to 5.5.62.
 * I would also first change the tables to InnoDB with your other plugin, but the
   limiting factor is MySQL version, and I don’t want to use an SQL query to alter
   the tables and risk a timeout, due to the table sizes (total DB size is 7 gigs).
 * Is there an appreciable difference between MySQL 5.5.6 and 5.5.62?
 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/minimum-mysql-version-needed/#post-15985139)
 * Can you log in to your dbms server with some MySQL client, like phpmyadmin? If
   so you can give these sorts of SQL statements to upgrade your tables.
 * Always start with the strange-looking `SET` statement; it makes sure MySQL won’t
   choke on the default-0 date columns in some tables when it does formatting or
   keying operations on the table.
 *     ```
       SET @@sql_mode := REPLACE(@@sql_mode, 'NO_ZERO_DATE', '');
       ALTER TABLE wp_postmeta ENGINE=InnoDb, ROW_FORMAT=DYNAMIC;
       ALTER TABLE wp_posts ENGINE=InnoDb, ROW_FORMAT=DYNAMIC;
       ```
   
 * This would change those two tables over to InnoDB.
 * The timeout issue? Doing this kind of thing from phpmyadmin or some other SQL
   client program means it’s not affected by the web server timeout. The [Index WP MySQL For Speed](https://wordpress.org/plugins/index-wp-mysql-for-speed/)
   dashboard user interface is, of course, affected by that. But not the wp-cli 
   interface, read on.
 * If you can use wp-cli, you can install [Index WP MySQL for Speed](https://wordpress.org/plugins/index-wp-mysql-for-speed/),
   then use a command like this
 *  wp index-mysql upgrade wp_posts wp_postmeta
 * to upgrade a couple of tables to InnoDB. This doesn’t time out either. If you
   want a guide to what that cli can do, say
 *  wp index-mysql help
 * ALL THAT BEING SAID, you know and I know what serious problems can come from 
   hosting services with years-obsolete software versions. Not only performance 
   and support problems, but also information security problems. I wish you the 
   best of luck persuading your client of this and getting them to move. Because
   move they should.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Minimum MySQL version needed?’ is closed to new replies.

 * ![](https://ps.w.org/index-wp-users-for-speed/assets/icon-128x128.png?rev=2706957)
 * [Index WP Users For Speed](https://wordpress.org/plugins/index-wp-users-for-speed/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/index-wp-users-for-speed/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/index-wp-users-for-speed/)
 * [Active Topics](https://wordpress.org/support/plugin/index-wp-users-for-speed/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/index-wp-users-for-speed/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/index-wp-users-for-speed/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [OllieJones](https://wordpress.org/support/users/olliejones/)
 * Last activity: [3 years, 9 months ago](https://wordpress.org/support/topic/minimum-mysql-version-needed/#post-15985139)
 * Status: resolved