Digital Ocean wants all tables to have Primary Keys

  • Resolved skbarnes

    (@skbarnes)


    4 years, 4 months ago

    Hi,

    my host Digital Ocean has sent the following email regarding their managed database service

    “Our systems have indicated that your MySQL cluster, xxxxxx-mysql-sgp1-xxxx, has tables without primary keys. We have identified that MySQL tables without primary keys can lead to service replication issues that jeopardize performance and availability. If primary keys are not present for database tables exceeding 5,000 rows, data-loss can occur.”

    Would it be possible to add primary keys to the following tables?
    wp_wpfb_gettwitter_forms
    wp_wpfb_post_templates
    wp_wpfb_reviews

    Thanks in advance

    Steve

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author jgwhite33

    (@jgwhite33)

    Sure, give me a few days and I’ll get it updated.

    Plugin Author jgwhite33

    (@jgwhite33)

    I just uploaded version 9 that should fix this. After you update, de-activate and re-activate the plugin so it can update the database.

    What about paying users? We are on “11.0.8 Premium” but WordPress isn’t prompting to update. Has an update been pushed to the premium channel?

    Plugin Author jgwhite33

    (@jgwhite33)

    @mountainash The beta version 11.0.8.1 has this in it and it will be pushed in the next update. If you want to try the beta version just go to the Account page inside the plugin and check the box for “join beta users”. Then it should show up as an update.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Digital Ocean wants all tables to have Primary Keys’ is closed to new replies.