{"id":28414,"date":"2018-02-26T13:12:17","date_gmt":"2018-02-26T11:12:17","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=28414"},"modified":"2018-02-26T13:12:17","modified_gmt":"2018-02-26T11:12:17","slug":"top-10-mysql-8-0-features-for-dbas-ops","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2018\/02\/26\/top-10-mysql-8-0-features-for-dbas-ops\/","title":{"rendered":"TOP 10 MySQL 8.0 features for DBAs & OPS"},"content":{"rendered":"\n

Here’s a list of the TOP 10 MySQL 8.0 features for DBAs and OPS<\/a>, with some detailed explanations of what they are and links to more information.\u00a0 The features covered are:<\/p>\n

    \n
  1. Temporary Tables Improvements<\/li>\n
  2. Persistent global variables<\/li>\n
  3. No more InnoDB System Tables<\/li>\n
  4. Reclaim UNDO space from large transactions<\/li>\n
  5. UTF8 performance<\/li>\n
  6. Removing Query Cache<\/li>\n
  7. Atomic DDLs<\/li>\n
  8. Faster & More Complete Performance Schema (Histograms, Indexes, \u2026) and Information Schema<\/li>\n
  9. ROLES<\/li>\n
  10. REDO & UNDO logs encrypted if tablespace is encrypted<\/li>\n<\/ol>\n\n","protected":false},"excerpt":{"rendered":"\n

    Here’s a list of the TOP 10 MySQL 8.0 features for DBAs and OPS, with some detailed explanations of what they are and links to more information.\u00a0 The features covered are: Temporary Tables Improvements Persistent global variables No more InnoDB System Tables Reclaim UNDO space from large transactions UTF8 performance Removing Query Cache Atomic DDLs … Continue reading TOP 10 MySQL 8.0 features for DBAs & OPS<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"TOP 10 MySQL 8.0 features for DBAs & OPS #WebDev #MySQL #databases #performance #lists","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,18,133,62,1334],"tags":[1559,2904,991,3066,1057,1330],"keyring_services":[],"class_list":["post-28414","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-sysadmin","category-technology","category-web-work","tag-databases","tag-lists","tag-milestones","tag-mysql","tag-performance","tag-web-development"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t