Title: Wp-staging compatibility
Last modified: July 29, 2023

---

# Wp-staging compatibility

 *  Resolved [dev](https://wordpress.org/support/users/devksec/)
 * (@devksec)
 * [3 years ago](https://wordpress.org/support/topic/wp-staging-compatibility/)
 * Hello,
 * Since adding high-performance indexes, Wp-staging has a banner notice on the 
   site. Is this an issue?
 * **The primary key for table wp_options has been changed from option_id to option_name.**
   
   If you encounter performance issues during cloning or backup, we recommend changing
   it back to option_id as the primary key.[https://wp-staging.com/docs/missing-primary-key-in-table-wp-options](https://wp-staging.com/docs/missing-primary-key-in-table-wp-options)

Viewing 1 replies (of 1 total)

 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [3 years ago](https://wordpress.org/support/topic/wp-staging-compatibility/#post-16933182)
 * Thanks for the question. WP-Staging’s notice is accurate. It’s true that the 
   high-performance keying for `wp_options` uses a primary key of `option_name` 
   rather than the autoincrementing `option_id`. We did this to take advantage of
   MySQL / MariaDB [clustered indexes](https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html).
   This should not affect Wp-Staging’s ability to migrate the database. (But I haven‘
   t tried it, yet.) You should be **good to go.**
 * I suspect Wp-Staging added some checks of various tables because they had some
   user issues with bizarrely indexed legacy sites.
 * Again, you should be good to go.
 * Note: if you migrate a site from a current version of MySQL (5.7+) to a legacy
   version (5.6-) you’ll have problems unless you revert to standard keys first.
   But that kind of back-migration operation is increasingly rare.

Viewing 1 replies (of 1 total)

The topic ‘Wp-staging compatibility’ is closed to new replies.

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

 * 1 reply
 * 2 participants
 * Last reply from: [OllieJones](https://wordpress.org/support/users/olliejones/)
 * Last activity: [3 years ago](https://wordpress.org/support/topic/wp-staging-compatibility/#post-16933182)
 * Status: resolved