is some keys missing ?

  • Resolved maherlink

    (@maherlink)


    1 year, 4 months ago

    I read your article, about the keys

    https://www.plumislandmedia.net/index-wp-mysql-for-speed/tables_and_keys/

    I found that some keys may not exist according to the article like wp_posts keys I checked it on phpMyAdmin I found these keys only :
      

post_date
    post_date_gmt
    post_content
    post_title
    post_excerpt
    post_status
    comment_status
    ping_status
    post_password
    post_name
    to_ping
    pinged
    post_modified
    post_modified_gmt
    post_content_filtered
    post_parent
    guid
    menu_order
    post_type
    post_mime_type

    In the article you mentioned the key table and I can’t find them
    is it normal not finding the keys you mentioned and I have 30-50% cpu usage of mysql
    wp_postmeta keys just fine and I found them like what you added in the table HERE https://www.plumislandmedia.net/index-wp-mysql-for-speed/tables_and_keys/

    MY UPLOAD ID
    XpzaDd8Z

    • This topic was modified 1 year, 4 months ago by maherlink.
    • This topic was modified 1 year, 4 months ago by maherlink.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author OllieJones

    (@olliejones)

    Your site’s keys, at any rate for the WordPress core tables, are the ones created by this plugin.

    The columns you mentioned don’t have keys. It’s very rare that all columns in a table have keys; they don’t help performance unless they’re used to search the table..

    According to your uploaded metadata, your site is provisioned ok. But the metadata doesn’t show information about your site’s stack other than your dbms. So I don’t have enough information to explain

Viewing 1 replies (of 1 total)
  • The topic ‘is some keys missing ?’ is closed to new replies.

Tags