CINXE.COM
MySQL 8.0 - Simply.com blog
<!DOCTYPE html> <html lang="da-DK" class="no-js"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="profile" href="https://gmpg.org/xfn/11"> <script>(function(html){html.className = html.className.replace(/\bno-js\b/,'js')})(document.documentElement);</script> <meta name='robots' content='index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1' /> <style>img:is([sizes="auto" i], [sizes^="auto," i]) { contain-intrinsic-size: 3000px 1500px }</style> <link rel="alternate" hreflang="da" href="https://blog.simply.com/2023/mysql80/" /> <!-- This site is optimized with the Yoast SEO plugin v23.9 - https://yoast.com/wordpress/plugins/seo/ --> <title>MySQL 8.0 - Simply.com blog</title> <link rel="canonical" href="https://blog.simply.com/2023/mysql80/" /> <meta property="og:locale" content="da_DK" /> <meta property="og:type" content="article" /> <meta property="og:title" content="MySQL 8.0 - Simply.com blog" /> <meta property="og:description" content="Vi er (endelig) g氓et i gang med at opgradere vores webhoteller til MySQL 8.0. Vi har ad flere omgange testet MySQL 8, men fundet flere performancefejl, der gjorde, at vi ikke kunne opgradere fra MySQL 5.7. Faktisk fandt vi en fejl, som specifikt gjorde, at WordPress-performance var elendig p氓 MySQL 8. Heldigvis er denne fejl … L忙s videre "MySQL 8.0"" /> <meta property="og:url" content="https://blog.simply.com/2023/mysql80/" /> <meta property="og:site_name" content="Simply.com blog" /> <meta property="article:publisher" content="https://www.facebook.com/simplycom" /> <meta property="article:published_time" content="2023-02-01T08:16:11+00:00" /> <meta property="article:modified_time" content="2023-02-03T09:43:11+00:00" /> <meta property="og:image" content="https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality.jpeg" /> <meta name="author" content="Tom Sommer (Simply.com)" /> <meta name="twitter:card" content="summary_large_image" /> <meta name="twitter:creator" content="@simplydotcom" /> <meta name="twitter:site" content="@simplydotcom" /> <meta name="twitter:label1" content="Skrevet af" /> <meta name="twitter:data1" content="Tom Sommer (Simply.com)" /> <meta name="twitter:label2" content="Estimeret l忙setid" /> <meta name="twitter:data2" content="1 minut" /> <script type="application/ld+json" class="yoast-schema-graph">{"@context":"https://schema.org","@graph":[{"@type":"Article","@id":"https://blog.simply.com/2023/mysql80/#article","isPartOf":{"@id":"https://blog.simply.com/2023/mysql80/"},"author":{"name":"Tom Sommer (Simply.com)","@id":"https://blog.simply.com/#/schema/person/75b6f03c345c3f5349bdaf25a3d56550"},"headline":"MySQL 8.0","datePublished":"2023-02-01T08:16:11+00:00","dateModified":"2023-02-03T09:43:11+00:00","mainEntityOfPage":{"@id":"https://blog.simply.com/2023/mysql80/"},"wordCount":135,"commentCount":0,"publisher":{"@id":"https://blog.simply.com/#organization"},"image":{"@id":"https://blog.simply.com/2023/mysql80/#primaryimage"},"thumbnailUrl":"https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality.jpeg","keywords":["feature","mysql","mysql8"],"articleSection":["Drift"],"inLanguage":"da-DK","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https://blog.simply.com/2023/mysql80/#respond"]}]},{"@type":"WebPage","@id":"https://blog.simply.com/2023/mysql80/","url":"https://blog.simply.com/2023/mysql80/","name":"MySQL 8.0 - Simply.com blog","isPartOf":{"@id":"https://blog.simply.com/#website"},"primaryImageOfPage":{"@id":"https://blog.simply.com/2023/mysql80/#primaryimage"},"image":{"@id":"https://blog.simply.com/2023/mysql80/#primaryimage"},"thumbnailUrl":"https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality.jpeg","datePublished":"2023-02-01T08:16:11+00:00","dateModified":"2023-02-03T09:43:11+00:00","inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https://blog.simply.com/2023/mysql80/"]}]},{"@type":"ImageObject","inLanguage":"da-DK","@id":"https://blog.simply.com/2023/mysql80/#primaryimage","url":"https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality.jpeg","contentUrl":"https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality.jpeg","width":786,"height":378},{"@type":"WebSite","@id":"https://blog.simply.com/#website","url":"https://blog.simply.com/","name":"Simply.com blog","description":"F氓 de seneste nyheder om dom忙ner og webhoteller her.","publisher":{"@id":"https://blog.simply.com/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://blog.simply.com/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"},{"@type":"Organization","@id":"https://blog.simply.com/#organization","name":"Simply.com","url":"https://blog.simply.com/","logo":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https://blog.simply.com/#/schema/logo/image/","url":"https://blog.simply.com/wp-content/uploads/2022/11/simply-logo-opengraph-wide.png","contentUrl":"https://blog.simply.com/wp-content/uploads/2022/11/simply-logo-opengraph-wide.png","width":1200,"height":630,"caption":"Simply.com"},"image":{"@id":"https://blog.simply.com/#/schema/logo/image/"},"sameAs":["https://www.facebook.com/simplycom","https://x.com/simplydotcom","https://www.linkedin.com/simplycom"]},{"@type":"Person","@id":"https://blog.simply.com/#/schema/person/75b6f03c345c3f5349bdaf25a3d56550","name":"Tom Sommer (Simply.com)"}]}</script> <!-- / Yoast SEO plugin. --> <link rel="alternate" type="application/rss+xml" title="Simply.com blog » Feed" href="https://blog.simply.com/feed/" /> <link rel="alternate" type="application/rss+xml" title="Simply.com blog »-kommentar-feed" href="https://blog.simply.com/comments/feed/" /> <!-- This site uses the Google Analytics by MonsterInsights plugin v9.2.2 - Using Analytics tracking - https://www.monsterinsights.com/ --> <!-- Note: MonsterInsights is not currently configured on this site. The site owner needs to authenticate with Google Analytics in the MonsterInsights settings panel. --> <!-- No tracking code set --> <!-- / Google Analytics by MonsterInsights --> <script> window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/15.0.3\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/15.0.3\/svg\/","svgExt":".svg","source":{"concatemoji":"https:\/\/blog.simply.com\/wp-includes\/js\/wp-emoji-release.min.js?ver=6.7.1"}}; /*! This file is auto-generated */ !function(i,n){var o,s,e;function c(e){try{var t={supportTests:e,timestamp:(new Date).valueOf()};sessionStorage.setItem(o,JSON.stringify(t))}catch(e){}}function p(e,t,n){e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(t,0,0);var t=new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data),r=(e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(n,0,0),new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data));return t.every(function(e,t){return e===r[t]})}function u(e,t,n){switch(t){case"flag":return n(e,"\ud83c\udff3\ufe0f\u200d\u26a7\ufe0f","\ud83c\udff3\ufe0f\u200b\u26a7\ufe0f")?!1:!n(e,"\ud83c\uddfa\ud83c\uddf3","\ud83c\uddfa\u200b\ud83c\uddf3")&&!n(e,"\ud83c\udff4\udb40\udc67\udb40\udc62\udb40\udc65\udb40\udc6e\udb40\udc67\udb40\udc7f","\ud83c\udff4\u200b\udb40\udc67\u200b\udb40\udc62\u200b\udb40\udc65\u200b\udb40\udc6e\u200b\udb40\udc67\u200b\udb40\udc7f");case"emoji":return!n(e,"\ud83d\udc26\u200d\u2b1b","\ud83d\udc26\u200b\u2b1b")}return!1}function f(e,t,n){var r="undefined"!=typeof WorkerGlobalScope&&self instanceof WorkerGlobalScope?new OffscreenCanvas(300,150):i.createElement("canvas"),a=r.getContext("2d",{willReadFrequently:!0}),o=(a.textBaseline="top",a.font="600 32px Arial",{});return e.forEach(function(e){o[e]=t(a,e,n)}),o}function t(e){var t=i.createElement("script");t.src=e,t.defer=!0,i.head.appendChild(t)}"undefined"!=typeof Promise&&(o="wpEmojiSettingsSupports",s=["flag","emoji"],n.supports={everything:!0,everythingExceptFlag:!0},e=new Promise(function(e){i.addEventListener("DOMContentLoaded",e,{once:!0})}),new Promise(function(t){var n=function(){try{var e=JSON.parse(sessionStorage.getItem(o));if("object"==typeof e&&"number"==typeof e.timestamp&&(new Date).valueOf()<e.timestamp+604800&&"object"==typeof e.supportTests)return e.supportTests}catch(e){}return null}();if(!n){if("undefined"!=typeof Worker&&"undefined"!=typeof OffscreenCanvas&&"undefined"!=typeof URL&&URL.createObjectURL&&"undefined"!=typeof Blob)try{var e="postMessage("+f.toString()+"("+[JSON.stringify(s),u.toString(),p.toString()].join(",")+"));",r=new Blob([e],{type:"text/javascript"}),a=new Worker(URL.createObjectURL(r),{name:"wpTestEmojiSupports"});return void(a.onmessage=function(e){c(n=e.data),a.terminate(),t(n)})}catch(e){}c(n=f(s,u,p))}t(n)}).then(function(e){for(var t in e)n.supports[t]=e[t],n.supports.everything=n.supports.everything&&n.supports[t],"flag"!==t&&(n.supports.everythingExceptFlag=n.supports.everythingExceptFlag&&n.supports[t]);n.supports.everythingExceptFlag=n.supports.everythingExceptFlag&&!n.supports.flag,n.DOMReady=!1,n.readyCallback=function(){n.DOMReady=!0}}).then(function(){return e}).then(function(){var e;n.supports.everything||(n.readyCallback(),(e=n.source||{}).concatemoji?t(e.concatemoji):e.wpemoji&&e.twemoji&&(t(e.twemoji),t(e.wpemoji)))}))}((window,document),window._wpemojiSettings); </script> <style id='wp-emoji-styles-inline-css'> img.wp-smiley, img.emoji { display: inline !important; border: none !important; box-shadow: none !important; height: 1em !important; width: 1em !important; margin: 0 0.07em !important; vertical-align: -0.1em !important; background: none !important; padding: 0 !important; } </style> <link rel='stylesheet' id='wp-block-library-css' href='https://blog.simply.com/wp-includes/css/dist/block-library/style.min.css?ver=6.7.1' media='all' /> <style id='wp-block-library-theme-inline-css'> .wp-block-audio :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-audio :where(figcaption){color:#ffffffa6}.wp-block-audio{margin:0 0 1em}.wp-block-code{border:1px solid #ccc;border-radius:4px;font-family:Menlo,Consolas,monaco,monospace;padding:.8em 1em}.wp-block-embed :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-embed :where(figcaption){color:#ffffffa6}.wp-block-embed{margin:0 0 1em}.blocks-gallery-caption{color:#555;font-size:13px;text-align:center}.is-dark-theme .blocks-gallery-caption{color:#ffffffa6}:root :where(.wp-block-image figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme :root :where(.wp-block-image figcaption){color:#ffffffa6}.wp-block-image{margin:0 0 1em}.wp-block-pullquote{border-bottom:4px solid;border-top:4px solid;color:currentColor;margin-bottom:1.75em}.wp-block-pullquote cite,.wp-block-pullquote footer,.wp-block-pullquote__citation{color:currentColor;font-size:.8125em;font-style:normal;text-transform:uppercase}.wp-block-quote{border-left:.25em solid;margin:0 0 1.75em;padding-left:1em}.wp-block-quote cite,.wp-block-quote footer{color:currentColor;font-size:.8125em;font-style:normal;position:relative}.wp-block-quote:where(.has-text-align-right){border-left:none;border-right:.25em solid;padding-left:0;padding-right:1em}.wp-block-quote:where(.has-text-align-center){border:none;padding-left:0}.wp-block-quote.is-large,.wp-block-quote.is-style-large,.wp-block-quote:where(.is-style-plain){border:none}.wp-block-search .wp-block-search__label{font-weight:700}.wp-block-search__button{border:1px solid #ccc;padding:.375em .625em}:where(.wp-block-group.has-background){padding:1.25em 2.375em}.wp-block-separator.has-css-opacity{opacity:.4}.wp-block-separator{border:none;border-bottom:2px solid;margin-left:auto;margin-right:auto}.wp-block-separator.has-alpha-channel-opacity{opacity:1}.wp-block-separator:not(.is-style-wide):not(.is-style-dots){width:100px}.wp-block-separator.has-background:not(.is-style-dots){border-bottom:none;height:1px}.wp-block-separator.has-background:not(.is-style-wide):not(.is-style-dots){height:2px}.wp-block-table{margin:0 0 1em}.wp-block-table td,.wp-block-table th{word-break:normal}.wp-block-table :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-table :where(figcaption){color:#ffffffa6}.wp-block-video :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-video :where(figcaption){color:#ffffffa6}.wp-block-video{margin:0 0 1em}:root :where(.wp-block-template-part.has-background){margin-bottom:0;margin-top:0;padding:1.25em 2.375em} </style> <style id='classic-theme-styles-inline-css'> /*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} </style> <style id='global-styles-inline-css'> :root{--wp--preset--aspect-ratio--square: 1;--wp--preset--aspect-ratio--4-3: 4/3;--wp--preset--aspect-ratio--3-4: 3/4;--wp--preset--aspect-ratio--3-2: 3/2;--wp--preset--aspect-ratio--2-3: 2/3;--wp--preset--aspect-ratio--16-9: 16/9;--wp--preset--aspect-ratio--9-16: 9/16;--wp--preset--color--black: #000000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #fff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--color--dark-gray: #1a1a1a;--wp--preset--color--medium-gray: #686868;--wp--preset--color--light-gray: #e5e5e5;--wp--preset--color--blue-gray: #4d545c;--wp--preset--color--bright-blue: #007acc;--wp--preset--color--light-blue: #9adffd;--wp--preset--color--dark-brown: #402b30;--wp--preset--color--medium-brown: #774e24;--wp--preset--color--dark-red: #640c1f;--wp--preset--color--bright-red: #ff675f;--wp--preset--color--yellow: #ffef8e;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgba(6,147,227,1) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgba(255,105,0,1) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small: 13px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 36px;--wp--preset--font-size--x-large: 42px;--wp--preset--spacing--20: 0.44rem;--wp--preset--spacing--30: 0.67rem;--wp--preset--spacing--40: 1rem;--wp--preset--spacing--50: 1.5rem;--wp--preset--spacing--60: 2.25rem;--wp--preset--spacing--70: 3.38rem;--wp--preset--spacing--80: 5.06rem;--wp--preset--shadow--natural: 6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep: 12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp: 6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined: 6px 6px 0px -3px rgba(255, 255, 255, 1), 6px 6px rgba(0, 0, 0, 1);--wp--preset--shadow--crisp: 6px 6px 0px rgba(0, 0, 0, 1);}:where(.is-layout-flex){gap: 0.5em;}:where(.is-layout-grid){gap: 0.5em;}body .is-layout-flex{display: flex;}.is-layout-flex{flex-wrap: wrap;align-items: center;}.is-layout-flex > :is(*, div){margin: 0;}body .is-layout-grid{display: grid;}.is-layout-grid > :is(*, div){margin: 0;}:where(.wp-block-columns.is-layout-flex){gap: 2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;}:where(.wp-block-post-template.is-layout-flex){gap: 1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;} :where(.wp-block-post-template.is-layout-flex){gap: 1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;} :where(.wp-block-columns.is-layout-flex){gap: 2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;} :root :where(.wp-block-pullquote){font-size: 1.5em;line-height: 1.6;} </style> <link rel='stylesheet' id='wpml-legacy-horizontal-list-0-css' href='//blog.simply.com/wp-content/plugins/sitepress-multilingual-cms/templates/language-switchers/legacy-list-horizontal/style.min.css?ver=1' media='all' /> <style id='wpml-legacy-horizontal-list-0-inline-css'> .wpml-ls-statics-footer a {color:#444444;background-color:#ffffff;}.wpml-ls-statics-footer a:hover,.wpml-ls-statics-footer a:focus {color:#000000;background-color:#eeeeee;}.wpml-ls-statics-footer .wpml-ls-current-language>a {color:#444444;background-color:#ffffff;}.wpml-ls-statics-footer .wpml-ls-current-language:hover>a, .wpml-ls-statics-footer .wpml-ls-current-language>a:focus {color:#000000;background-color:#eeeeee;} </style> <link rel='stylesheet' id='twentysixteen-fonts-css' href='https://blog.simply.com/wp-content/themes/twentysixteen/fonts/merriweather-plus-montserrat-plus-inconsolata.css?ver=20230328' media='all' /> <link rel='stylesheet' id='genericons-css' href='https://blog.simply.com/wp-content/themes/twentysixteen/genericons/genericons.css?ver=20201208' media='all' /> <link rel='stylesheet' id='twentysixteen-style-css' href='https://blog.simply.com/wp-content/themes/twentysixteen/style.css?ver=20241112' media='all' /> <link rel='stylesheet' id='twentysixteen-block-style-css' href='https://blog.simply.com/wp-content/themes/twentysixteen/css/blocks.css?ver=20240817' media='all' /> <!--[if lt IE 10]> <link rel='stylesheet' id='twentysixteen-ie-css' href='https://blog.simply.com/wp-content/themes/twentysixteen/css/ie.css?ver=20170530' media='all' /> <![endif]--> <!--[if lt IE 9]> <link rel='stylesheet' id='twentysixteen-ie8-css' href='https://blog.simply.com/wp-content/themes/twentysixteen/css/ie8.css?ver=20170530' media='all' /> <![endif]--> <!--[if lt IE 8]> <link rel='stylesheet' id='twentysixteen-ie7-css' href='https://blog.simply.com/wp-content/themes/twentysixteen/css/ie7.css?ver=20170530' media='all' /> <![endif]--> <!--[if lt IE 9]> <script src="https://blog.simply.com/wp-content/themes/twentysixteen/js/html5.js?ver=3.7.3" id="twentysixteen-html5-js"></script> <![endif]--> <script src="https://blog.simply.com/wp-includes/js/jquery/jquery.min.js?ver=3.7.1" id="jquery-core-js"></script> <script src="https://blog.simply.com/wp-includes/js/jquery/jquery-migrate.min.js?ver=3.4.1" id="jquery-migrate-js"></script> <script id="twentysixteen-script-js-extra"> var screenReaderText = {"expand":"udvid undermenu","collapse":"skjul undermenu"}; </script> <script src="https://blog.simply.com/wp-content/themes/twentysixteen/js/functions.js?ver=20230629" id="twentysixteen-script-js" defer data-wp-strategy="defer"></script> <link rel="https://api.w.org/" href="https://blog.simply.com/wp-json/" /><link rel="alternate" title="JSON" type="application/json" href="https://blog.simply.com/wp-json/wp/v2/posts/6331" /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://blog.simply.com/xmlrpc.php?rsd" /> <meta name="generator" content="WordPress 6.7.1" /> <link rel='shortlink' href='https://blog.simply.com/?p=6331' /> <link rel="alternate" title="oEmbed (JSON)" type="application/json+oembed" href="https://blog.simply.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fblog.simply.com%2F2023%2Fmysql80%2F" /> <link rel="alternate" title="oEmbed (XML)" type="text/xml+oembed" href="https://blog.simply.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fblog.simply.com%2F2023%2Fmysql80%2F&format=xml" /> <meta name="generator" content="WPML ver:4.4.10 stt:12,1,40,50;" /> <style type="text/css" id="twentysixteen-header-css"> .site-branding { margin: 0 auto 0 0; } .site-branding .site-title, .site-description { clip: rect(1px, 1px, 1px, 1px); position: absolute; } </style> <style id="custom-background-css"> body.custom-background { background-color: #ffffff; } </style> <link rel="icon" href="https://blog.simply.com/wp-content/uploads/2022/11/cropped-simply_logomark_rgb-32x32.png" sizes="32x32" /> <link rel="icon" href="https://blog.simply.com/wp-content/uploads/2022/11/cropped-simply_logomark_rgb-192x192.png" sizes="192x192" /> <link rel="apple-touch-icon" href="https://blog.simply.com/wp-content/uploads/2022/11/cropped-simply_logomark_rgb-180x180.png" /> <meta name="msapplication-TileImage" content="https://blog.simply.com/wp-content/uploads/2022/11/cropped-simply_logomark_rgb-270x270.png" /> <style id="wp-custom-css"> .bordery { border: 1px !important; border-style: solid !important; border-color: #ccc !important; } .page-links-title { font-size: 117% !important; padding-top: 20px !important; } .post-page-numbers { font-size: 112% !important; } </style> </head> <body data-rsssl=1 class="post-template-default single single-post postid-6331 single-format-standard custom-background wp-custom-logo wp-embed-responsive group-blog"> <div id="page" class="site"> <div class="site-inner"> <a class="skip-link screen-reader-text" href="#content"> Videre til indhold </a> <header id="masthead" class="site-header"> <div class="site-header-main"> <div class="site-branding"> <a href="https://blog.simply.com/" class="custom-logo-link" rel="home"><img width="238" height="44" src="https://blog.simply.com/wp-content/uploads/2022/11/simply-logo-color.svg" class="custom-logo" alt="Simply.com blog" decoding="async" /></a> <p class="site-title"><a href="https://blog.simply.com/" rel="home">Simply.com blog</a></p> <p class="site-description">F氓 de seneste nyheder om dom忙ner og webhoteller her.</p> </div><!-- .site-branding --> <button id="menu-toggle" class="menu-toggle">Menu</button> <div id="site-header-menu" class="site-header-menu"> <nav id="site-navigation" class="main-navigation" aria-label="Prim忙r menu"> <div class="menu-simply-com-container"><ul id="menu-simply-com" class="primary-menu"><li id="menu-item-2082" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2082"><a href="/">Blog</a></li> <li id="menu-item-3680" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3680"><a href="https://www.simply.com/domains/">Dom忙ner</a></li> <li id="menu-item-3681" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3681"><a href="https://www.simply.com/products/">Webhoteller</a></li> <li id="menu-item-3581" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3581"><a href="https://share-eu1.hsforms.com/1g4mLaBoZTLKPywteIeZ7XAezie0">Tilmeld nyhedsbrev</a></li> <li id="menu-item-1851" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1851"><a href="https://www.simply.com">Simply.com</a></li> </ul></div> </nav><!-- .main-navigation --> <nav id="social-navigation" class="social-navigation" aria-label="Menu til sociale links"> <div class="menu-simply-com-container"><ul id="menu-simply-com-1" class="social-links-menu"><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2082"><a href="/"><span class="screen-reader-text">Blog</span></a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3680"><a href="https://www.simply.com/domains/"><span class="screen-reader-text">Dom忙ner</span></a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3681"><a href="https://www.simply.com/products/"><span class="screen-reader-text">Webhoteller</span></a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3581"><a href="https://share-eu1.hsforms.com/1g4mLaBoZTLKPywteIeZ7XAezie0"><span class="screen-reader-text">Tilmeld nyhedsbrev</span></a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1851"><a href="https://www.simply.com"><span class="screen-reader-text">Simply.com</span></a></li> </ul></div> </nav><!-- .social-navigation --> </div><!-- .site-header-menu --> </div><!-- .site-header-main --> <div class="header-image"> <a href="https://blog.simply.com/" rel="home"> <img src="https://blog.simply.com/wp-content/uploads/2020/05/cropped-simplyblog.jpg" width="1200" height="280" alt="Simply.com blog" sizes="(max-width: 709px) 85vw, (max-width: 909px) 81vw, (max-width: 1362px) 88vw, 1200px" srcset="https://blog.simply.com/wp-content/uploads/2020/05/cropped-simplyblog.jpg 1200w, https://blog.simply.com/wp-content/uploads/2020/05/cropped-simplyblog-300x70.jpg 300w, https://blog.simply.com/wp-content/uploads/2020/05/cropped-simplyblog-1024x239.jpg 1024w, https://blog.simply.com/wp-content/uploads/2020/05/cropped-simplyblog-150x35.jpg 150w" decoding="async" fetchpriority="high" /> </a> </div><!-- .header-image --> </header><!-- .site-header --> <div id="content" class="site-content"> <div id="primary" class="content-area"> <main id="main" class="site-main"> <article id="post-6331" class="post-6331 post type-post status-publish format-standard hentry category-drift tag-feature tag-mysql tag-mysql8"> <header class="entry-header"> <h1 class="entry-title">MySQL 8.0</h1> </header><!-- .entry-header --> <div class="entry-content"> <figure class="wp-block-image size-full"><img decoding="async" width="786" height="378" src="https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality.jpeg" alt="" class="wp-image-6339" srcset="https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality.jpeg 786w, https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality-300x144.jpeg 300w, https://blog.simply.com/wp-content/uploads/2023/02/Blog-illustration-image-template-4-High-Quality-150x72.jpeg 150w" sizes="(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px" /></figure> <p>Vi er (endelig) g氓et i gang med at opgradere vores webhoteller til MySQL 8.0.<br /><br />Vi har ad flere omgange testet MySQL 8, men fundet flere performancefejl, der gjorde, at vi ikke kunne opgradere fra MySQL 5.7. Faktisk fandt vi <a href="https://bugs.mysql.com/bug.php?id=98750">en fejl</a>, som specifikt gjorde, at WordPress-performance var elendig p氓 MySQL 8. Heldigvis er denne fejl nu l酶st, og vores tests har ikke fundet andre problemer. Derfor f酶ler vi os trygge ved at opgradere samtlige MySQL-servere til MySQL 8.</p> <span id="more-6331"></span> <p>MySQL 8 er en stor opgradering i forhold til tidligere versioner. Det indeholder mange forbedringer, herunder en forbedret dataintegritet, bedre ydeevne, avancerede sikkerhedsfunktioner, en forbedret skalerbarhed og mange nye funktioner, der kan forbedre dit arbejde med databaser.</p> <p>MySQL 8 vil v忙re opsat p氓 en bagud-kompatibel m氓de, s氓 der b酶r ikke v忙re problemer i forbindelse med opgraderingen.</p> </div><!-- .entry-content --> <footer class="entry-footer"> <span class="byline"><span class="screen-reader-text">Forfatter </span><span class="author vcard"><a class="url fn n" href="https://blog.simply.com/author/ts/">Tom Sommer (Simply.com)</a></span></span><span class="posted-on"><span class="screen-reader-text">Udgivet </span><a href="https://blog.simply.com/2023/mysql80/" rel="bookmark"><time class="entry-date published" datetime="2023-02-01T09:16:11+01:00">1. februar 2023</time><time class="updated" datetime="2023-02-03T10:43:11+01:00">3. februar 2023</time></a></span><span class="cat-links"><span class="screen-reader-text">Kategorier </span><a href="https://blog.simply.com/category/drift/" rel="category tag">Drift</a></span><span class="tags-links"><span class="screen-reader-text">Tags </span><a href="https://blog.simply.com/tag/feature/" rel="tag">feature</a>, <a href="https://blog.simply.com/tag/mysql/" rel="tag">mysql</a>, <a href="https://blog.simply.com/tag/mysql8/" rel="tag">mysql8</a></span> </footer><!-- .entry-footer --> </article><!-- #post-6331 --> <nav class="navigation post-navigation" aria-label="Indl忙g"> <h2 class="screen-reader-text">Indl忙gsnavigation</h2> <div class="nav-links"><div class="nav-previous"><a href="https://blog.simply.com/2022/alt-du-skal-vide-om-php-8/" rel="prev"><span class="meta-nav" aria-hidden="true">Forrige</span> <span class="screen-reader-text">Forrige indl忙g:</span> <span class="post-title">Alt du skal vide om PHP 8</span></a></div><div class="nav-next"><a href="https://blog.simply.com/2023/produktpriser-2024/" rel="next"><span class="meta-nav" aria-hidden="true">N忙ste</span> <span class="screen-reader-text">N忙ste indl忙g:</span> <span class="post-title">Produktpriser 2024</span></a></div></div> </nav> </main><!-- .site-main --> </div><!-- .content-area --> <aside id="secondary" class="sidebar widget-area"> <section id="recent-posts-3" class="widget widget_recent_entries"> <h2 class="widget-title">Seneste blogindl忙g</h2><nav aria-label="Seneste blogindl忙g"> <ul> <li> <a href="https://blog.simply.com/2023/mysql80/" aria-current="page">MySQL 8.0</a> </li> <li> <a href="https://blog.simply.com/2022/alt-du-skal-vide-om-php-8/">Alt du skal vide om PHP 8</a> </li> <li> <a href="https://blog.simply.com/2022/saadan-modtager-du-betalinger-paa-din-woocommerce-webshop/">S氓dan modtager du betalinger p氓 din WooCommerce webshop</a> </li> <li> <a href="https://blog.simply.com/2022/php74-eol/">Om PHP 7.4 end-of-life</a> </li> <li> <a href="https://blog.simply.com/2022/saadan-er-du-sikret-mod-stroemafbrydelser-hos-simply-com/">S氓dan er du sikret mod str酶mafbrydelser hos Simply.com</a> </li> <li> <a href="https://blog.simply.com/2022/hvorfor-er-to-faktor-godkendelse-vigtig-for-dine-konti/">Hvorfor er to-faktor godkendelse vigtig for dine konti?</a> </li> <li> <a href="https://blog.simply.com/2022/3-bedste-wordpress-temaer-i-2022/">De 3 bedste WordPress-temaer i 2022</a> </li> <li> <a href="https://blog.simply.com/2022/aendring-paa-websmtp-simply-com/">脝ndring p氓 websmtp.simply.com</a> </li> <li> <a href="https://blog.simply.com/2022/tour-de-managed-wordpress-4/">Tour de Managed WordPress</a> </li> <li> <a href="https://blog.simply.com/2022/tour-de-managed-wordpress-3/">Tour de Managed WordPress</a> </li> </ul> </nav></section><section id="search-4" class="widget widget_search"> <form role="search" method="get" class="search-form" action="https://blog.simply.com/"> <label> <span class="screen-reader-text"> S酶g efter: </span> <input type="search" class="search-field" placeholder="S酶g …" value="" name="s" /> </label> <button type="submit" class="search-submit"><span class="screen-reader-text"> S酶g </span></button> </form> </section><section id="custom_html-2" class="widget_text widget widget_custom_html"><div class="textwidget custom-html-widget"><!-- Facebook Pixel Code --> <script> !function(f,b,e,v,n,t,s) {if(f.fbq)return;n=f.fbq=function(){n.callMethod? n.callMethod.apply(n,arguments):n.queue.push(arguments)}; if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0'; n.queue=[];t=b.createElement(e);t.async=!0; t.src=v;s=b.getElementsByTagName(e)[0]; s.parentNode.insertBefore(t,s)}(window, document,'script', 'https://connect.facebook.net/en_US/fbevents.js'); fbq('init', '623180364478423'); fbq('track', 'PageView'); </script> <noscript><img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=623180364478423&ev=PageView&noscript=1" /></noscript> <!-- End Facebook Pixel Code --></div></section> </aside><!-- .sidebar .widget-area --> </div><!-- .site-content --> <footer id="colophon" class="site-footer"> <nav class="main-navigation" aria-label="Footer, Prim忙r menu"> <div class="menu-simply-com-container"><ul id="menu-simply-com-2" class="primary-menu"><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2082"><a href="/">Blog</a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3680"><a href="https://www.simply.com/domains/">Dom忙ner</a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3681"><a href="https://www.simply.com/products/">Webhoteller</a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3581"><a href="https://share-eu1.hsforms.com/1g4mLaBoZTLKPywteIeZ7XAezie0">Tilmeld nyhedsbrev</a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1851"><a href="https://www.simply.com">Simply.com</a></li> </ul></div> </nav><!-- .main-navigation --> <nav class="social-navigation" aria-label="Footer, Sociale Links Menu"> <div class="menu-simply-com-container"><ul id="menu-simply-com-3" class="social-links-menu"><li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2082"><a href="/"><span class="screen-reader-text">Blog</span></a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3680"><a href="https://www.simply.com/domains/"><span class="screen-reader-text">Dom忙ner</span></a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3681"><a href="https://www.simply.com/products/"><span class="screen-reader-text">Webhoteller</span></a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3581"><a href="https://share-eu1.hsforms.com/1g4mLaBoZTLKPywteIeZ7XAezie0"><span class="screen-reader-text">Tilmeld nyhedsbrev</span></a></li> <li class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1851"><a href="https://www.simply.com"><span class="screen-reader-text">Simply.com</span></a></li> </ul></div> </nav><!-- .social-navigation --> <div class="site-info"> <span class="site-title"><a href="https://blog.simply.com/" rel="home">Simply.com blog</a></span> <a href="https://wordpress.org/" class="imprint"> Drevet af WordPress </a> </div><!-- .site-info --> </footer><!-- .site-footer --> </div><!-- .site-inner --> </div><!-- .site --> <div class="wpml-ls-statics-footer wpml-ls wpml-ls-legacy-list-horizontal"> <ul><li class="wpml-ls-slot-footer wpml-ls-item wpml-ls-item-da wpml-ls-current-language wpml-ls-first-item wpml-ls-last-item wpml-ls-item-legacy-list-horizontal"> <a href="https://blog.simply.com/2023/mysql80/" class="wpml-ls-link"> <img class="wpml-ls-flag" src="https://blog.simply.com/wp-content/plugins/sitepress-multilingual-cms/res/flags/da.png" alt="" /><span class="wpml-ls-native">Dansk</span></a> </li></ul> </div> </body> </html> <!-- Object Caching 76/247 objects using Disk Page Caching using Disk: Enhanced Served from: blog.simply.com @ 2024-11-24 19:41:39 by W3 Total Cache -->