[B! mysql] R2Mのブックマーク

<!DOCTYPE html> <html lang="ja" data-page-scope="User" data-stable-request-url="https://b.hatena.ne.jp/R2M/mysql/" data-device-type="PC" data-sentry-environment="production" data-sentry-sample-rate="0.1" data-author-name="R2M" data-page-subtype="tag" data-page-type="user" data-platform="pc" data-search-query="" data-tag-filter="mysql" data-visitor-name="ゲスト" > <head>  <script> (function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-5TDHQX'); </script>  <meta charset="UTF-8"> <title>[B! mysql] R2Mのブックマーク</title> <script src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/js/v4/bookmark.js" async></script> <link type="text/css" rel="stylesheet" href="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/css/v4/bookmark.css" /> <link type="text/css" rel="stylesheet" href="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/css/v4/bookmark.star.css" /> <link rel="canonical" href="https://b.hatena.ne.jp/R2M/mysql/" /> <link rel="next" href="/R2M/mysql/?page=2"> <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" /> <meta name="viewport" content="width=device-width"> <link rel="search" type="application/opensearchdescription+xml" title="はてなブックマーク検索" href="/opensearch.xml" /> <link rel="search" type="application/opensearchdescription+xml" title="R2M のブックマーク内検索" href="/R2M/opensearch.xml"> <link rel="apple-touch-icon-precomposed" href="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/apple-touch-icon-precomposed.png" /> <link rel="mask-icon" href="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/safari-pinned-tab-icon.svg" color="#00A4DE" /> <meta name="msapplication-navbutton-color" content="#2C6EBD" /> <meta name="msapplication-task" content="name=はてなブックマーク; action-uri=/; icon-uri=https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/icons/bookmark.ico" /> <meta name="msapplication-task" content="name=マイブックマーク; action-uri=/my; icon-uri=https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/icons/my-bookmark.ico" /> <meta name="msapplication-task" content="name=お気に入りのブックマーク; action-uri=/my/favorite; icon-uri=https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/icons/favorite-bookmark.ico" /> <meta name="msapplication-task" content="name=人気エントリー; action-uri=/hotentry; icon-uri=https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/icons/hotentry.ico" /> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="referrer" content="always"> <link rel="author" href="http://www.hatena.ne.jp/R2M/" /> <link rel="alternate" type="application/rss+xml" href="/R2M/bookmark.rss?tag=mysql" /> <script> function isMobile() { const html = document.documentElement; const deviceType = html.dataset.deviceType || ''; if (deviceType.length > 0) { return deviceType === 'MOBILE'; } else { const maxMobileWidth = 480; const windowWidth = window.innerWidth; return maxMobileWidth >= windowWidth; } } </script> </head> <body class="page-centerarticle fixed-header">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-5TDHQX" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="link-app-banner js-dynamic-link-app-banner is-hidden"> <button class="link-app-banner-btn-close js-dynamic-link-app-banner-close-button"><span>close</span></button> <a class="link-app-banner-btn" href="https://hatenabookmark.page.link/app"> <div class="link-app-banner-btn-detail"> <div class="link-app-banner-icon"><img src="/images/v4/public/app/ic-ios.svg" alt="はてなブックマークアプリ"></div> <p class="link-app-banner-text">サクサク読めて、<br class="link-app-banner-text-newline">アプリ限定の機能も多数！</p> </div> <div class="link-app-banner-btn-open">アプリで開く</div> </a> </div> <header id="global-header" data-portal-static-origin="//cdn.www.st-hatena.com"> <div id="header" class="global-header-inner js-global-header-inner"> <h2 id="gh-logo"><a href="/" data-gtm-label="gh-blogo"><span>はてなブックマーク</span></a></h2> <div class="is-guest js-guest is-hidden"> <input id="gh-search-icon-check" type="checkbox" checked="checked" /> <label class="gh-search-icon" for="gh-search-icon-check" aria-label="検索を閉じる"><span>閉じる</span></label> <form class="gh-searchbox" method="get" action="/search_dwim" role="search"> <input value="" name="q" type="search" class="gh-inputtext" placeholder="キーワード・URLを検索" size="40" /> <input value="" type="submit" class="gh-search-button" /> </form> <ul class="gh-service-menu"> <li><a href="/guide" data-gtm-label="gh-guest-guide">はてなブックマークって？</a></li> <li><a href="/guide/tools" data-gtm-label="gh-guest-tools">アプリ・拡張の紹介</a></li> <li><a href="https://www.hatena.ne.jp/register?location=https%3A%2F%2Fb.hatena.ne.jp%2F%3Fregistered_from%3Dglobal-header&via=201037" class="gh-guest-register" data-gtm-label="gh-guest-register">ユーザー登録</a></li> <li><a href="https://www.hatena.ne.jp/login?location=https%3A%2F%2Fb.hatena.ne.jp%2FR2M%2Fmysql%2F" rel="nofollow" class="gh-guest-login" data-gtm-label="gh-guest-login">ログイン</a></li> <li class="gh-hatena-logo"><a href="http://www.hatena.ne.jp/"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/logo/logo-global-white.svg" alt="Hatena" width="74px" height="13px"/></a></li> </ul> </div> <noscript> <ul class="gh-service-menu"> <li><a href="https://www.hatena.ne.jp/logout?location=https%3A%2F%2Fb.hatena.ne.jp%2F">ログアウト</a></li> </ul> </noscript> <script type="text/x-template" id="template-menu-hatena-user"> <form class="gh-searchbox" method="get" action="/search_dwim" role="search"> <input value="" name="q" type="search" class="gh-inputtext" placeholder="キーワード・URLを検索" size="40" /> <input value="" type="submit" class="gh-search-button" /> </form> <ul class="gh-service-menu"> <li><a class="hotentry" data-gtm-label="gh-mypage" href="{{hotentry_url}}"><img src="{{user_image_url}}" class="header-profile-icon" width="16" height="16" alt="{{username}}" /></a><a class="hotentry" data-gtm-label="gh-mypage" href="{{hotentry_url}}">マイページ</a></li> <li><a class="bookmark" data-gtm-label="gh-bookmark" href="{{bookmark_url}}">ブックマーク</a></li> <li><a class="unread_bookmark" data-gtm-label="gh-ril" href="{{bookmark_stock_url}}">あとで読む</a></li> <li><a class="add" data-gtm-label="gh-add" href="{{add_bookmark_url}}">追加</a></li> <li><a class="tools" data-gtm-label="gh-tools" href="/guide/tools">ツール</a></li> <li><a class="config" data-gtm-label="gh-config" href="/-/my/config/profile">設定</a></li> <li><a class="feedback" data-gtm-label="gh-feedback" href="/-/feedback/hatena_bookmark" target="_blank">フィードバック</a></li> <li id="header-username" class="gh-dropdown-services" data-gtm-label="gh-services" title="利用中のサービス" data-name="{{username}}"> <span class="header-dropdown gh-dropdown" tabindex="0"> <img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/usermenu-wh.svg" alt="利用中のサービス" width="24" height="24" /> </span> <dl class="header-window" id="username-window"></dl> </li> <li id="header-notify" data-gtm-label="gh-notify" class="gh-dropdown-notify" title="あなたへのお知らせ"> <span class="header-dropdown gh-dropdown" tabindex="0"> <img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/notify-wh.svg" alt="あなたへのお知らせ" width="25" height="25" /> <span class="notify-count"></span> </span> <div id="notify-window" class="header-window header-notify"></div> </li> <li class="gh-hatena-logo"><a href="http://www.hatena.ne.jp/"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/logo/logo-global-white.svg" alt="Hatena" width="74px" height="13px"/></a></li> </ul> </script> </div> </header> <div id="info-header"><div id="info-header-message"></div><span></span></div> <div class="global-notification is-hidden js-global-notification"></div> <div id="container" class="js-user-page-container" data-author-name="R2M" > <div class="centerarticle-wrapper"> <div class="left-container"> <div class="js-user-info" data-user-name="R2M"> <div class="centerarticle-profile"> <a href="http://profile.hatena.ne.jp/R2M/"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" class="centerarticle-profile-image"/> </a> <div class="centerarticle-profile-main"> <a href="http://profile.hatena.ne.jp/R2M/" class="centerarticle-profile-nickname js-user-info-nickname" target="_blank" rel="noopener">R2M</a> <a href="/R2M/bookmark" class="centerarticle-profile-username">id:R2M</a> </div> </div> <ul class="userprofile-status"> <li> <a href="/R2M/bookmark" class="userprofile-status-link" data-gtm-click-label="user-count-bookmark"> <span class="userprofile-status-count">37,614</span> <span class="userprofile-status-text">ブックマーク</span> </a> </li> <li> <a href="/R2M/follow" class="userprofile-status-link" data-gtm-click-label="user-count-follow"> <span class="userprofile-status-count js-total-followings">-</span> <span class="userprofile-status-text">お気に入り</span> </a> </li> <li> <a href="/R2M/follower" class="userprofile-status-link" data-gtm-click-label="user-count-follower"> <span class="userprofile-status-count js-total-followers">-</span> <span class="userprofile-status-text">お気に入られ</span> </a> </li> </ul> </div> <div class="centerarticle-mainNavi"> </div> <div class="centerarticle-sidebar-menu js-user-tags"> <h3 class="centerarticle-aside-title">タグ</h3> <ul class="centerarticle-sub-navi"> <li><a href="/R2M/bookmark" data-gtm-click-label="user-tags-all">すべて</a></li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%20%E3%83%8D%E3%82%BF/" data-gtm-click-label="user-tags"> ネタ <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/.net/" data-gtm-click-label="user-tags"> .net <span class="count">(113)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/2ch/" data-gtm-click-label="user-tags"> 2ch <span class="count">(497)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/3D/" data-gtm-click-label="user-tags"> 3D <span class="count">(142)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/3DCG/" data-gtm-click-label="user-tags"> 3DCG <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/3D%E3%83%97%E3%83%AA%E3%83%B3%E3%82%BF/" data-gtm-click-label="user-tags"> 3Dプリンタ <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/API/" data-gtm-click-label="user-tags"> API <span class="count">(119)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/AR/" data-gtm-click-label="user-tags"> AR <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/AV/" data-gtm-click-label="user-tags"> AV <span class="count">(109)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Amazon/" data-gtm-click-label="user-tags"> Amazon <span class="count">(78)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Arduino/" data-gtm-click-label="user-tags"> Arduino <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/C++/" data-gtm-click-label="user-tags"> C++ <span class="count">(47)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/CI/" data-gtm-click-label="user-tags"> CI <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/COVID-19/" data-gtm-click-label="user-tags"> COVID-19 <span class="count">(284)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/CPU/" data-gtm-click-label="user-tags"> CPU <span class="count">(109)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Chrome/" data-gtm-click-label="user-tags"> Chrome <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/DIY/" data-gtm-click-label="user-tags"> DIY <span class="count">(30)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/DirectX/" data-gtm-click-label="user-tags"> DirectX <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Dropbox/" data-gtm-click-label="user-tags"> Dropbox <span class="count">(8)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/EU/" data-gtm-click-label="user-tags"> EU <span class="count">(216)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Excel/" data-gtm-click-label="user-tags"> Excel <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/FPGA/" data-gtm-click-label="user-tags"> FPGA <span class="count">(52)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Firefox/" data-gtm-click-label="user-tags"> Firefox <span class="count">(8)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Framework/" data-gtm-click-label="user-tags"> Framework <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/GPGPU/" data-gtm-click-label="user-tags"> GPGPU <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/GPU/" data-gtm-click-label="user-tags"> GPU <span class="count">(64)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/GitHub/" data-gtm-click-label="user-tags"> GitHub <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Google/" data-gtm-click-label="user-tags"> Google <span class="count">(164)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Google%20App%20Engine/" data-gtm-click-label="user-tags"> Google App Engine <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/GraphQL/" data-gtm-click-label="user-tags"> GraphQL <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/HMD/" data-gtm-click-label="user-tags"> HMD <span class="count">(58)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/HPC/" data-gtm-click-label="user-tags"> HPC <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/HTML/" data-gtm-click-label="user-tags"> HTML <span class="count">(42)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/HTML5/" data-gtm-click-label="user-tags"> HTML5 <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/IMF/" data-gtm-click-label="user-tags"> IMF <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/ISIS/" data-gtm-click-label="user-tags"> ISIS <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/IT/" data-gtm-click-label="user-tags"> IT <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/LL/" data-gtm-click-label="user-tags"> LL <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/LLM/" data-gtm-click-label="user-tags"> LLM <span class="count">(44)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/LLVM/" data-gtm-click-label="user-tags"> LLVM <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/MVC/" data-gtm-click-label="user-tags"> MVC <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/MVNO/" data-gtm-click-label="user-tags"> MVNO <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/NHK/" data-gtm-click-label="user-tags"> NHK <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/OSS/" data-gtm-click-label="user-tags"> OSS <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Oculus%20Rift/" data-gtm-click-label="user-tags"> Oculus Rift <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/OculusRift/" data-gtm-click-label="user-tags"> OculusRift <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/OpenCV/" data-gtm-click-label="user-tags"> OpenCV <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/P2P/" data-gtm-click-label="user-tags"> P2P <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/PC/" data-gtm-click-label="user-tags"> PC <span class="count">(185)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/PC%E3%83%91%E3%83%BC%E3%83%84/" data-gtm-click-label="user-tags"> PCパーツ <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/PC%E5%91%A8%E8%BE%BA%E6%A9%9F%E5%99%A8/" data-gtm-click-label="user-tags"> PC周辺機器 <span class="count">(104)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Raspberry%20Pi/" data-gtm-click-label="user-tags"> Raspberry Pi <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Ruby/" data-gtm-click-label="user-tags"> Ruby <span class="count">(124)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/SF/" data-gtm-click-label="user-tags"> SF <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/SRE/" data-gtm-click-label="user-tags"> SRE <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/TPP/" data-gtm-click-label="user-tags"> TPP <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/TV/" data-gtm-click-label="user-tags"> TV <span class="count">(124)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Tensorflow/" data-gtm-click-label="user-tags"> Tensorflow <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Togetter/" data-gtm-click-label="user-tags"> Togetter <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/TypeScript/" data-gtm-click-label="user-tags"> TypeScript <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/UI/" data-gtm-click-label="user-tags"> UI <span class="count">(62)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/UML/" data-gtm-click-label="user-tags"> UML <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/USB/" data-gtm-click-label="user-tags"> USB <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Unix/" data-gtm-click-label="user-tags"> Unix <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/VR/" data-gtm-click-label="user-tags"> VR <span class="count">(165)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Visual%20Studio/" data-gtm-click-label="user-tags"> Visual Studio <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/Vue.js/" data-gtm-click-label="user-tags"> Vue.js <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/WebAssembly/" data-gtm-click-label="user-tags"> WebAssembly <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/YouTube/" data-gtm-click-label="user-tags"> YouTube <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/android/" data-gtm-click-label="user-tags"> android <span class="count">(418)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/art/" data-gtm-click-label="user-tags"> art <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/aws/" data-gtm-click-label="user-tags"> aws <span class="count">(138)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/azure/" data-gtm-click-label="user-tags"> azure <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/bash/" data-gtm-click-label="user-tags"> bash <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/bitcoin/" data-gtm-click-label="user-tags"> bitcoin <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/bluetooth/" data-gtm-click-label="user-tags"> bluetooth <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/business/" data-gtm-click-label="user-tags"> business <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/c%23/" data-gtm-click-label="user-tags"> c# <span class="count">(51)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/css/" data-gtm-click-label="user-tags"> css <span class="count">(72)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/database/" data-gtm-click-label="user-tags"> database <span class="count">(316)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/deep%20learning/" data-gtm-click-label="user-tags"> deep learning <span class="count">(61)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/docker/" data-gtm-click-label="user-tags"> docker <span class="count">(82)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/driver/" data-gtm-click-label="user-tags"> driver <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/electron/" data-gtm-click-label="user-tags"> electron <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/filesystem/" data-gtm-click-label="user-tags"> filesystem <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/git/" data-gtm-click-label="user-tags"> git <span class="count">(64)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/go/" data-gtm-click-label="user-tags"> go <span class="count">(45)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/hardware/" data-gtm-click-label="user-tags"> hardware <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/http/" data-gtm-click-label="user-tags"> http <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/ingress/" data-gtm-click-label="user-tags"> ingress <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/ios/" data-gtm-click-label="user-tags"> ios <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/iot/" data-gtm-click-label="user-tags"> iot <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/iphone/" data-gtm-click-label="user-tags"> iphone <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/ipv6/" data-gtm-click-label="user-tags"> ipv6 <span class="count">(8)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/jQuery/" data-gtm-click-label="user-tags"> jQuery <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/java/" data-gtm-click-label="user-tags"> java <span class="count">(69)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/javascript/" data-gtm-click-label="user-tags"> javascript <span class="count">(291)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/kernel/" data-gtm-click-label="user-tags"> kernel <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/kinect/" data-gtm-click-label="user-tags"> kinect <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/kubernetes/" data-gtm-click-label="user-tags"> kubernetes <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/library/" data-gtm-click-label="user-tags"> library <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/linux/" data-gtm-click-label="user-tags"> linux <span class="count">(222)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/markdown/" data-gtm-click-label="user-tags"> markdown <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/microservice/" data-gtm-click-label="user-tags"> microservice <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/microsoft/" data-gtm-click-label="user-tags"> microsoft <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/music/" data-gtm-click-label="user-tags"> music <span class="count">(88)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/mysql/" class="is-current" data-gtm-click-label="user-tags"> mysql <span class="count">(85)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/network/" data-gtm-click-label="user-tags"> network <span class="count">(144)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/node.js/" data-gtm-click-label="user-tags"> node.js <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/os/" data-gtm-click-label="user-tags"> os <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/php/" data-gtm-click-label="user-tags"> php <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/programming/" data-gtm-click-label="user-tags"> programming <span class="count">(126)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/python/" data-gtm-click-label="user-tags"> python <span class="count">(99)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/rails/" data-gtm-click-label="user-tags"> rails <span class="count">(55)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/react/" data-gtm-click-label="user-tags"> react <span class="count">(172)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/redmine/" data-gtm-click-label="user-tags"> redmine <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/rust/" data-gtm-click-label="user-tags"> rust <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/rx/" data-gtm-click-label="user-tags"> rx <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/science/" data-gtm-click-label="user-tags"> science <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/security/" data-gtm-click-label="user-tags"> security <span class="count">(121)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/serverless/" data-gtm-click-label="user-tags"> serverless <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/shop/" data-gtm-click-label="user-tags"> shop <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/software/" data-gtm-click-label="user-tags"> software <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/sql/" data-gtm-click-label="user-tags"> sql <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/sqlserver/" data-gtm-click-label="user-tags"> sqlserver <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/tool/" data-gtm-click-label="user-tags"> tool <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/twitter/" data-gtm-click-label="user-tags"> twitter <span class="count">(37)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/unity/" data-gtm-click-label="user-tags"> unity <span class="count">(46)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/web/" data-gtm-click-label="user-tags"> web <span class="count">(182)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/web%E3%82%B5%E3%83%BC%E3%83%93%E3%82%B9/" data-gtm-click-label="user-tags"> webサービス <span class="count">(320)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/web%E3%83%87%E3%82%B6%E3%82%A4%E3%83%B3/" data-gtm-click-label="user-tags"> webデザイン <span class="count">(55)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/web%E6%BC%AB%E7%94%BB/" data-gtm-click-label="user-tags"> web漫画 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/windows/" data-gtm-click-label="user-tags"> windows <span class="count">(242)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/x86/" data-gtm-click-label="user-tags"> x86 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%82%E3%81%A8%E3%81%A7%E8%AA%AD%E3%82%80/" data-gtm-click-label="user-tags"> あとで読む <span class="count">(315)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%84%E3%81%98%E3%82%81/" data-gtm-click-label="user-tags"> いじめ <span class="count">(29)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%91%E3%81%97%E3%81%8B%E3%82%89%E3%82%93/" data-gtm-click-label="user-tags"> けしからん <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%93%E3%82%8C%E3%81%AF%E3%81%99%E3%81%94%E3%81%84/" data-gtm-click-label="user-tags"> これはすごい <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%93%E3%82%8C%E3%81%AF%E3%81%B2%E3%81%A9%E3%81%84/" data-gtm-click-label="user-tags"> これはひどい <span class="count">(74)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%AF%E3%81%A6%E3%81%AA/" data-gtm-click-label="user-tags"> はてな <span class="count">(40)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%AF%E3%81%A6%E3%83%96/" data-gtm-click-label="user-tags"> はてブ <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%81%BE%E3%81%A8%E3%82%81/" data-gtm-click-label="user-tags"> まとめ <span class="count">(66)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%8B%E3%83%A1/" data-gtm-click-label="user-tags"> アニメ <span class="count">(257)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%95%E3%83%AA%E3%82%AB/" data-gtm-click-label="user-tags"> アフリカ <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%97%E3%83%AA/" data-gtm-click-label="user-tags"> アプリ <span class="count">(50)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%A1%E3%83%AA%E3%82%AB/" data-gtm-click-label="user-tags"> アメリカ <span class="count">(241)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%AB%E3%82%B4%E3%83%AA%E3%82%BA%E3%83%A0/" data-gtm-click-label="user-tags"> アルゴリズム <span class="count">(64)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%BC%E3%82%AD%E3%83%86%E3%82%AF%E3%83%81%E3%83%A3/" data-gtm-click-label="user-tags"> アーキテクチャ <span class="count">(58)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A2%E3%83%BC%E3%83%88/" data-gtm-click-label="user-tags"> アート <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%82%AE%E3%83%AA%E3%82%B9/" data-gtm-click-label="user-tags"> イギリス <span class="count">(58)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%82%B9%E3%83%A9%E3%83%A0/" data-gtm-click-label="user-tags"> イスラム <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%82%BF%E3%83%AA%E3%82%A2/" data-gtm-click-label="user-tags"> イタリア <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%99%E3%83%B3%E3%83%88/" data-gtm-click-label="user-tags"> イベント <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%A9%E3%82%B9%E3%83%88/" data-gtm-click-label="user-tags"> イラスト <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%93%E3%83%A5%E3%83%BC/" data-gtm-click-label="user-tags"> インタビュー <span class="count">(91)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%BC%E3%83%8D%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> インターネット <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%B3%E3%83%89/" data-gtm-click-label="user-tags"> インド <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A4%E3%83%B3%E3%83%95%E3%83%A9/" data-gtm-click-label="user-tags"> インフラ <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A6%E3%82%AF%E3%83%A9%E3%82%A4%E3%83%8A/" data-gtm-click-label="user-tags"> ウクライナ <span class="count">(250)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A8%E3%83%87%E3%82%A3%E3%82%BF/" data-gtm-click-label="user-tags"> エディタ <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A8%E3%83%8D%E3%83%AB%E3%82%AE%E3%83%BC/" data-gtm-click-label="user-tags"> エネルギー <span class="count">(550)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2/" data-gtm-click-label="user-tags"> エンジニア <span class="count">(115)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%B3/" data-gtm-click-label="user-tags"> エンジン <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AA%E3%83%AA%E3%83%B3%E3%83%94%E3%83%83%E3%82%AF/" data-gtm-click-label="user-tags"> オリンピック <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AA%E3%83%BC%E3%82%B9%E3%83%88%E3%83%A9%E3%83%AA%E3%82%A2/" data-gtm-click-label="user-tags"> オーストラリア <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AA%E3%83%BC%E3%83%97%E3%83%B3%E3%82%BD%E3%83%BC%E3%82%B9/" data-gtm-click-label="user-tags"> オープンソース <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AB%E3%83%A1%E3%83%A9/" data-gtm-click-label="user-tags"> カメラ <span class="count">(56)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AB%E3%83%AB%E3%83%88/" data-gtm-click-label="user-tags"> カルト <span class="count">(184)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AC%E3%82%B8%E3%82%A7%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> ガジェット <span class="count">(77)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AE%E3%83%AA%E3%82%B7%E3%83%A3/" data-gtm-click-label="user-tags"> ギリシャ <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AF%E3%83%A9%E3%82%A6%E3%83%89/" data-gtm-click-label="user-tags"> クラウド <span class="count">(75)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%AF%E3%83%AC%E3%82%B8%E3%83%83%E3%83%88%E3%82%AB%E3%83%BC%E3%83%89/" data-gtm-click-label="user-tags"> クレジットカード <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B2%E3%83%BC%E3%83%A0/" data-gtm-click-label="user-tags"> ゲーム <span class="count">(653)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%82%B1%E3%83%BC%E3%82%B7%E3%83%A7%E3%83%B3/" data-gtm-click-label="user-tags"> コミュニケーション <span class="count">(106)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B3%E3%83%B3%E3%83%86%E3%83%8A/" data-gtm-click-label="user-tags"> コンテナ <span class="count">(57)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B3%E3%83%B3%E3%83%91%E3%82%A4%E3%83%A9/" data-gtm-click-label="user-tags"> コンパイラ <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B5%E3%83%83%E3%82%AB%E3%83%BC/" data-gtm-click-label="user-tags"> サッカー <span class="count">(98)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B5%E3%83%BC%E3%83%90%E3%83%BC/" data-gtm-click-label="user-tags"> サーバー <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B5%E3%83%BC%E3%83%93%E3%82%B9/" data-gtm-click-label="user-tags"> サービス <span class="count">(63)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B7%E3%82%B9%E3%83%86%E3%83%A0/" data-gtm-click-label="user-tags"> システム <span class="count">(204)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B7%E3%82%B9%E3%83%86%E3%83%A0%E9%96%8B%E7%99%BA/" data-gtm-click-label="user-tags"> システム開発 <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B7%E3%83%AA%E3%82%A2/" data-gtm-click-label="user-tags"> シリア <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B9%E3%82%A6%E3%82%A7%E3%83%BC%E3%83%87%E3%83%B3/" data-gtm-click-label="user-tags"> スウェーデン <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B9%E3%83%9D%E3%83%BC%E3%83%84/" data-gtm-click-label="user-tags"> スポーツ <span class="count">(152)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B9%E3%83%9E%E3%83%9B/" data-gtm-click-label="user-tags"> スマホ <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%B9%E3%83%9E%E3%83%BC%E3%83%88%E3%83%95%E3%82%A9%E3%83%B3/" data-gtm-click-label="user-tags"> スマートフォン <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%BB%E3%82%AD%E3%83%A5%E3%83%AA%E3%83%86%E3%82%A3/" data-gtm-click-label="user-tags"> セキュリティ <span class="count">(128)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%82%BD%E3%83%95%E3%83%88%E3%82%A6%E3%82%A7%E3%82%A2/" data-gtm-click-label="user-tags"> ソフトウェア <span class="count">(63)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%81%E3%83%99%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> チベット <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%84%E3%83%BC%E3%83%AB/" data-gtm-click-label="user-tags"> ツール <span class="count">(74)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%86%E3%82%B9%E3%83%88/" data-gtm-click-label="user-tags"> テスト <span class="count">(106)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%86%E3%83%AC%E3%83%93/" data-gtm-click-label="user-tags"> テレビ <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%86%E3%83%AD/" data-gtm-click-label="user-tags"> テロ <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%82%A3%E3%82%B9%E3%83%97%E3%83%AC%E3%82%A4/" data-gtm-click-label="user-tags"> ディスプレイ <span class="count">(40)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%82%B6%E3%82%A4%E3%83%B3/" data-gtm-click-label="user-tags"> デザイン <span class="count">(84)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%83%90%E3%82%A4%E3%82%B9/" data-gtm-click-label="user-tags"> デバイス <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF/" data-gtm-click-label="user-tags"> データ <span class="count">(125)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9/" data-gtm-click-label="user-tags"> データベース <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%87%E3%83%BC%E3%82%BF%E5%88%86%E6%9E%90/" data-gtm-click-label="user-tags"> データ分析 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%88%E3%83%A9%E3%83%96%E3%83%AB/" data-gtm-click-label="user-tags"> トラブル <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%88%E3%83%AB%E3%82%B3/" data-gtm-click-label="user-tags"> トルコ <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%88%E3%83%B3%E3%83%87%E3%83%A2/" data-gtm-click-label="user-tags"> トンデモ <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%89%E3%82%A4%E3%83%84/" data-gtm-click-label="user-tags"> ドイツ <span class="count">(139)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%89%E3%83%A9%E3%83%9E/" data-gtm-click-label="user-tags"> ドラマ <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8B%E3%82%B3%E3%83%8B%E3%82%B3%E5%8B%95%E7%94%BB/" data-gtm-click-label="user-tags"> ニコニコ動画 <span class="count">(157)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8B%E3%82%BB%E5%8C%BB%E7%99%82/" data-gtm-click-label="user-tags"> ニセ医療 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8B%E3%82%BB%E7%A7%91%E5%AD%A6/" data-gtm-click-label="user-tags"> ニセ科学 <span class="count">(52)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8B%E3%83%A5%E3%83%BC%E3%82%B9/" data-gtm-click-label="user-tags"> ニュース <span class="count">(21)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8D%E3%82%BF/" data-gtm-click-label="user-tags"> ネタ <span class="count">(890)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8D%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> ネット <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8D%E3%83%83%E3%83%88%E3%83%AF%E3%83%BC%E3%82%AF/" data-gtm-click-label="user-tags"> ネットワーク <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%8F%E3%83%BC%E3%83%89%E3%82%A6%E3%82%A7%E3%82%A2/" data-gtm-click-label="user-tags"> ハードウェア <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%90%E3%83%83%E3%83%86%E3%83%AA%E3%83%BC/" data-gtm-click-label="user-tags"> バッテリー <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-tags"> パフォーマンス <span class="count">(44)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%93%E3%82%B8%E3%83%8D%E3%82%B9/" data-gtm-click-label="user-tags"> ビジネス <span class="count">(496)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%82%A1%E3%83%83%E3%82%B7%E3%83%A7%E3%83%B3/" data-gtm-click-label="user-tags"> ファッション <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%82%A9%E3%83%B3%E3%83%88/" data-gtm-click-label="user-tags"> フォント <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%A9%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-tags"> フランス <span class="count">(55)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%AA%E3%83%BC%E3%82%BD%E3%83%95%E3%83%88/" data-gtm-click-label="user-tags"> フリーソフト <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%AA%E3%83%BC%E3%83%A9%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-tags"> フリーランス <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%AC%E3%83%BC%E3%83%A0%E3%83%AF%E3%83%BC%E3%82%AF/" data-gtm-click-label="user-tags"> フレームワーク <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%95%E3%83%AD%E3%83%B3%E3%83%88%E3%82%A8%E3%83%B3%E3%83%89/" data-gtm-click-label="user-tags"> フロントエンド <span class="count">(46)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%96%E3%83%A9%E3%82%A6%E3%82%B6/" data-gtm-click-label="user-tags"> ブラウザ <span class="count">(52)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%96%E3%83%A9%E3%83%83%E3%82%AF/" data-gtm-click-label="user-tags"> ブラック <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%96%E3%83%A9%E3%83%83%E3%82%AF%E4%BC%81%E6%A5%AD/" data-gtm-click-label="user-tags"> ブラック企業 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%96%E3%83%AD%E3%83%83%E3%82%AF%E3%83%81%E3%82%A7%E3%83%BC%E3%83%B3/" data-gtm-click-label="user-tags"> ブロックチェーン <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B0%E3%83%A9%E3%83%9F%E3%83%B3%E3%82%B0/" data-gtm-click-label="user-tags"> プログラミング <span class="count">(271)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B0%E3%83%A9%E3%83%9F%E3%83%B3%E3%82%B0%E8%A8%80%E8%AA%9E/" data-gtm-click-label="user-tags"> プログラミング言語 <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88/" data-gtm-click-label="user-tags"> プロジェクト <span class="count">(42)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%82%B8%E3%82%A7%E3%82%AF%E3%83%88%E7%AE%A1%E7%90%86/" data-gtm-click-label="user-tags"> プロジェクト管理 <span class="count">(42)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%97%E3%83%AD%E3%83%AC%E3%82%B9/" data-gtm-click-label="user-tags"> プロレス <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%99%E3%83%88%E3%83%8A%E3%83%A0/" data-gtm-click-label="user-tags"> ベトナム <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%99%E3%83%B3%E3%83%81%E3%83%A3%E3%83%BC/" data-gtm-click-label="user-tags"> ベンチャー <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9B%E3%83%A1%E3%82%AA%E3%83%91%E3%82%B7%E3%83%BC/" data-gtm-click-label="user-tags"> ホメオパシー <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9E%E3%82%A4%E3%83%8A%E3%83%B3%E3%83%90%E3%83%BC/" data-gtm-click-label="user-tags"> マイナンバー <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9E%E3%82%B9%E3%82%B3%E3%83%9F/" data-gtm-click-label="user-tags"> マスコミ <span class="count">(138)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9E%E3%83%8D%E3%82%B8%E3%83%A1%E3%83%B3%E3%83%88/" data-gtm-click-label="user-tags"> マネジメント <span class="count">(53)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%9E%E3%83%B3%E3%82%AC/" data-gtm-click-label="user-tags"> マンガ <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A1%E3%83%87%E3%82%A3%E3%82%A2/" data-gtm-click-label="user-tags"> メディア <span class="count">(130)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A1%E3%83%B3%E3%82%BF%E3%83%AB/" data-gtm-click-label="user-tags"> メンタル <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A1%E3%83%B3%E3%82%BF%E3%83%AB%E3%83%98%E3%83%AB%E3%82%B9/" data-gtm-click-label="user-tags"> メンタルヘルス <span class="count">(45)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A2%E3%83%90%E3%82%A4%E3%83%AB/" data-gtm-click-label="user-tags"> モバイル <span class="count">(56)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A9%E3%82%A4%E3%83%88%E3%83%8E%E3%83%99%E3%83%AB/" data-gtm-click-label="user-tags"> ライトノベル <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%A9%E3%82%A4%E3%83%96%E3%83%A9%E3%83%AA/" data-gtm-click-label="user-tags"> ライブラリ <span class="count">(54)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%AC%E3%82%B7%E3%83%94/" data-gtm-click-label="user-tags"> レシピ <span class="count">(262)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%AC%E3%83%93%E3%83%A5%E3%83%BC/" data-gtm-click-label="user-tags"> レビュー <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%AD%E3%82%B7%E3%82%A2/" data-gtm-click-label="user-tags"> ロシア <span class="count">(406)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E3%83%AD%E3%83%9C%E3%83%83%E3%83%88/" data-gtm-click-label="user-tags"> ロボット <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%B8%8D%E5%8B%95%E7%94%A3/" data-gtm-click-label="user-tags"> 不動産 <span class="count">(231)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%B8%AD%E5%9B%BD/" data-gtm-click-label="user-tags"> 中国 <span class="count">(748)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%B8%AD%E5%A4%AE%E9%8A%80%E8%A1%8C/" data-gtm-click-label="user-tags"> 中央銀行 <span class="count">(163)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%B8%AD%E6%9D%B1/" data-gtm-click-label="user-tags"> 中東 <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%8B%E4%BB%B6/" data-gtm-click-label="user-tags"> 事件 <span class="count">(561)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%8B%E6%95%85/" data-gtm-click-label="user-tags"> 事故 <span class="count">(146)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%8B%E6%A5%AD/" data-gtm-click-label="user-tags"> 事業 <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%A4%E9%80%9A/" data-gtm-click-label="user-tags"> 交通 <span class="count">(129)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E4%BA%8B/" data-gtm-click-label="user-tags"> 人事 <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E5%8F%A3/" data-gtm-click-label="user-tags"> 人口 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E5%B7%A5%E7%9F%A5%E8%83%BD/" data-gtm-click-label="user-tags"> 人工知能 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E6%9D%90/" data-gtm-click-label="user-tags"> 人材 <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E6%A8%A9/" data-gtm-click-label="user-tags"> 人権 <span class="count">(150)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E7%89%A9/" data-gtm-click-label="user-tags"> 人物 <span class="count">(79)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BA%BA%E7%94%9F/" data-gtm-click-label="user-tags"> 人生 <span class="count">(271)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BB%8B%E8%AD%B7/" data-gtm-click-label="user-tags"> 介護 <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BB%8F%E6%95%99/" data-gtm-click-label="user-tags"> 仏教 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BB%95%E4%BA%8B/" data-gtm-click-label="user-tags"> 仕事 <span class="count">(514)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BB%AE%E6%83%B3%E9%80%9A%E8%B2%A8/" data-gtm-click-label="user-tags"> 仮想通貨 <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BC%81%E6%A5%AD/" data-gtm-click-label="user-tags"> 企業 <span class="count">(252)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BC%9A%E7%A4%BE/" data-gtm-click-label="user-tags"> 会社 <span class="count">(78)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BC%9A%E8%A8%88/" data-gtm-click-label="user-tags"> 会計 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BD%8F%E5%AE%85/" data-gtm-click-label="user-tags"> 住宅 <span class="count">(96)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E4%BF%9D%E9%99%BA/" data-gtm-click-label="user-tags"> 保険 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%81%A5%E5%BA%B7/" data-gtm-click-label="user-tags"> 健康 <span class="count">(135)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%86%99%E7%9C%9F/" data-gtm-click-label="user-tags"> 写真 <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%87%BA%E7%89%88/" data-gtm-click-label="user-tags"> 出版 <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8A%B4%E5%83%8D/" data-gtm-click-label="user-tags"> 労働 <span class="count">(1064)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8A%B4%E5%83%8D%E7%B5%84%E5%90%88/" data-gtm-click-label="user-tags"> 労働組合 <span class="count">(39)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8B%95%E7%89%A9/" data-gtm-click-label="user-tags"> 動物 <span class="count">(83)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8B%95%E7%94%BB/" data-gtm-click-label="user-tags"> 動画 <span class="count">(64)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8C%96%E5%AD%A6/" data-gtm-click-label="user-tags"> 化学 <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8C%97%E6%9C%9D%E9%AE%AE/" data-gtm-click-label="user-tags"> 北朝鮮 <span class="count">(74)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8C%BB%E7%99%82/" data-gtm-click-label="user-tags"> 医療 <span class="count">(924)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8D%8A%E5%B0%8E%E4%BD%93/" data-gtm-click-label="user-tags"> 半導体 <span class="count">(112)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8E%9F%E5%AD%90%E5%8A%9B/" data-gtm-click-label="user-tags"> 原子力 <span class="count">(80)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8E%9F%E7%99%BA/" data-gtm-click-label="user-tags"> 原発 <span class="count">(552)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8F%B0%E6%B9%BE/" data-gtm-click-label="user-tags"> 台湾 <span class="count">(51)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%8F%B8%E6%B3%95/" data-gtm-click-label="user-tags"> 司法 <span class="count">(140)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%90%8C%E4%BA%BA/" data-gtm-click-label="user-tags"> 同人 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%95%86%E5%93%81/" data-gtm-click-label="user-tags"> 商品 <span class="count">(58)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%96%B6%E6%A5%AD/" data-gtm-click-label="user-tags"> 営業 <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9B%B3%E6%9B%B8%E9%A4%A8/" data-gtm-click-label="user-tags"> 図書館 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9B%BD%E5%82%B5/" data-gtm-click-label="user-tags"> 国債 <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9B%BD%E9%9A%9B/" data-gtm-click-label="user-tags"> 国際 <span class="count">(600)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E4%B8%AD%E7%86%B1/" data-gtm-click-label="user-tags"> 地中熱 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E5%9B%B3/" data-gtm-click-label="user-tags"> 地図 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E6%96%B9/" data-gtm-click-label="user-tags"> 地方 <span class="count">(147)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E7%86%B1/" data-gtm-click-label="user-tags"> 地熱 <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E7%86%B1%E7%99%BA%E9%9B%BB/" data-gtm-click-label="user-tags"> 地熱発電 <span class="count">(104)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E7%90%86/" data-gtm-click-label="user-tags"> 地理 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%9C%B0%E9%9C%87/" data-gtm-click-label="user-tags"> 地震 <span class="count">(40)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A0%B1%E9%81%93/" data-gtm-click-label="user-tags"> 報道 <span class="count">(61)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A2%97%E7%94%B0/" data-gtm-click-label="user-tags"> 増田 <span class="count">(550)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A4%96%E4%BA%A4/" data-gtm-click-label="user-tags"> 外交 <span class="count">(266)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A4%A7%E5%AD%A6/" data-gtm-click-label="user-tags"> 大学 <span class="count">(145)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A4%A7%E9%98%AA/" data-gtm-click-label="user-tags"> 大阪 <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A4%AA%E9%99%BD%E5%85%89%E7%99%BA%E9%9B%BB/" data-gtm-click-label="user-tags"> 太陽光発電 <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%A5%91%E7%B4%84/" data-gtm-click-label="user-tags"> 契約 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AD%90%E3%81%A9%E3%82%82/" data-gtm-click-label="user-tags"> 子ども <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AD%90%E4%BE%9B/" data-gtm-click-label="user-tags"> 子供 <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AD%90%E8%82%B2%E3%81%A6/" data-gtm-click-label="user-tags"> 子育て <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AD%A6%E7%BF%92/" data-gtm-click-label="user-tags"> 学習 <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%87%E5%AE%99/" data-gtm-click-label="user-tags"> 宇宙 <span class="count">(68)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%87%E5%AE%99%E9%96%8B%E7%99%BA/" data-gtm-click-label="user-tags"> 宇宙開発 <span class="count">(29)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%89%E5%85%A8%E4%BF%9D%E9%9A%9C/" data-gtm-click-label="user-tags"> 安全保障 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%97%E6%95%99/" data-gtm-click-label="user-tags"> 宗教 <span class="count">(197)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%9F%E9%A8%93/" data-gtm-click-label="user-tags"> 実験 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%B6%E5%BA%AD/" data-gtm-click-label="user-tags"> 家庭 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%B6%E6%97%8F/" data-gtm-click-label="user-tags"> 家族 <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%AE%B6%E9%9B%BB/" data-gtm-click-label="user-tags"> 家電 <span class="count">(126)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B0%86%E6%A3%8B/" data-gtm-click-label="user-tags"> 将棋 <span class="count">(37)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B0%8F%E8%AA%AC/" data-gtm-click-label="user-tags"> 小説 <span class="count">(54)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B0%91%E5%AD%90%E5%8C%96/" data-gtm-click-label="user-tags"> 少子化 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B1%B1%E5%BD%A2/" data-gtm-click-label="user-tags"> 山形 <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B7%AE%E5%88%A5/" data-gtm-click-label="user-tags"> 差別 <span class="count">(134)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%B9%B4%E9%87%91/" data-gtm-click-label="user-tags"> 年金 <span class="count">(67)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BA%83%E5%91%8A/" data-gtm-click-label="user-tags"> 広告 <span class="count">(37)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BB%BA%E7%AF%89/" data-gtm-click-label="user-tags"> 建築 <span class="count">(102)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BB%BA%E8%A8%AD/" data-gtm-click-label="user-tags"> 建設 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BE%8C%E3%81%A7/" data-gtm-click-label="user-tags"> 後で <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BE%93%E8%BB%8D%E6%85%B0%E5%AE%89%E5%A9%A6/" data-gtm-click-label="user-tags"> 従軍慰安婦 <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E5%BF%83%E7%90%86/" data-gtm-click-label="user-tags"> 心理 <span class="count">(109)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%80%9D%E6%83%B3/" data-gtm-click-label="user-tags"> 思想 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%80%A7/" data-gtm-click-label="user-tags"> 性 <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%83%85%E5%A0%B1/" data-gtm-click-label="user-tags"> 情報 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%85%B0%E5%AE%89%E5%A9%A6%E5%95%8F%E9%A1%8C/" data-gtm-click-label="user-tags"> 慰安婦問題 <span class="count">(57)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%86%B2%E6%B3%95/" data-gtm-click-label="user-tags"> 憲法 <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%88%A6%E4%BA%89/" data-gtm-click-label="user-tags"> 戦争 <span class="count">(252)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%8A%80%E8%A1%93/" data-gtm-click-label="user-tags"> 技術 <span class="count">(223)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%8A%95%E8%B3%87/" data-gtm-click-label="user-tags"> 投資 <span class="count">(168)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%8E%A1%E7%94%A8/" data-gtm-click-label="user-tags"> 採用 <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%8F%89%E3%82%81%E4%BA%8B/" data-gtm-click-label="user-tags"> 揉め事 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%90%BA%E5%B8%AF/" data-gtm-click-label="user-tags"> 携帯 <span class="count">(89)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BE%E5%B0%84%E8%83%BD/" data-gtm-click-label="user-tags"> 放射能 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BE%E9%80%81/" data-gtm-click-label="user-tags"> 放送 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BF%E5%BA%9C/" data-gtm-click-label="user-tags"> 政府 <span class="count">(39)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BF%E6%B2%BB/" data-gtm-click-label="user-tags"> 政治 <span class="count">(2269)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%94%BF%E7%AD%96/" data-gtm-click-label="user-tags"> 政策 <span class="count">(65)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%95%99%E8%82%B2/" data-gtm-click-label="user-tags"> 教育 <span class="count">(498)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%95%B0%E5%AD%A6/" data-gtm-click-label="user-tags"> 数学 <span class="count">(116)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%87%E5%8C%96/" data-gtm-click-label="user-tags"> 文化 <span class="count">(168)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%87%E5%AD%A6/" data-gtm-click-label="user-tags"> 文学 <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%87%E6%88%BF%E5%85%B7/" data-gtm-click-label="user-tags"> 文房具 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%87%E7%AB%A0/" data-gtm-click-label="user-tags"> 文章 <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%96%99%E7%90%86/" data-gtm-click-label="user-tags"> 料理 <span class="count">(219)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%97%85/" data-gtm-click-label="user-tags"> 旅 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%97%85%E8%A1%8C/" data-gtm-click-label="user-tags"> 旅行 <span class="count">(86)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%97%A5%E6%9C%AC/" data-gtm-click-label="user-tags"> 日本 <span class="count">(204)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%97%A5%E9%8A%80/" data-gtm-click-label="user-tags"> 日銀 <span class="count">(324)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%98%A0%E5%83%8F/" data-gtm-click-label="user-tags"> 映像 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%98%A0%E7%94%BB/" data-gtm-click-label="user-tags"> 映画 <span class="count">(250)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9B%B8%E7%B1%8D/" data-gtm-click-label="user-tags"> 書籍 <span class="count">(103)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9B%B8%E8%A9%95/" data-gtm-click-label="user-tags"> 書評 <span class="count">(122)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9C%80%E9%81%A9%E5%8C%96/" data-gtm-click-label="user-tags"> 最適化 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9C%AC/" data-gtm-click-label="user-tags"> 本 <span class="count">(62)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9D%B1%E6%97%A5%E6%9C%AC%E5%A4%A7%E9%9C%87%E7%81%BD/" data-gtm-click-label="user-tags"> 東日本大震災 <span class="count">(44)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9D%B1%E9%9B%BB/" data-gtm-click-label="user-tags"> 東電 <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%9E%97%E6%A5%AD/" data-gtm-click-label="user-tags"> 林業 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%A0%BC%E5%B7%AE/" data-gtm-click-label="user-tags"> 格差 <span class="count">(29)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%A8%AA%E6%B5%9C/" data-gtm-click-label="user-tags"> 横浜 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%A9%9F%E6%A2%B0%E5%AD%A6%E7%BF%92/" data-gtm-click-label="user-tags"> 機械学習 <span class="count">(309)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AC%A7%E5%B7%9E/" data-gtm-click-label="user-tags"> 欧州 <span class="count">(69)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AD%A3%E8%A6%8F%E8%A1%A8%E7%8F%BE/" data-gtm-click-label="user-tags"> 正規表現 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AD%AF%E7%A7%91/" data-gtm-click-label="user-tags"> 歯科 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AD%B4%E5%8F%B2/" data-gtm-click-label="user-tags"> 歴史 <span class="count">(524)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%AD%B4%E5%8F%B2%E4%BF%AE%E6%AD%A3%E4%B8%BB%E7%BE%A9/" data-gtm-click-label="user-tags"> 歴史修正主義 <span class="count">(9)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B0%97%E8%B1%A1/" data-gtm-click-label="user-tags"> 気象 <span class="count">(11)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B1%BA%E6%B8%88/" data-gtm-click-label="user-tags"> 決済 <span class="count">(100)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B2%96%E7%B8%84/" data-gtm-click-label="user-tags"> 沖縄 <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B3%95%E5%BE%8B/" data-gtm-click-label="user-tags"> 法律 <span class="count">(76)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B5%B7%E5%A4%96/" data-gtm-click-label="user-tags"> 海外 <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B5%B7%E5%A4%96%E3%81%AE%E5%8F%8D%E5%BF%9C/" data-gtm-click-label="user-tags"> 海外の反応 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%B7%B1%E5%B1%A4%E5%AD%A6%E7%BF%92/" data-gtm-click-label="user-tags"> 深層学習 <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%BC%81%E6%A5%AD/" data-gtm-click-label="user-tags"> 漁業 <span class="count">(69)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E6%BC%AB%E7%94%BB/" data-gtm-click-label="user-tags"> 漫画 <span class="count">(351)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%81%BD%E5%AE%B3/" data-gtm-click-label="user-tags"> 災害 <span class="count">(96)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%82%8E%E4%B8%8A/" data-gtm-click-label="user-tags"> 炎上 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%82%BA%E6%9B%BF/" data-gtm-click-label="user-tags"> 為替 <span class="count">(92)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%84%A1%E7%B7%9A/" data-gtm-click-label="user-tags"> 無線 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%89%A9%E6%B5%81/" data-gtm-click-label="user-tags"> 物流 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%89%A9%E7%90%86/" data-gtm-click-label="user-tags"> 物理 <span class="count">(25)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%89%B9%E8%A8%B1/" data-gtm-click-label="user-tags"> 特許 <span class="count">(23)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%8A%AF%E7%BD%AA/" data-gtm-click-label="user-tags"> 犯罪 <span class="count">(143)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%8C%AB/" data-gtm-click-label="user-tags"> 猫 <span class="count">(21)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%92%B0%E5%A2%83/" data-gtm-click-label="user-tags"> 環境 <span class="count">(170)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%9F%E6%B4%BB/" data-gtm-click-label="user-tags"> 生活 <span class="count">(213)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%9F%E7%89%A9/" data-gtm-click-label="user-tags"> 生物 <span class="count">(63)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%9F%E7%94%A3%E6%80%A7/" data-gtm-click-label="user-tags"> 生産性 <span class="count">(21)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%A3%E6%A5%AD/" data-gtm-click-label="user-tags"> 産業 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%BB%E5%83%8F/" data-gtm-click-label="user-tags"> 画像 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%94%BB%E5%83%8F%E5%87%A6%E7%90%86/" data-gtm-click-label="user-tags"> 画像処理 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%9A%87%E5%AE%A4/" data-gtm-click-label="user-tags"> 皇室 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%9B%A3%E8%A6%96/" data-gtm-click-label="user-tags"> 監視 <span class="count">(49)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A0%94%E7%A9%B6/" data-gtm-click-label="user-tags"> 研究 <span class="count">(402)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A4%BE%E4%BC%9A/" data-gtm-click-label="user-tags"> 社会 <span class="count">(1921)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A4%BE%E4%BC%9A%E4%BF%9D%E9%9A%9C/" data-gtm-click-label="user-tags"> 社会保障 <span class="count">(48)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A6%8F%E7%A5%89/" data-gtm-click-label="user-tags"> 福祉 <span class="count">(100)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A7%91%E5%AD%A6/" data-gtm-click-label="user-tags"> 科学 <span class="count">(212)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A8%8E/" data-gtm-click-label="user-tags"> 税 <span class="count">(117)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A8%8E%E5%88%B6/" data-gtm-click-label="user-tags"> 税制 <span class="count">(194)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%A8%8E%E9%87%91/" data-gtm-click-label="user-tags"> 税金 <span class="count">(35)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%AE%A1%E7%90%86/" data-gtm-click-label="user-tags"> 管理 <span class="count">(27)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B1%B3%E5%9B%BD/" data-gtm-click-label="user-tags"> 米国 <span class="count">(214)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B2%BE%E7%A5%9E/" data-gtm-click-label="user-tags"> 精神 <span class="count">(59)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B4%A0%E6%9D%90/" data-gtm-click-label="user-tags"> 素材 <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%84%E3%81%BF%E8%BE%BC%E3%81%BF/" data-gtm-click-label="user-tags"> 組み込み <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%84%E7%B9%94/" data-gtm-click-label="user-tags"> 組織 <span class="count">(46)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%8C%E5%96%B6/" data-gtm-click-label="user-tags"> 経営 <span class="count">(91)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%8C%E6%B8%88/" data-gtm-click-label="user-tags"> 経済 <span class="count">(1993)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%8C%E6%B8%88%E5%AD%A6/" data-gtm-click-label="user-tags"> 経済学 <span class="count">(364)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%B1%E8%A8%88/" data-gtm-click-label="user-tags"> 統計 <span class="count">(131)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E7%B5%B1%E8%A8%88%E5%AD%A6/" data-gtm-click-label="user-tags"> 統計学 <span class="count">(20)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%82%B2%E5%85%90/" data-gtm-click-label="user-tags"> 育児 <span class="count">(75)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%84%B3/" data-gtm-click-label="user-tags"> 脳 <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E5%8B%95%E8%BB%8A/" data-gtm-click-label="user-tags"> 自動車 <span class="count">(213)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E5%8B%95%E9%81%8B%E8%BB%A2/" data-gtm-click-label="user-tags"> 自動運転 <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E6%B2%BB%E4%BD%93/" data-gtm-click-label="user-tags"> 自治体 <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E7%84%B6%E8%A8%80%E8%AA%9E%E5%87%A6%E7%90%86/" data-gtm-click-label="user-tags"> 自然言語処理 <span class="count">(44)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%87%AA%E8%A1%9B%E9%9A%8A/" data-gtm-click-label="user-tags"> 自衛隊 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%88%AA%E7%A9%BA/" data-gtm-click-label="user-tags"> 航空 <span class="count">(39)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%88%B9/" data-gtm-click-label="user-tags"> 船 <span class="count">(14)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%8A%B8%E8%83%BD/" data-gtm-click-label="user-tags"> 芸能 <span class="count">(211)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%8A%B8%E8%A1%93/" data-gtm-click-label="user-tags"> 芸術 <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%8B%B1%E5%9B%BD/" data-gtm-click-label="user-tags"> 英国 <span class="count">(46)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%8B%B1%E8%AA%9E/" data-gtm-click-label="user-tags"> 英語 <span class="count">(73)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%91%97%E4%BD%9C%E6%A8%A9/" data-gtm-click-label="user-tags"> 著作権 <span class="count">(68)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%99%90%E6%AE%BA/" data-gtm-click-label="user-tags"> 虐殺 <span class="count">(26)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A1%8C%E6%94%BF/" data-gtm-click-label="user-tags"> 行政 <span class="count">(838)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A1%A8%E7%8F%BE/" data-gtm-click-label="user-tags"> 表現 <span class="count">(28)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A3%81%E5%88%A4/" data-gtm-click-label="user-tags"> 裁判 <span class="count">(73)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A3%BD%E5%93%81/" data-gtm-click-label="user-tags"> 製品 <span class="count">(12)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A3%BD%E9%80%A0/" data-gtm-click-label="user-tags"> 製造 <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A6%8F%E5%88%B6/" data-gtm-click-label="user-tags"> 規制 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A6%8F%E6%A0%BC/" data-gtm-click-label="user-tags"> 規格 <span class="count">(13)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A6%B3%E5%85%89/" data-gtm-click-label="user-tags"> 観光 <span class="count">(33)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A8%80%E8%91%89/" data-gtm-click-label="user-tags"> 言葉 <span class="count">(16)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A8%80%E8%AA%9E/" data-gtm-click-label="user-tags"> 言語 <span class="count">(60)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A8%AD%E8%A8%88/" data-gtm-click-label="user-tags"> 設計 <span class="count">(200)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%A8%B4%E8%A8%9F/" data-gtm-click-label="user-tags"> 訴訟 <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AA%8D%E8%A8%BC/" data-gtm-click-label="user-tags"> 認証 <span class="count">(96)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AA%AD%E3%81%BF%E7%89%A9/" data-gtm-click-label="user-tags"> 読み物 <span class="count">(36)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AA%BF%E6%9F%BB/" data-gtm-click-label="user-tags"> 調査 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AB%96%E6%96%87/" data-gtm-click-label="user-tags"> 論文 <span class="count">(43)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AB%9C%E5%A0%B1/" data-gtm-click-label="user-tags"> 諜報 <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AD%A6%E5%AF%9F/" data-gtm-click-label="user-tags"> 警察 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%AD%B0%E8%AB%96/" data-gtm-click-label="user-tags"> 議論 <span class="count">(50)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B2%A1%E6%94%BF/" data-gtm-click-label="user-tags"> 財政 <span class="count">(99)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B2%A7%E5%9B%B0/" data-gtm-click-label="user-tags"> 貧困 <span class="count">(66)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B2%BF%E6%98%93/" data-gtm-click-label="user-tags"> 貿易 <span class="count">(93)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B3%87%E6%96%99/" data-gtm-click-label="user-tags"> 資料 <span class="count">(34)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%B3%87%E6%BA%90/" data-gtm-click-label="user-tags"> 資源 <span class="count">(24)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%BB%8A/" data-gtm-click-label="user-tags"> 車 <span class="count">(85)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%BB%8D%E4%BA%8B/" data-gtm-click-label="user-tags"> 軍事 <span class="count">(502)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E8%BE%B2%E6%A5%AD/" data-gtm-click-label="user-tags"> 農業 <span class="count">(195)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%80%9A%E4%BF%A1/" data-gtm-click-label="user-tags"> 通信 <span class="count">(97)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%80%9A%E8%B2%A8/" data-gtm-click-label="user-tags"> 通貨 <span class="count">(32)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%81%8B%E7%94%A8/" data-gtm-click-label="user-tags"> 運用 <span class="count">(93)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%81%93%E5%85%B7/" data-gtm-click-label="user-tags"> 道具 <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%81%B8%E6%8C%99/" data-gtm-click-label="user-tags"> 選挙 <span class="count">(172)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%83%B5%E6%94%BF/" data-gtm-click-label="user-tags"> 郵政 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%83%BD%E5%B8%82/" data-gtm-click-label="user-tags"> 都市 <span class="count">(56)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%85%92/" data-gtm-click-label="user-tags"> 酒 <span class="count">(77)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%87%8E%E7%90%83/" data-gtm-click-label="user-tags"> 野球 <span class="count">(38)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%87%91%E8%9E%8D/" data-gtm-click-label="user-tags"> 金融 <span class="count">(558)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%87%91%E8%9E%8D%E6%94%BF%E7%AD%96/" data-gtm-click-label="user-tags"> 金融政策 <span class="count">(184)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%89%84%E9%81%93/" data-gtm-click-label="user-tags"> 鉄道 <span class="count">(63)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%8A%80%E8%A1%8C/" data-gtm-click-label="user-tags"> 銀行 <span class="count">(74)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%96%8B%E7%99%BA/" data-gtm-click-label="user-tags"> 開発 <span class="count">(491)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9A%9C%E5%AE%B3/" data-gtm-click-label="user-tags"> 障害 <span class="count">(100)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%87%E7%94%A8/" data-gtm-click-label="user-tags"> 雇用 <span class="count">(106)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%A3%E6%B0%91/" data-gtm-click-label="user-tags"> 難民 <span class="count">(18)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%8A%9B/" data-gtm-click-label="user-tags"> 電力 <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%8A%9B%E4%BC%9A%E7%A4%BE/" data-gtm-click-label="user-tags"> 電力会社 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%AD%90/" data-gtm-click-label="user-tags"> 電子 <span class="count">(17)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%AD%90%E5%B7%A5%E4%BD%9C/" data-gtm-click-label="user-tags"> 電子工作 <span class="count">(31)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E5%AD%90%E6%9B%B8%E7%B1%8D/" data-gtm-click-label="user-tags"> 電子書籍 <span class="count">(22)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E6%B0%97/" data-gtm-click-label="user-tags"> 電気 <span class="count">(10)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9B%BB%E8%A9%B1/" data-gtm-click-label="user-tags"> 電話 <span class="count">(15)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9F%93%E5%9B%BD/" data-gtm-click-label="user-tags"> 韓国 <span class="count">(186)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%9F%B3%E6%A5%BD/" data-gtm-click-label="user-tags"> 音楽 <span class="count">(173)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%A0%98%E5%9C%9F/" data-gtm-click-label="user-tags"> 領土 <span class="count">(70)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%A3%9F/" data-gtm-click-label="user-tags"> 食 <span class="count">(625)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%A3%9F%E5%93%81/" data-gtm-click-label="user-tags"> 食品 <span class="count">(19)</span> </a> </li> <li class="js-frequent-tag is-hidden"> <a href="/R2M/%E9%A6%99%E6%B8%AF/" data-gtm-click-label="user-tags"> 香港 <span class="count">(18)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E6%94%BF%E6%B2%BB/" data-gtm-click-label="user-tags"> 政治 <span class="count">(2269)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E7%B5%8C%E6%B8%88/" data-gtm-click-label="user-tags"> 経済 <span class="count">(1993)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E7%A4%BE%E4%BC%9A/" data-gtm-click-label="user-tags"> 社会 <span class="count">(1921)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E5%8A%B4%E5%83%8D/" data-gtm-click-label="user-tags"> 労働 <span class="count">(1064)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E5%8C%BB%E7%99%82/" data-gtm-click-label="user-tags"> 医療 <span class="count">(924)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E3%83%8D%E3%82%BF/" data-gtm-click-label="user-tags"> ネタ <span class="count">(890)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E8%A1%8C%E6%94%BF/" data-gtm-click-label="user-tags"> 行政 <span class="count">(838)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E4%B8%AD%E5%9B%BD/" data-gtm-click-label="user-tags"> 中国 <span class="count">(748)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E3%82%B2%E3%83%BC%E3%83%A0/" data-gtm-click-label="user-tags"> ゲーム <span class="count">(653)</span> </a> </li> <li class="js-most-frequent-tag"> <a href="/R2M/%E9%A3%9F/" data-gtm-click-label="user-tags"> 食 <span class="count">(625)</span> </a> </li> </ul> <p class="centerarticle-sub-navi-more"> <button type="button" class="js-display-all-tags" data-gtm-click-label="user-tags-show-all">タグをすべて表示</button> </p> </div> <div class="centerarticle-sidebar-menu"> <h3 class="centerarticle-aside-title">関連タグで絞り込む (16)</h3> <ul class="centerarticle-sub-navi"> <li> <a href="/R2M/mysql/aws/" > aws </a> </li> <li> <a href="/R2M/mysql/bash/" > bash </a> </li> <li> <a href="/R2M/mysql/database/" > database </a> </li> <li> <a href="/R2M/mysql/GitHub/" > GitHub </a> </li> <li> <a href="/R2M/mysql/go/" > go </a> </li> <li> <a href="/R2M/mysql/JSON/" > JSON </a> </li> <li> <a href="/R2M/mysql/mariadb/" > mariadb </a> </li> <li> <a href="/R2M/mysql/MySQL/" > MySQL </a> </li> <li> <a href="/R2M/mysql/php/" > php </a> </li> <li> <a href="/R2M/mysql/postgresql/" > postgresql </a> </li> <li> <a href="/R2M/mysql/python/" > python </a> </li> <li> <a href="/R2M/mysql/Unicode/" > Unicode </a> </li> <li> <a href="/R2M/mysql/%E3%83%84%E3%83%BC%E3%83%AB/" > ツール </a> </li> <li> <a href="/R2M/mysql/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" > パフォーマンス </a> </li> <li> <a href="/R2M/mysql/%E6%9C%80%E9%81%A9%E5%8C%96/" > 最適化 </a> </li> <li> <a href="/R2M/mysql/%E9%81%8B%E7%94%A8/" > 運用 </a> </li> </ul> <p class="centerarticle-sub-navi-more"> <a href="/R2M/bookmark">タグの絞り込みを解除</a> </p> </div> </div> <div class="center-container"> <div class="centerarticle-title-container"> <h2 class="centerarticle-title"> mysqlに関するR2Mのブックマーク (87) </h2> </div> <div class="js-user-bookmark-item-autoload-container" data-next-page-path="/R2M/mysql/?page=2" data-next-xhr-path="/api/users/R2M/bookmarks?tag=mysql&page=2" data-next-label="次のページ" > <script type="text/x-template" id="template-short-url-click"> {{#tweet_url}} <a href="{{tweet_url}}" target="_blank" rel="noopener noreferrer" data-gtm-click-label="reaction-twitter-clicks"><span>{{count}} clicks</span></a> {{/tweet_url}} {{^tweet_url}} <span>{{count}} clicks</span> {{/tweet_url}} </script> <script type="text/x-template" id="template-bookmark-item"> {{^is_wiped}} <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="{{url}}"> <div class="centerarticle-entry {{#has_image}}is-image-entry-unit{{/has_image}}"> <h3 class="centerarticle-entry-title"> <a href="{{url}}" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener{{#noreferrer}} noreferrer{{/noreferrer}}" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="{{favicon_url}}" alt="">{{title}}</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="{{page_url}}" class="js-keyboard-entry-page-openable" title="{{title}} ({{total_bookmarks}}ブックマーク)" data-gtm-click-label="user-bookmark-users">{{total_bookmarks_with_user_postfix}}</a> </span> </li> <li> <a href="/R2M/{{url_query}}" title="『{{root_title}}』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> {{root_title}} </a> </li> {{#is_categorized}} <li><a href="{{category_path}}" data-gtm-click-label="user-bookmark-category">{{category_title}}</a></li> {{/is_categorized}} </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">{{{summary_with_keyword_links}}}</p> {{#has_image}} <a href="{{canonical_url}}" class="centerarticle-entry-image" target="_blank" rel="noopener{{#noreferrer}} noreferrer{{/noreferrer}}" data-gtm-click-label="user-bookmark-thumb"> <img src="{{image_url}}" alt="{{title}}"> </a> {{/has_image}} </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-{{location_id}}"> <div class="centerarticle-reaction-comment js-user-bookmark-comment {{badge_icon}}" data-url="{{url}}" data-user-name="{{author_name}}"> <a href="{{top_page_path}}" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="{{profile_icon_url}}" alt="{{author_name}}" title="{{author_name}}" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="{{anchor_url}}" class="js-anchor-path" data-gtm-click-label="user-reaction-username">{{author_name}}</a></span> <span class="centerarticle-reaction-timestamp">{{created}}</span> <span class="js-private-icon status {{#is_public}}is-hidden{{/is_public}}"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment">{{{comment_expanded}}}</span> <ul class="centerarticle-reaction-tags js-tag-text"> {{#tags}} <li><a href="/{{author_name}}/{{escaped_label}}/" data-gtm-click-label="user-reaction-tag">{{label}}</a></li> {{/tags}} </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="{{#is_bookmark}}comment-permalink{{/is_bookmark}}{{^is_bookmark}}original-permalink{{/is_bookmark}} js-comment-permalink"> <a href="{{comment_page_path}}" data-gtm-click-label="user-reaction-permalink" rel="{{#should_nofollow}}nofollow{{/should_nofollow}}">{{#is_bookmark}}リスト{{/is_bookmark}}{{^is_bookmark}}リンク{{/is_bookmark}}</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> {{#following_bookmarks}} <li> <a href="{{anchor_url}}" class="following-bookmark-link" data-gtm-click-label="user-bookmark-following-bookmarker-icon"> <img src="{{profile_icon_url}}" alt="{{author_name}}" class="following-bookmark-icon" > </a> <span class="following-bookmark-popup"> <span class="following-bookmark-username">{{author_name}}</span><span class="following-bookmark-timestamp">{{created}}</span> <span class="following-bookmark-text"> {{ #comment }}<span class="following-bookmark-comment">{{ comment }}</span>{{ /comment }} <ul class="following-bookmark-tags"> {{ #tags }}<li>{{ label }}</li>{{ /tags }} </ul> </span> </span> </li> {{/following_bookmarks}} {{#following_bookmarks.length}} <li class="centerarticle-reaction-following-more"><button type="button" class="js-show-all-following-bookmarks" data-gtm-click-label="user-bookmark-showall-following-bookmarks">すべて表示</button></li> {{/following_bookmarks.length}} </ul> <div class="js-user-following-bookmarks-detail is-hidden"> {{#following_bookmarks}} <div class="centerarticle-reaction-comment js-user-bookmark-comment {{badge_icon}}" data-url="{{url}}" data-user-name="{{author_name}}"> <a href="{{top_page_path}}" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="{{profile_icon_url}}" alt="{{author_name}}" title="{{author_name}}" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="{{anchor_url}}" class="js-anchor-path" data-gtm-click-label="user-reaction-username">{{author_name}}</a></span> <span class="centerarticle-reaction-timestamp">{{created}}</span> <span class="js-private-icon status {{#is_public}}is-hidden{{/is_public}}"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment">{{{comment_expanded}}}</span> <ul class="centerarticle-reaction-tags js-tag-text"> {{#tags}} <li><a href="/{{author_name}}/{{escaped_label}}/" data-gtm-click-label="user-reaction-tag">{{label}}</a></li> {{/tags}} </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="{{#is_bookmark}}comment-permalink{{/is_bookmark}}{{^is_bookmark}}original-permalink{{/is_bookmark}} js-comment-permalink"> <a href="{{comment_page_path}}" data-gtm-click-label="user-reaction-permalink" rel="{{#should_nofollow}}nofollow{{/should_nofollow}}">{{#is_bookmark}}リスト{{/is_bookmark}}{{^is_bookmark}}リンク{{/is_bookmark}}</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> {{/following_bookmarks}} </div> </li> {{/is_wiped}} </script> <script type="text/x-template" id="template-following-bookmarker-icon"> <li> <a href="{{anchor_url}}" class="following-bookmark-link" data-gtm-click-label="user-bookmark-following-bookmarker-icon"> <img src="{{profile_icon_url}}" alt="{{author_name}}" class="following-bookmark-icon" > </a> <span class="following-bookmark-popup"> <span class="following-bookmark-username">{{author_name}}</span><span class="following-bookmark-timestamp">{{created}}</span> <span class="following-bookmark-text"> {{ #comment }}<span class="following-bookmark-comment">{{ comment }}</span>{{ /comment }} <ul class="following-bookmark-tags"> {{ #tags }}<li>{{ label }}</li>{{ /tags }} </ul> </span> </span> </li> </script> <script type="text/x-template" id="template-bookmark-item-editor"> <div class="centerarticle-entry {{#has_image}}is-image-entry-unit{{/has_image}}"> <h3 class="centerarticle-entry-title"> <a href="{{url}}" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener{{#noreferrer}} noreferrer{{/noreferrer}}" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="{{favicon_url}}" alt="">{{title}}</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="{{page_url}}" class="js-keyboard-entry-page-openable" title="{{title}} ({{total_bookmarks}}ブックマーク)" data-gtm-click-label="user-bookmark-users">{{total_bookmarks_with_user_postfix}}</a> </span> </li> <li> <a href="/R2M/{{url_query}}" title="『{{root_title}}』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> {{root_title}} </a> </li> {{#is_categorized}} <li><a href="{{category_path}}" data-gtm-click-label="user-bookmark-category">{{category_title}}</a></li> {{/is_categorized}} </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">{{{summary_with_keyword_links}}}</p> {{#has_image}} <a href="{{canonical_url}}" class="centerarticle-entry-image" target="_blank" rel="noopener{{#noreferrer}} noreferrer{{/noreferrer}}" data-gtm-click-label="user-bookmark-thumb"> <img src="{{image_url}}" alt="{{title}}"> </a> {{/has_image}} </div> </div> </script> <script type="text/x-template" id="template-bookmark-pager"> <li> <div class="centerarticle-pager"> <span class="centerarticle-waiting js-read-more-waiting is-hidden"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/loading@2x.gif" alt="残りのブックマークを読み込んでいます" width="16" height="16" /></span> {{#previous}} <a href="{{page_path}}">{{label}}</a> {{/previous}} {{#pages}} {{#page_path}} <span><a href="{{page_path}}">{{label}}</a></span> {{/page_path}} {{^page_path}} <span>{{label}}</span> {{/page_path}} {{/pages}} {{#next}} <a href="{{page_path}}">{{label}}</a> {{/next}} </div> </li> </script> <ul class="js-user-bookmark-item-list js-keyboard-controllable-container"> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://blog.engineer.adways.net/entry/2024/11/15/120000"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://blog.engineer.adways.net/entry/2024/11/15/120000" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fblog.engineer.adways.net%2Fentry%2F2024%2F11%2F15%2F120000" alt="">【MySQL】メジャーバージョンアップグレードの味方: “アップグレードチェッカーユーティリティ”を理解して活用しよう - Adwaysエンジニアブログ</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/blog.engineer.adways.net/entry/2024/11/15/120000" class="js-keyboard-entry-page-openable" title="【MySQL】メジャーバージョンアップグレードの味方: “アップグレードチェッカーユーティリティ”を理解して活用しよう - Adwaysエンジニアブログ (57ブックマーク)" data-gtm-click-label="user-bookmark-users">57 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fblog.engineer.adways.net%2F" title="『blog.engineer.adways.net』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> blog.engineer.adways.net </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">あいさつこんにちは！ <a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%8A%80%E8%A1%93">技術</a><a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>部 <a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%8A%80%E8%A1%93">技術</a>戦略Div. リード<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a>の関根です！ 2024年9月にジョインして、コツコツSRE活動を進めておりますっ <a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a>3年目ながらSREにゴリゴリ関われているのは、アドウェイズにオープンなコミュニケーションの<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%96%87%E5%8C%96">文化</a>があるおかげです。SREに少しでも興味がある人は、お待ちしておりますよ！最近、<a data-gtm-click-label="entry-summary-keyword" href="/q/Netflix">Netflix</a>、アマプラ、U-NEXTに加えて<a data-gtm-click-label="entry-summary-keyword" href="/q/Apple">Apple</a>TVも契約してしまいました笑 <a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%98%A0%E7%94%BB">映画</a>やドラマの話しましょうね！あとお酒が大好きなので、社内外問わず飲みに行きましょうね！！この記事はなに？この記事は、<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>メジャーバージョンアップグレード時にアップグレードチェッカーユーティリティ(以下、アップグレードチェッカー)を理解して活用することで、効率的にアップグレードを進めるための情報を記載しています。 SREとして、EOL対応屋さん的な動きをコツコツやっ</p> <a href="https://blog.engineer.adways.net/entry/2024/11/15/120000" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/2c3281ddf8d711d1db7e5c2ae7aa1f461c9e2709/height=288;version=1;width=512/https%3A%2F%2Fcdn.image.st-hatena.com%2Fimage%2Fscale%2Ff2becf45ded975251b79dcfff7ec2cd62de0704a%2Fbackend%3Dimagemagick%3Bheight%3D1300%3Bversion%3D1%3Bwidth%3D1300%2Fhttps%253A%252F%252Fcdn-ak.f.st-hatena.com%252Fimages%252Ffotolife%252FA%252FAdwaysEngineerBlog%252F20241114%252F20241114225905.png" alt="【MySQL】メジャーバージョンアップグレードの味方: “アップグレードチェッカーユーティリティ”を理解して活用しよう - Adwaysエンジニアブログ"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4762045013041203008"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://blog.engineer.adways.net/entry/2024/11/15/120000" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20241117#bookmark-4762045013041203008" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/11/17</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4762045013041203008/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://buildup-db.blogspot.com/2024/11/mysql-80.html"> <div class="centerarticle-entry "> <h3 class="centerarticle-entry-title"> <a href="https://buildup-db.blogspot.com/2024/11/mysql-80.html" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fbuildup-db.blogspot.com%2F2024%2F11%2Fmysql-80.html" alt="">MySQL 8.0 の速いバイナリを作ってみよう</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/buildup-db.blogspot.com/2024/11/mysql-80.html" class="js-keyboard-entry-page-openable" title="MySQL 8.0 の速いバイナリを作ってみよう (21ブックマーク)" data-gtm-click-label="user-bookmark-users">21 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fbuildup-db.blogspot.com%2F" title="『buildup-db.blogspot.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> buildup-db.blogspot.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">念を押しておきますが、このブログの「内容は個人の考えであって、所属組織とは方針が異なる」と考えてください。前のエントリでは、<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 8.0は、clangのP<a data-gtm-click-label="entry-summary-keyword" href="/q/go">GO</a>+LTOでビルドしないと<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>来の性能が出ない。ということを証明しました。その後、P<a data-gtm-click-label="entry-summary-keyword" href="/q/go">GO</a>+LTOといってもプロファイリングをどうしたらいいのかと、<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%87%E3%82%B9%E3%82%AF">デスク</a>トップマシンの空き時間でひたすらビルドとt<a data-gtm-click-label="entry-summary-keyword" href="/q/PC">pc</a>c(ramfs)を繰り返した結果、興味深いことがわかりました。 t<a data-gtm-click-label="entry-summary-keyword" href="/q/PC">pc</a>cのようなある程度複雑なベンチマークは、ベンチマークそのもの（この場合t<a data-gtm-click-label="entry-summary-keyword" href="/q/PC">pc</a>c）をプロファイリングするよりも、 <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">mysql</a>-testのスクリプトを組み合わせて工夫したほうが性能が出るということです。（少なくとも私の環境で、ではですが）つまり、ビルドしてテストスクリプトが流せる環境であれば、総合的に最適に近いバイナリが生成できるということです。誰でもビルドできま</p> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4761821912992112768"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://buildup-db.blogspot.com/2024/11/mysql-80.html" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20241111#bookmark-4761821912992112768" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/11/11</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4761821912992112768/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://blog.smartbank.co.jp/entry/mysql_lock_block_timeout_busters"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://blog.smartbank.co.jp/entry/mysql_lock_block_timeout_busters" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fblog.smartbank.co.jp%2Fentry%2Fmysql_lock_block_timeout_busters" alt="">MySQLのロックに起因するブロックタイムアウト撃退記 - inSmartBank</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/blog.smartbank.co.jp/entry/mysql_lock_block_timeout_busters" class="js-keyboard-entry-page-openable" title="MySQLのロックに起因するブロックタイムアウト撃退記 - inSmartBank (206ブックマーク)" data-gtm-click-label="user-bookmark-users">206 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fblog.smartbank.co.jp%2F" title="『blog.smartbank.co.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> blog.smartbank.co.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">こんにちは。スマートバンクのサーバーサイド<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a>をやっておりますid:moznionです。すっかり秋めいてきましたね。秋といえば<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>*1、ということで今回は先日解消した「<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>のロックに起因するブロックタイムアウト」のトラブルシューティングついて記していきたいと思います。事の発端ある時を境に<a data-gtm-click-label="entry-summary-keyword" href="/q/Sentry">Sentry</a>に ActiveRecord::LockW<a data-gtm-click-label="entry-summary-keyword" href="/q/ai">ai</a>tTimeout というエラーがしばしば報告されるようになっていました。 <a data-gtm-click-label="entry-summary-keyword" href="/q/Sentry">Sentry</a>にActiveRecord::LockW<a data-gtm-click-label="entry-summary-keyword" href="/q/ai">ai</a>tTimeoutが上がってきている様子 <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">Mysql</a>2::<a data-gtm-click-label="entry-summary-keyword" href="/q/ERR">Err</a>or::Timeout<a data-gtm-click-label="entry-summary-keyword" href="/q/ERR">Err</a>or: Lock w<a data-gtm-click-label="entry-summary-keyword" href="/q/ai">ai</a>t timeout exceeded という文言から、<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>上でロックを取っている他のクエリにブロックされ、そのブロックが長時間に渡ったため自クエリがタイムアウトしてabortしてし</p> <a href="https://blog.smartbank.co.jp/entry/mysql_lock_block_timeout_busters" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/49e584a2733a7cf4bed8ceefea403c0b59434bb4/height=288;version=1;width=512/https%3A%2F%2Fcdn.image.st-hatena.com%2Fimage%2Fscale%2F68bfd0f75dcc325c6be56511f3e425ecac57f5fc%2Fbackend%3Dimagemagick%3Bheight%3D1300%3Bversion%3D1%3Bwidth%3D1300%2Fhttps%253A%252F%252Fcdn-ak.f.st-hatena.com%252Fimages%252Ffotolife%252Fs%252Fsmartbank%252F20241001%252F20241001135336.png" alt="MySQLのロックに起因するブロックタイムアウト撃退記 - inSmartBank"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4759980974561796704"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://blog.smartbank.co.jp/entry/mysql_lock_block_timeout_busters" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20241002#bookmark-4759980974561796704" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/10/02</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4759980974561796704/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="http://buildup-db.blogspot.com/2024/09/mysql-80_11.html"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="http://buildup-db.blogspot.com/2024/09/mysql-80_11.html" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fbuildup-db.blogspot.com%2F2024%2F09%2Fmysql-80_11.html" alt="">MySQL 8.0 は遅くなってきてる？何故？（２）</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/buildup-db.blogspot.com/2024/09/mysql-80_11.html" class="js-keyboard-entry-page-openable" title="MySQL 8.0 は遅くなってきてる？何故？（２） (51ブックマーク)" data-gtm-click-label="user-bookmark-users">51 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fbuildup-db.blogspot.com%2F" title="『buildup-db.blogspot.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> buildup-db.blogspot.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">前のエントリの続きです。念を押しておきますが、このブログの「内容は個人の考えであって、所属組織とは方針が異なる」と考えてください。さて、<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 8.0.xの単スレッド性能がどんどん遅くなってきた要因は幾つかありそうなので切り分けていきたいと思います。まずは、数年前のエントリ「やはり<a data-gtm-click-label="entry-summary-keyword" href="/q/c%2B%2B">C++</a>はCよりも遅い？」の影響をできるだけ正確に見積もりたいところです。実行バイナリの最適化レベルを合わせて比較して初めて、ロジックの劣化が判るわけです。コンパイラのオプションの範疇でできるだけ最大の最適化を行って計測したいところです。いくつか試した結果、clangのP<a data-gtm-click-label="entry-summary-keyword" href="/q/go">GO</a>+LTO が手軽な中では最も効果があったのでそれで同じ計測をしてみましょう。(GCCのP<a data-gtm-click-label="entry-summary-keyword" href="/q/go">GO</a>+LTO と clangのP<a data-gtm-click-label="entry-summary-keyword" href="/q/go">GO</a>のみはこれよりも少し劣ったのでとりあえず。) (補足) P<a data-gtm-click-label="entry-summary-keyword" href="/q/go">GO</a> は、一旦ターゲットとなる処理をプロファイリン</p> <a href="https://buildup-db.blogspot.com/2024/09/mysql-80_11.html" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/004e01ee7b12f501219820935dc288f31b84003d/height=288;version=1;width=512/https%3A%2F%2Fblogger.googleusercontent.com%2Fimg%2Fb%2FR29vZ2xl%2FAVvXsEiqKfZPUTo8-pY4rWEiI6egeMatGEU7c_4se7f3kQvqzsoNSo3uojanoFSSQrw-TzCzSVzGg0pBIc0rJVDMHpINrd9PTGUrxIf4si_ac4GYQUHtEHmlEErTqu5Ek6EpGgaMYDLgJt1pKAUS2kUtyGF7p-DhQw-FGa9Oc_WSwWoFKwpjcNpJIsj-DaV3cgq1%2Fw1200-h630-p-k-no-nu%2Fgithub_clangPGOLTO_ins-sel.png" alt="MySQL 8.0 は遅くなってきてる？何故？（２）"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4758996154617829856"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="http://buildup-db.blogspot.com/2024/09/mysql-80_11.html" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240911#bookmark-4758996154617829856" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/09/11</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4758996154617829856/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://www.percona.com/blog/improving-mysql-query-performance/"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://www.percona.com/blog/improving-mysql-query-performance/" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fimproving-mysql-query-performance%2F" alt="">Ultimate Guide to Improving MySQL Query Performance</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/www.percona.com/blog/improving-mysql-query-performance/" class="js-keyboard-entry-page-openable" title="Ultimate Guide to Improving MySQL Query Performance (181ブックマーク)" data-gtm-click-label="user-bookmark-users">181 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fwww.percona.com%2F" title="『www.percona.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> www.percona.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"><a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> is ce<a data-gtm-click-label="entry-summary-keyword" href="/q/RTA">rta</a>inly a powerful open source <a data-gtm-click-label="entry-summary-keyword" href="/q/Database">database</a> manag<a data-gtm-click-label="entry-summary-keyword" href="/q/EM">em</a>ent syst<a data-gtm-click-label="entry-summary-keyword" href="/q/EM">em</a>, but even the most robust engine struggles when queries take an etern<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>y to execute. For <a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>As and developers, improving <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> query perf<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">orm</a>ance is an on<a data-gtm-click-label="entry-summary-keyword" href="/q/go">go</a>ing <a data-gtm-click-label="entry-summary-keyword" href="/q/go">go</a>al. Efficient query perf<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">orm</a>ance is crucial for ensuring the smooth operation and optimal user experience of applications powered by <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/Database">database</a>s. When busines<a data-gtm-click-label="entry-summary-keyword" href="/q/ses">ses</a> rely h</p> <a href="https://www.percona.com/blog/improving-mysql-query-performance/" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/74f1cf740a73297a559840b88b8cb91657d72acf/height=288;version=1;width=512/https%3A%2F%2Fwww.percona.com%2Fblog%2Fwp-content%2Fuploads%2F2024%2F06%2FUltimate-Guide-to-Improving-MySQL-Query-Performance.jpeg" alt="Ultimate Guide to Improving MySQL Query Performance"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4756532550835565696"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://www.percona.com/blog/improving-mysql-query-performance/" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240720#bookmark-4756532550835565696" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/07/20</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4756532550835565696/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://zenn.dev/canalun/articles/all_about_mysql_index"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://zenn.dev/canalun/articles/all_about_mysql_index" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fzenn.dev%2Fcanalun%2Farticles%2Fall_about_mysql_index" alt="">MySQLのインデックスの貼っていいとき悪いときを原理から理解したいよ😭</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/zenn.dev/canalun/articles/all_about_mysql_index" class="js-keyboard-entry-page-openable" title="MySQLのインデックスの貼っていいとき悪いときを原理から理解したいよ😭 (414ブックマーク)" data-gtm-click-label="user-bookmark-users">414 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fzenn.dev%2Fcanalun" title="『zenn.dev/canalun』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> zenn.dev/canalun </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">今回答えを出したい問いはこちら！！インデックスはどのような仕組みを以て、何を実現したいものなのかそれを踏まえたとき、インデックスはどういう場合になぜ貼る方が良いのか。また、どういう場合になぜ貼らない方が良いのか大体分かっているよって人はサヨナラって感じのおさらい記事だぜ！！！！それじゃいってみよー🎉 あと、おれは今回<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>にしぼっていくぜ👶 ってわけで<a data-gtm-click-label="entry-summary-keyword" href="/q/oracle">Oracle</a>とかに興味があるやつは引き返しな！ indexの概要公式の見解としては「where句を使ったselectクエリの実行速度を向上させるために実装されている、各行へのポインターのような振る舞いをする仕組み」って感じ👶 The best way to improve the perf<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">orm</a>ance of SELECT operations is to <a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">cre</a>ate indexes on one or more of t</p> <a href="https://zenn.dev/canalun/articles/all_about_mysql_index" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/39e3707116cfb76c52fa55563a3d4a7499fd8b33/height=288;version=1;width=512/https%3A%2F%2Fres.cloudinary.com%2Fzenn%2Fimage%2Fupload%2Fs--PG_eSmW6--%2Fc_fit%252Cg_north_west%252Cl_text%3Anotosansjp-medium.otf_55%3AMySQL%2525E3%252581%2525AE%2525E3%252582%2525A4%2525E3%252583%2525B3%2525E3%252583%252587%2525E3%252583%252583%2525E3%252582%2525AF%2525E3%252582%2525B9%2525E3%252581%2525AE%2525E8%2525B2%2525BC%2525E3%252581%2525A3%2525E3%252581%2525A6%2525E3%252581%252584%2525E3%252581%252584%2525E3%252581%2525A8%2525E3%252581%25258D%2525E6%252582%2525AA%2525E3%252581%252584%2525E3%252581%2525A8%2525E3%252581%25258D%2525E3%252582%252592%2525E5%25258E%25259F%2525E7%252590%252586%2525E3%252581%25258B%2525E3%252582%252589%2525E7%252590%252586%2525E8%2525A7%2525A3%2525E3%252581%252597%2525E3%252581%25259F%2525E3%252581%252584%2525E3%252582%252588%252520%252Cw_1010%252Cx_90%252Cy_100%2Fg_south_west%252Cl_text%3Anotosansjp-medium.otf_37%3Acanalun%252Cx_203%252Cy_121%2Fg_south_west%252Ch_90%252Cl_fetch%3AaHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL3plbm4tdXNlci11cGxvYWQvYXZhdGFyL2UyMGFkNzQ4N2UuanBlZw%3D%3D%252Cr_max%252Cw_90%252Cx_87%252Cy_95%2Fv1627283836%2Fdefault%2Fog-base-w1200-v2.png" alt="MySQLのインデックスの貼っていいとき悪いときを原理から理解したいよ😭"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4727610801341291299"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://zenn.dev/canalun/articles/all_about_mysql_index" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240429#bookmark-4727610801341291299" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/04/29</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4727610801341291299/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://zenn.dev/levtech/articles/36531641f019c8"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://zenn.dev/levtech/articles/36531641f019c8" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fzenn.dev%2Flevtech%2Farticles%2F36531641f019c8" alt="">スロークエリを改善したらECSの負荷が爆下がりした話(TypeORM)</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/zenn.dev/levtech/articles/36531641f019c8" class="js-keyboard-entry-page-openable" title="スロークエリを改善したらECSの負荷が爆下がりした話(TypeORM) (54ブックマーク)" data-gtm-click-label="user-bookmark-users">54 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fzenn.dev%2Flevtech" title="『zenn.dev/levtech』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> zenn.dev/levtech </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">TL;DR Type<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">ORM</a>で発生していたスロークエリを改善スロークエリを改善したらECSの負荷も減少はじめにスロークエリを改善したら、ECSコンテナ側の負荷も下がってなんでだろ？と思ったので記事にしようと思います。環境 Type<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">ORM</a> v0.3.20 Node.js v18.x バックエンドインフラ ECS on Fargate => <a data-gtm-click-label="entry-summary-keyword" href="/q/Amazon">Amazon</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/aurora">Aurora</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 負荷改善の前と後まずはどのくらい改善したのかを示します。この時ECSコンテナ8台動いてました。(4v<a data-gtm-click-label="entry-summary-keyword" href="/q/CPU">CPU</a> 8GBM<a data-gtm-click-label="entry-summary-keyword" href="/q/EM">em</a>) 改善前改善後改善前と改善後は一日前の同じ時間帯のものです。ちゃんと動いてるのか不安になるくらい下がってました笑どのような対応をしたのかスロークエリの出ていたクエリで<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>の実行計画を確認しました。 TypeALL,index, Using Filesort等はなかったので</p> <a href="https://zenn.dev/levtech/articles/36531641f019c8" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/3c873b0ef00f59680f4af457728c8c5bd7d510b8/height=288;version=1;width=512/https%3A%2F%2Fres.cloudinary.com%2Fzenn%2Fimage%2Fupload%2Fs--5HLZTiEJ--%2Fc_fit%252Cg_north_west%252Cl_text%3Anotosansjp-medium.otf_55%3A%2525E3%252582%2525B9%2525E3%252583%2525AD%2525E3%252583%2525BC%2525E3%252582%2525AF%2525E3%252582%2525A8%2525E3%252583%2525AA%2525E3%252582%252592%2525E6%252594%2525B9%2525E5%252596%252584%2525E3%252581%252597%2525E3%252581%25259F%2525E3%252582%252589ECS%2525E3%252581%2525AE%2525E8%2525B2%2525A0%2525E8%25258D%2525B7%2525E3%252581%25258C%2525E7%252588%252586%2525E4%2525B8%25258B%2525E3%252581%25258C%2525E3%252582%25258A%2525E3%252581%252597%2525E3%252581%25259F%2525E8%2525A9%2525B1%252528TypeORM%252529%252Cw_1010%252Cx_90%252Cy_100%2Fg_south_west%252Cl_text%3Anotosansjp-medium.otf_34%3Akmasu%252Cx_220%252Cy_108%2Fbo_3px_solid_rgb%3Ad6e3ed%252Cg_south_west%252Ch_90%252Cl_fetch%3AaHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL3plbm4tdXNlci11cGxvYWQvYXZhdGFyLzY1YzcxZDY5NDkuanBlZw%3D%3D%252Cr_20%252Cw_90%252Cx_92%252Cy_102%2Fg_south_west%252Ch_34%252Cl_default%3Aog-publication-pro-mark-xcosax%252Cw_34%252Cx_217%252Cy_158%2Fco_rgb%3A6e7b85%252Cg_south_west%252Cl_text%3Anotosansjp-medium.otf_30%3A%2525E3%252583%2525AC%2525E3%252583%252590%2525E3%252583%252586%2525E3%252583%252583%2525E3%252582%2525AF%2525E9%252596%25258B%2525E7%252599%2525BA%2525E9%252583%2525A8%252Cx_255%252Cy_160%2Fbo_4px_solid_white%252Cg_south_west%252Ch_50%252Cl_fetch%3AaHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL3plbm4tdXNlci11cGxvYWQvYXZhdGFyL2JhZGIxM2ZkNmEuanBlZw%3D%3D%252Cr_max%252Cw_50%252Cx_139%252Cy_84%2Fv1627283836%2Fdefault%2Fog-base-w1200-v2.png" alt="スロークエリを改善したらECSの負荷が爆下がりした話(TypeORM)"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4751661678328136416"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://zenn.dev/levtech/articles/36531641f019c8" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240406#bookmark-4751661678328136416" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/04/06</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-reaction-tag">パフォーマンス</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4751661678328136416/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://wrsn0.hatenablog.com/entry/2024/02/22/092703"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://wrsn0.hatenablog.com/entry/2024/02/22/092703" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fwrsn0.hatenablog.com%2Fentry%2F2024%2F02%2F22%2F092703" alt="">「開発者向けの MySQL 入門」という勉強会をしました - しなしな記録</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/wrsn0.hatenablog.com/entry/2024/02/22/092703" class="js-keyboard-entry-page-openable" title="「開発者向けの MySQL 入門」という勉強会をしました - しなしな記録 (135ブックマーク)" data-gtm-click-label="user-bookmark-users">135 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fwrsn0.hatenablog.com%2F" title="『wrsn0.hatenablog.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> wrsn0.hatenablog.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">今、自分が所属している会社では、いわゆるフルサイクルなアプリケーション<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a>がほとんどで、SRE のような、システムを運用改善することを専門にするメンバーは居ません。一方でそれなりにプロダクトの数は多く、各種ミドルウェアの運用で困っているのを見かけることがあります。色々な人が似た問題に悩むのはもったいないので、「<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> を運用したことがある人からすると、こういう考え方をする」という風な目線で勉強会を行いました。せっかくなので社内の情報を抜いたうえで公開します（同じようなことを色々な場所で言っていて、その都度作り直しているから……というのもあります）。 <a data-gtm-click-label="entry-summary-keyword" href="/q/speakerdeck">speakerdeck</a>.com ちなみに <a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a> のどこで悩むかはだいぶ業界ドメインに左右されると思っています（それはそう）。<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%B2%E3%83%BC%E3%83%A0">ゲーム</a>業界なんかは、激しくスパイクするワークロードな上にミスったときの機会損失が激しいので、シャーディングを</p> <a href="https://wrsn0.hatenablog.com/entry/2024/02/22/092703" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/971eeda7d09cbe4b1fd0c5cfdf5761b34d3a7590/height=288;version=1;width=512/https%3A%2F%2Fogimage.blog.st-hatena.com%2F26006613711043585%2F6801883189085158349%2F1708571847" alt="「開発者向けの MySQL 入門」という勉強会をしました - しなしな記録"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4749638499065116832"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://wrsn0.hatenablog.com/entry/2024/02/22/092703" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240405#bookmark-4749638499065116832" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/04/05</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4749638499065116832/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://github.blog/jp/2024-03-29-upgrading-github-com-to-mysql-8-0/"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://github.blog/jp/2024-03-29-upgrading-github-com-to-mysql-8-0/" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fgithub.blog%2Fjp%2F2024-03-29-upgrading-github-com-to-mysql-8-0%2F" alt="">GitHub.com を MySQL 8.0にアップグレード</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/github.blog/jp/2024-03-29-upgrading-github-com-to-mysql-8-0/" class="js-keyboard-entry-page-openable" title="GitHub.com を MySQL 8.0にアップグレード (45ブックマーク)" data-gtm-click-label="user-bookmark-users">45 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fgithub.blog%2F" title="『github.blog』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> github.blog </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"><a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>は、15年以上前に単一の<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>データベースを持つ<a data-gtm-click-label="entry-summary-keyword" href="/q/ruby">Ruby</a> on <a data-gtm-click-label="entry-summary-keyword" href="/q/rails">Rails</a>アプリケーションとしてスタートしました。それ以来、<a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>は高可用性を構築する、テスト自動化を実装する、データのパーティショニングを行うなど、プラットフォームのスケーリングと可用性のニーズを満たすために、<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>アーキテクチャを進化させてきました。今日、<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>は<a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>のインフラストラクチャの中核を担い、選択可能なリレーショナルデータベースの一部です。このブログは、1200台以上の<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a><a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%9B%E3%82%B9%E3%83%88">ホスト</a>を8.0にアップグレードした物語です。私たちのサービスレベル目標(SLO)に影響を与えることなくフリートをアップグレードすることは小手先の技で済むようなものではありませんでした。計画、テスト、そしてアップグレード自体は1年以上かかり、<a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>内の複数のチームが協力しました。アップグレード</p> <a href="https://github.blog/jp/2024-03-29-upgrading-github-com-to-mysql-8-0/" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/44415c98227d79e32be97289ac84ef57e0415c3e/height=288;version=1;width=512/https%3A%2F%2Fgithub.blog%2Fjp%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F03%2FProductivity-DarkMode-1.png" alt="GitHub.com を MySQL 8.0にアップグレード"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4751338130326331072"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://github.blog/jp/2024-03-29-upgrading-github-com-to-mysql-8-0/" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240330#bookmark-4751338130326331072" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/03/30</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4751338130326331072/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://blog.kinto-technologies.com/posts/2024-03-05-aurora-mysql-stats-collector-for-blocking/"> <div class="centerarticle-entry "> <h3 class="centerarticle-entry-title"> <a href="https://blog.kinto-technologies.com/posts/2024-03-05-aurora-mysql-stats-collector-for-blocking/" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fblog.kinto-technologies.com%2Fposts%2F2024-03-05-aurora-mysql-stats-collector-for-blocking%2F" alt="">Aurora MySQL におけるロック競合（ブロッキング）の原因を事後調査できる仕組みを作った話</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/blog.kinto-technologies.com/posts/2024-03-05-aurora-mysql-stats-collector-for-blocking/" class="js-keyboard-entry-page-openable" title="Aurora MySQL におけるロック競合（ブロッキング）の原因を事後調査できる仕組みを作った話 (86ブックマーク)" data-gtm-click-label="user-bookmark-users">86 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fblog.kinto-technologies.com%2F" title="『blog.kinto-technologies.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> blog.kinto-technologies.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">こんにちは。 <a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>RE チーム所属の @p2sk です。 <a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>RE（<a data-gtm-click-label="entry-summary-keyword" href="/q/Database">Database</a> Reliabil<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>y Engineering）チームでは、横断組織としてデータベースに関する課題解決や、組織のアジリティとガバナンスのバランスを取るためのプラットフォーム開発などを行なっております。<a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>RE は比較的新しい概念で、<a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>RE という組織がある会社も少なく、あったとしても取り組んでいる内容や考え方が異なるような、発展途上の非常に面白い領域です。弊社における <a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>RE チーム発足の背景やチームの役割については「KTC における <a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a>RE の必要性」というテックブログをご覧ください。 <a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>記事では、<a data-gtm-click-label="entry-summary-keyword" href="/q/aurora">Aurora</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> でロック競合（ブロッキング）起因のタイムアウトエラーが発生した際に根<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>原因を特定することができなかったので、原因を後追いするために必要な情報を定期的に収集する仕組みを構築した</p> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4751126648775302688"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://blog.kinto-technologies.com/posts/2024-03-05-aurora-mysql-stats-collector-for-blocking/" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240325#bookmark-4751126648775302688" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/03/25</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-reaction-tag">パフォーマンス</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4751126648775302688/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://blog.shibayu36.org/entry/2024/02/27/173000"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://blog.shibayu36.org/entry/2024/02/27/173000" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fblog.shibayu36.org%2Fentry%2F2024%2F02%2F27%2F173000" alt="">MySQLのREPEATABLE READとREAD COMMITTEDの違いを知るために色々試した - $shibayu36->blog;</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/blog.shibayu36.org/entry/2024/02/27/173000" class="js-keyboard-entry-page-openable" title="MySQLのREPEATABLE READとREAD COMMITTEDの違いを知るために色々試した - $shibayu36->blog; (46ブックマーク)" data-gtm-click-label="user-bookmark-users">46 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fblog.shibayu36.org%2F" title="『blog.shibayu36.org』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> blog.shibayu36.org </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"><a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>のトランザクション分離レベルについてふんわりとした理解しかないなと感じた。もう少し理解するために、とくにREPEATA<a data-gtm-click-label="entry-summary-keyword" href="/q/BL">BL</a>E READとREAD COMM<a data-gtm-click-label="entry-summary-keyword" href="/q/it">IT</a>TEDの違いを手を動かして色々確認してみた。以下の記事を参考にした。 [<a data-gtm-click-label="entry-summary-keyword" href="/q/RDBMS">RDBMS</a>][<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>]トランザクション分離レベルについて極力分かりやすく解説 #<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> - Qi<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>a <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> :: <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 8.0 リファレンスマニュアル :: 15.7.2.1 トランザクション分離レベル大まかな違い公式ドキュメントを見る限りノンリピータブルリード、ファントムリードが発生するか範囲に含まれるギャップへのほかのセッションによる挿入をブロックするかの違いがありそうに見える。ノンリピータブルリード、ファントムリードが発生するかを試す以下のテーブルを作る。 <a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">CRE</a>ATE TA<a data-gtm-click-label="entry-summary-keyword" href="/q/BL">BL</a>E `posts` ( `t<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>le`</p> <a href="https://blog.shibayu36.org/entry/2024/02/27/173000" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/c844c30a8203f5e969ea9df0d8b9f7e86d90bf98/height=288;version=1;width=512/https%3A%2F%2Fogimage.blog.st-hatena.com%2F13208692334729907814%2F6801883189085752339%2F1709022601" alt="MySQLのREPEATABLE READとREAD COMMITTEDの違いを知るために色々試した - $shibayu36->blog;"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4749896048511500096"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://blog.shibayu36.org/entry/2024/02/27/173000" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240228#bookmark-4749896048511500096" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/02/28</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4749896048511500096/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://qiita.com/SimonLee/items/a878f721975370b45883"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://qiita.com/SimonLee/items/a878f721975370b45883" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fqiita.com%2FSimonLee%2Fitems%2Fa878f721975370b45883" alt="">SQLの達人への道: MySQLでの高速・効率的クエリ作成術 - Qiita</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/qiita.com/SimonLee/items/a878f721975370b45883" class="js-keyboard-entry-page-openable" title="SQLの達人への道: MySQLでの高速・効率的クエリ作成術 - Qiita (379ブックマーク)" data-gtm-click-label="user-bookmark-users">379 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fqiita.com%2FSimonLee" title="『qiita.com/SimonLee』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> qiita.com/SimonLee </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">データベースとテーブルの作成テスト用のデータベースtest<a data-gtm-click-label="entry-summary-keyword" href="/q/DB">db</a>を作成し、パフォーマンスチューニングを検証するためのcompanyおよびpersonテーブルを定義します。 <a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">CRE</a>ATE <a data-gtm-click-label="entry-summary-keyword" href="/q/Database">DATABASE</a> test<a data-gtm-click-label="entry-summary-keyword" href="/q/DB">db</a>; USE test<a data-gtm-click-label="entry-summary-keyword" href="/q/DB">db</a>; <a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">CRE</a>ATE TA<a data-gtm-click-label="entry-summary-keyword" href="/q/BL">BL</a>E company ( company_id INT AUTO_IN<a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">CRE</a>MENT PRIMARY KEY, company_name VARCHAR(255) NOT NULL, <a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">cre</a>ated_at TIME<a data-gtm-click-label="entry-summary-keyword" href="/q/stamp">STAMP</a> DEFAULT CURRENT_TIME<a data-gtm-click-label="entry-summary-keyword" href="/q/stamp">STAMP</a> ); <a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">CRE</a>ATE TA<a data-gtm-click-label="entry-summary-keyword" href="/q/BL">BL</a>E person ( person_id INT AUTO_IN<a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">CRE</a>MENT PRIMARY KEY, company_id INT, person_name VARCHAR(255) NOT NULL, <a data-gtm-click-label="entry-summary-keyword" href="/q/EM">em</a><a data-gtm-click-label="entry-summary-keyword" href="/q/ai">ai</a>l VARCH</p> <a href="https://qiita.com/SimonLee/items/a878f721975370b45883" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/8de9603d7de9006c7f71713b6e9fd9b5c6299ce9/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-412672c5f0600ab9a64263b751f1bc81.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk3MiZoPTM3OCZ0eHQ9U1FMJUUzJTgxJUFFJUU5JTgxJTk0JUU0JUJBJUJBJUUzJTgxJUI4JUUzJTgxJUFFJUU5JTgxJTkzJTNBJTIwTXlTUUwlRTMlODElQTclRTMlODElQUUlRTklQUIlOTglRTklODAlOUYlRTMlODMlQkIlRTUlOEElQjklRTclOEUlODclRTclOUElODQlRTMlODIlQUYlRTMlODIlQTglRTMlODMlQUElRTQlQkQlOUMlRTYlODglOTAlRTglQTElOTMmdHh0LWFsaWduPWxlZnQlMkN0b3AmdHh0LWNvbG9yPSUyMzFFMjEyMSZ0eHQtZm9udD1IaXJhZ2lubyUyMFNhbnMlMjBXNiZ0eHQtc2l6ZT01NiZzPThhMjdkY2U2N2M3OWQwYjRkODkzMDM5YTUyMDZkZDNi%26mark-x%3D142%26mark-y%3D57%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZoPTc2Jnc9NzcwJnR4dD0lNDBTaW1vbkxlZSZ0eHQtY29sb3I9JTIzMUUyMTIxJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9YjQ0YTQxMmIzOTdmMTVkOGY3M2QzMzA5MmNhMWU5OWQ%26blend-x%3D142%26blend-y%3D486%26blend-mode%3Dnormal%26s%3D76a9def21546bdb69b4939c24258081f" alt="SQLの達人への道: MySQLでの高速・効率的クエリ作成術 - Qiita"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4749597511098091168"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://qiita.com/SimonLee/items/a878f721975370b45883" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240222#bookmark-4749597511098091168" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/02/22</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> <li><a href="/R2M/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-reaction-tag">パフォーマンス</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4749597511098091168/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://gihyo.jp/article/2024/01/mysql-rcn0214"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://gihyo.jp/article/2024/01/mysql-rcn0214" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fgihyo.jp%2Farticle%2F2024%2F01%2Fmysql-rcn0214" alt="">第214回　MySQL ShellでMySQLに接続してみる | gihyo.jp</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/gihyo.jp/article/2024/01/mysql-rcn0214" class="js-keyboard-entry-page-openable" title="第214回　MySQL ShellでMySQLに接続してみる | gihyo.jp (5ブックマーク)" data-gtm-click-label="user-bookmark-users">5 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fgihyo.jp%2F" title="『gihyo.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> gihyo.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"><a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> Shellは、<a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>連載でも何度か取り上げられている<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">mysql</a>コマンドラインクライアントと同等以上の機能を提供してくれるクライアントです。<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> Shellは<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 5.7がGAになった5.7.12から使用できるようになっています。今回は、<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> Shellを使った<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>への接続方法に関して説明していきたいと思います。検証環境今回は<a data-gtm-click-label="entry-summary-keyword" href="/q/docker">Docker</a>で建てた<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>を使用します。以下のコマンドで<a data-gtm-click-label="entry-summary-keyword" href="/q/docker">Docker</a>を建てて、ローカルからアクセスをします。 % <a data-gtm-click-label="entry-summary-keyword" href="/q/docker">docker</a> run --platf<a data-gtm-click-label="entry-summary-keyword" href="/q/ORM">orm</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/Linux">linux</a>/x86_64 -p 127.0.0.1:3307:3306 -e <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MYSQL</a>_ROOT_PASSWORD=my-se<a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">cre</a>t-pw -e <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MYSQL</a>_USER=kk2170 -e <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MYSQL</a>_PASSWORD=my-se<a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">cre</a>t-pw -d <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">mysql</a>:8.0.</p> <a href="https://gihyo.jp/article/2024/01/mysql-rcn0214" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/d34502a68fb4a5182423b4f793d18a09c73fb437/height=288;version=1;width=512/https%3A%2F%2Fgihyo.jp%2Fassets%2Fimages%2FICON%2F2022%2F1898_mysql_rcn_new.png" alt="第214回　MySQL ShellでMySQLに接続してみる | gihyo.jp"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4748598932569591887"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://gihyo.jp/article/2024/01/mysql-rcn0214" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240130#bookmark-4748598932569591887" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/01/30</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4748598932569591887/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://developer.hatenastaff.com/entry/2024/01/19/164530"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://developer.hatenastaff.com/entry/2024/01/19/164530" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fdeveloper.hatenastaff.com%2Fentry%2F2024%2F01%2F19%2F164530" alt="">はてなブログの DB を RDS for MySQL 8.0 にアップグレードした話 - Hatena Developer Blog</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/developer.hatenastaff.com/entry/2024/01/19/164530" class="js-keyboard-entry-page-openable" title="はてなブログの DB を RDS for MySQL 8.0 にアップグレードした話 - Hatena Developer Blog (194ブックマーク)" data-gtm-click-label="user-bookmark-users">194 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fdeveloper.hatenastaff.com%2F" title="『developer.hatenastaff.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> developer.hatenastaff.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">この記事は、<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%81%AF%E3%81%A6%E3%81%AA">はてな</a><a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a> Advent Calendar <a data-gtm-click-label="entry-summary-keyword" href="/q/2023">2023</a>の2024年1月17日の記事です。 <a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%81%AF%E3%81%A6%E3%81%AA">はてな</a><a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a> Advent Calendar <a data-gtm-click-label="entry-summary-keyword" href="/q/2023">2023</a> - <a data-gtm-click-label="entry-summary-keyword" href="/q/hatena">Hatena</a> Developer <a data-gtm-click-label="entry-summary-keyword" href="/q/BL">Bl</a>og id:hagihala です。先日、<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%81%AF%E3%81%A6%E3%81%AA">はてな</a>ブログの <a data-gtm-click-label="entry-summary-keyword" href="/q/DB">DB</a> を RDS for <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 5.7 から 8.0 へアップグレードしたので、工夫した点などを共有します。 <a data-gtm-click-label="entry-summary-keyword" href="/q/aurora">Aurora</a> <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 3.x にしなかった理由 <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 5.7 -> 8.0 で対応した変更点 character set や collation のデフォルトが変更される explic<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>_defaults_for_time<a data-gtm-click-label="entry-summary-keyword" href="/q/stamp">stamp</a> がデフォルトで有効になる <a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a> mode の変更デフォルトの認証プラグインが caching_sha2_password になり、 <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">mysql</a>_native_passw</p> <a href="https://developer.hatenastaff.com/entry/2024/01/19/164530" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/89dadcc45846fcfa18e772263c8420e9aaef23ce/height=288;version=1;width=512/https%3A%2F%2Fcdn-ak.f.st-hatena.com%2Fimages%2Ffotolife%2Fh%2Fhatenatech%2F20240119%2F20240119164532.png" alt="はてなブログの DB を RDS for MySQL 8.0 にアップグレードした話 - Hatena Developer Blog"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4748075580883960591"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://developer.hatenastaff.com/entry/2024/01/19/164530" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240119#bookmark-4748075580883960591" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/01/19</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4748075580883960591/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://zenn.dev/reiwatravel/articles/9ce1050bf8509b"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://zenn.dev/reiwatravel/articles/9ce1050bf8509b" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fzenn.dev%2Freiwatravel%2Farticles%2F9ce1050bf8509b" alt="">MySQLでUUIDv4をプライマリキーにするとパフォーマンス問題が起きるのはなぜ？（N回目）</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/zenn.dev/reiwatravel/articles/9ce1050bf8509b" class="js-keyboard-entry-page-openable" title="MySQLでUUIDv4をプライマリキーにするとパフォーマンス問題が起きるのはなぜ？（N回目） (199ブックマーク)" data-gtm-click-label="user-bookmark-users">199 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fzenn.dev%2Freiwatravel" title="『zenn.dev/reiwatravel』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> zenn.dev/reiwatravel </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">はじめにこんにちは、令和トラベルでバックエンド<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%82%A8%E3%83%B3%E3%82%B8%E3%83%8B%E3%82%A2">エンジニア</a>をしている飯沼です。 <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>では、<a data-gtm-click-label="entry-summary-keyword" href="/q/uuid">UUID</a> (v4)などのランダム性の高いIDをプライマリキーに設定すると、パフォーマンスが低下すると言われています。私自身もこの問題については認識しておりアンチパターンとして避けて来ましたが、イマイチ理由を理解できず何度も調べていたので自分の理解を整理しました。 ※ この記事は令和トラベルの<a data-gtm-click-label="entry-summary-keyword" href="/q/tech">Tech</a> LT会で共有した内容を記事にしたものです。社外の方にもご参加いただける<a data-gtm-click-label="entry-summary-keyword" href="/q/tech">Tech</a> LT会は connpass にて告知しています。 <a data-gtm-click-label="entry-summary-keyword" href="/q/uuid">UUID</a>をプライマリキーにするユースケースそもそも<a data-gtm-click-label="entry-summary-keyword" href="/q/uuid">UUID</a>をプライマリキーにするユースケースはどのようなものがあるのでしょうか？いくつかの観点から考えてみます。パフォーマンス観点大量の同時書き込みが発生するような状況でauto in<a data-gtm-click-label="entry-summary-keyword" href="/q/CRE">cre</a>mentを利用してIDを発</p> <a href="https://zenn.dev/reiwatravel/articles/9ce1050bf8509b" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/3b3d4916d52ec734fda5f42928d2765216634177/height=288;version=1;width=512/https%3A%2F%2Fres.cloudinary.com%2Fzenn%2Fimage%2Fupload%2Fs---yipsD_b--%2Fc_fit%252Cg_north_west%252Cl_text%3Anotosansjp-medium.otf_55%3AMySQL%2525E3%252581%2525A7UUIDv4%2525E3%252582%252592%2525E3%252583%252597%2525E3%252583%2525A9%2525E3%252582%2525A4%2525E3%252583%25259E%2525E3%252583%2525AA%2525E3%252582%2525AD%2525E3%252583%2525BC%2525E3%252581%2525AB%2525E3%252581%252599%2525E3%252582%25258B%2525E3%252581%2525A8%2525E3%252583%252591%2525E3%252583%252595%2525E3%252582%2525A9%2525E3%252583%2525BC%2525E3%252583%25259E%2525E3%252583%2525B3%2525E3%252582%2525B9%2525E5%252595%25258F%2525E9%2525A1%25258C%2525E3%252581%25258C%2525E8%2525B5%2525B7%2525E3%252581%25258D%2525E3%252582%25258B%2525E3%252581%2525AE%2525E3%252581%2525AF%2525E3%252581%2525AA%2525E3%252581%25259C%2525EF%2525BC%25259F%2525EF%2525BC%252588N%2525E5%25259B%25259E%2525E7%25259B%2525AE%2525EF%2525BC%252589%252Cw_1010%252Cx_90%252Cy_100%2Fg_south_west%252Cl_text%3Anotosansjp-medium.otf_34%3AShumpei%252520IINUMA%252Cx_220%252Cy_108%2Fbo_3px_solid_rgb%3Ad6e3ed%252Cg_south_west%252Ch_90%252Cl_fetch%3AaHR0cHM6Ly9zdG9yYWdlLmdvb2dsZWFwaXMuY29tL3plbm4tdXNlci11cGxvYWQvYXZhdGFyLzcyYjBjZTEzOGQuanBlZw%3D%3D%252Cr_20%252Cw_90%252Cx_92%252Cy_102%2Fco_rgb%3A6e7b85%252Cg_south_west%252Cl_text%3Anotosansjp-medium.otf_30%3A%2525E4%2525BB%2525A4%2525E5%252592%25258C%2525E3%252583%252588%2525E3%252583%2525A9%2525E3%252583%252599%2525E3%252583%2525AB%252520Tech%252520Blog%252Cx_220%252Cy_160%2Fbo_4px_solid_white%252Cg_south_west%252Ch_50%252Cl_fetch%3AaHR0cHM6Ly9saDMuZ29vZ2xldXNlcmNvbnRlbnQuY29tL2EvQUFjSFR0ZkZrYzJwUHZmSk00a2Jub2FESFFIWk83cFdNR1djeWpwUnEzOUdKRW9JQXc9czk2LWM%3D%252Cr_max%252Cw_50%252Cx_139%252Cy_84%2Fv1627283836%2Fdefault%2Fog-base-w1200-v2.png" alt="MySQLでUUIDv4をプライマリキーにするとパフォーマンス問題が起きるのはなぜ？（N回目）"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4747994705538632367"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://zenn.dev/reiwatravel/articles/9ce1050bf8509b" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20240118#bookmark-4747994705538632367" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2024/01/18</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/database/" data-gtm-click-label="user-reaction-tag">database</a></li> <li><a href="/R2M/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-reaction-tag">パフォーマンス</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4747994705538632367/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://www.publickey1.jp/blog/23/github1200mysql_5780.html"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://www.publickey1.jp/blog/23/github1200mysql_5780.html" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fwww.publickey1.jp%2Fblog%2F23%2Fgithub1200mysql_5780.html" alt="">GitHub、1200台以上のMySQL 5.7を8.0へアップグレード。サービス無停止のまま成功させる</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/www.publickey1.jp/blog/23/github1200mysql_5780.html" class="js-keyboard-entry-page-openable" title="GitHub、1200台以上のMySQL 5.7を8.0へアップグレード。サービス無停止のまま成功させる (463ブックマーク)" data-gtm-click-label="user-bookmark-users">463 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fwww.publickey1.jp%2F" title="『www.publickey1.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> www.publickey1.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary"><a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>、1200台以上の<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 5.7を8.0へアップグレード。サービス無停止のまま成功させる <a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>が提供する<a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>.comは、世界最大のソースコード管理システムを始めとするソフトウェア開発者向け支援サービスを提供しています。その<a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>.comは<a data-gtm-click-label="entry-summary-keyword" href="/q/ruby">Ruby</a> on <a data-gtm-click-label="entry-summary-keyword" href="/q/rails">Rails</a>で構築されており、同社はつねに<a data-gtm-click-label="entry-summary-keyword" href="/q/ruby">Ruby</a>と<a data-gtm-click-label="entry-summary-keyword" href="/q/ruby">Ruby</a> on <a data-gtm-click-label="entry-summary-keyword" href="/q/rails">Rails</a>をアップ<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%87%E3%83%BC%E3%83%88">デート</a>し続けていることを今年（<a data-gtm-click-label="entry-summary-keyword" href="/q/2023">2023</a>年）4月に明らかにしています。参考：<a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>は200万行規模の<a data-gtm-click-label="entry-summary-keyword" href="/q/rails">Rails</a>アプリケーションであり、毎週<a data-gtm-click-label="entry-summary-keyword" href="/q/rails">Rails</a>と<a data-gtm-click-label="entry-summary-keyword" href="/q/ruby">Ruby</a>を最新版にアップ<a data-gtm-click-label="entry-summary-keyword" href="/q/%E3%83%87%E3%83%BC%E3%83%88">デート</a>し続けているそして同社はこの<a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>.comを支える1200台以上の<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 5.7を、<a data-gtm-click-label="entry-summary-keyword" href="/q/github">GitHub</a>.comのサービスレベルを維持したまま1年以上かけて<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 8.0にアップグレードしたことをブログで明らかにしました。 Up</p> <a href="https://www.publickey1.jp/blog/23/github1200mysql_5780.html" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/d3362429830648c53c624441df0896c0296ec374/height=288;version=1;width=512/https%3A%2F%2Fwww.publickey1.jp%2F2023%2Fe9wvKNtf.png" alt="GitHub、1200台以上のMySQL 5.7を8.0へアップグレード。サービス無停止のまま成功させる"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4746280278952987471"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://www.publickey1.jp/blog/23/github1200mysql_5780.html" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20231212#bookmark-4746280278952987471" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2023/12/12</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4746280278952987471/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://qiita.com/kunit/items/7f5883121a621a775e53"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://qiita.com/kunit/items/7f5883121a621a775e53" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fqiita.com%2Fkunit%2Fitems%2F7f5883121a621a775e53" alt="">MySQL 5.7 から 8.0 にしたらテストが激遅になった - Qiita</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/qiita.com/kunit/items/7f5883121a621a775e53" class="js-keyboard-entry-page-openable" title="MySQL 5.7 から 8.0 にしたらテストが激遅になった - Qiita (319ブックマーク)" data-gtm-click-label="user-bookmark-users">319 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fqiita.com%2Fkunit" title="『qiita.com/kunit』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> qiita.com/kunit </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">この記事は、株式会社カオナビ Advent Calendar <a data-gtm-click-label="entry-summary-keyword" href="/q/2023">2023</a> の3日目です。はじめに株式会社カオナビの高橋(@kun<a data-gtm-click-label="entry-summary-keyword" href="/q/it">it</a>)です。今回は <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> バージョンアップ(5.7 -> 8.0) で起きた問題とそれに対してどのように対処したのかを書いていこうと思います。何が起きたのか <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 5.7 から 8.0 にバージョンアップをするにあたって、CI およびローカル環境でテストができるように <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 8.0 のイメージを作成し、それをつかって各機能の担当者にテストを開始してもらっていたのですが、以下のような事が起きました。接続を <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a> 5.7 から 8.0 に切り替えただけでテストの時間が3倍くらいかかるようになったそこを変更するだけで3倍遅くなるってやばいぞということで報告してくれた担当者と同じテストを自分でも実施してみると再現性があり、それが以下のどの</p> <a href="https://qiita.com/kunit/items/7f5883121a621a775e53" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/db256a9515918f51257cb996b78cef22525cfb8f/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Fadvent-calendar-ogp-background-7940cd1c8db80a7ec40711d90f43539e.jpg%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk3MiZoPTM3OCZ0eHQ9TXlTUUwlMjA1LjclMjAlRTMlODElOEIlRTMlODIlODklMjA4LjAlMjAlRTMlODElQUIlRTMlODElOTclRTMlODElOUYlRTMlODIlODklRTMlODMlODYlRTMlODIlQjklRTMlODMlODglRTMlODElOEMlRTYlQkYlODAlRTklODElODUlRTMlODElQUIlRTMlODElQUElRTMlODElQTMlRTMlODElOUYmdHh0LWFsaWduPWxlZnQlMkN0b3AmdHh0LWNvbG9yPSUyMzNBM0MzQyZ0eHQtZm9udD1IaXJhZ2lubyUyMFNhbnMlMjBXNiZ0eHQtc2l6ZT01NiZzPWExMzI0OTEyOTM4MDY0ZTU2MzIwYjZlNmI3N2RjMzhl%26mark-x%3D120%26mark-y%3D96%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZoPTc2Jnc9OTcyJnR4dD0lNDBrdW5pdCZ0eHQtY29sb3I9JTIzM0EzQzNDJnR4dC1mb250PUhpcmFnaW5vJTIwU2FucyUyMFc2JnR4dC1zaXplPTM2JnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnM9YzBmZTI4Yjg4NjBlYTEyYjA0YmY3NDNlYjFjYjNlNzc%26blend-x%3D120%26blend-y%3D445%26blend-mode%3Dnormal%26txt64%3DaW4g5qCq5byP5Lya56S-44Kr44Kq44OK44OT%26txt-width%3D972%26txt-clip%3Dend%252Cellipsis%26txt-color%3D%25233A3C3C%26txt-font%3DHiragino%2520Sans%2520W6%26txt-size%3D36%26txt-x%3D134%26txt-y%3D546%26s%3Dfa29dfd44ee4906a64750169cb56859a" alt="MySQL 5.7 から 8.0 にしたらテストが激遅になった - Qiita"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4745865833754283247"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://qiita.com/kunit/items/7f5883121a621a775e53" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20231203#bookmark-4745865833754283247" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2023/12/03</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4745865833754283247/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://memorandum-plus.com/2018/05/21/mysql-%E3%81%94%E3%81%8F%E5%8D%98%E7%B4%94%E3%81%AAupdate%E3%81%8C%E3%81%AA%E3%81%9C%E3%81%8B%E9%81%85%E3%81%84%E6%99%82%E3%81%8C%E3%81%82%E3%82%8B/"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://memorandum-plus.com/2018/05/21/mysql-%E3%81%94%E3%81%8F%E5%8D%98%E7%B4%94%E3%81%AAupdate%E3%81%8C%E3%81%AA%E3%81%9C%E3%81%8B%E9%81%85%E3%81%84%E6%99%82%E3%81%8C%E3%81%82%E3%82%8B/" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fmemorandum-plus.com%2F2018%2F05%2F21%2Fmysql-%25E3%2581%2594%25E3%2581%258F%25E5%258D%2598%25E7%25B4%2594%25E3%2581%25AAupdate%25E3%2581%258C%25E3%2581%25AA%25E3%2581%259C%25E3%2581%258B%25E9%2581%2585%25E3%2581%2584%25E6%2599%2582%25E3%2581%258C%25E3%2581%2582%25E3%2582%258B%2F" alt="">MySQL – ごく単純なUPDATEがなぜか遅い時がある | memorandum-plus</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/memorandum-plus.com/2018/05/21/mysql-%E3%81%94%E3%81%8F%E5%8D%98%E7%B4%94%E3%81%AAupdate%E3%81%8C%E3%81%AA%E3%81%9C%E3%81%8B%E9%81%85%E3%81%84%E6%99%82%E3%81%8C%E3%81%82%E3%82%8B/" class="js-keyboard-entry-page-openable" title="MySQL – ごく単純なUPDATEがなぜか遅い時がある | memorandum-plus (2ブックマーク)" data-gtm-click-label="user-bookmark-users">2 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fmemorandum-plus.com%2F" title="『memorandum-plus.com』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> memorandum-plus.com </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">先日不可解な事象に直面しました、ごく単純な1行のUPDATE文が稀に非常に遅くなる時があったのです。稀に、といいますが検証してみたところ、50回実行して1～2回程度の発生頻度。軽く「UPDATE 遅い」などで調べてみたところ、どれにも該当しないように見えました。ググった情報当方の状況といった感じです。うーん、わからん！ということで検証して調査しました。検証方法わたしの環境の具体的な名称などはぼかしますが、問題が発生していた<a data-gtm-click-label="entry-summary-keyword" href="/q/SQL">SQL</a>は、ほぼ以下のようなモノでした UPDATE `ta<a data-gtm-click-label="entry-summary-keyword" href="/q/BL">bl</a>e_name` SET `col_name` = 'ランダムな文字列' WHERE `id` = 'PRIMARYなID' カラム`id`はPRIMARYです、1カラムで一意に特定できるのでクッソ早いはず。検証では’ランダムな文字列’を<a data-gtm-click-label="entry-summary-keyword" href="/q/php">php</a>側で毎回生成し、’PRIMARYなID’は対象を1レコ</p> <a href="https://memorandum-plus.com/2018/05/21/mysql-%E3%81%94%E3%81%8F%E5%8D%98%E7%B4%94%E3%81%AAupdate%E3%81%8C%E3%81%AA%E3%81%9C%E3%81%8B%E9%81%85%E3%81%84%E6%99%82%E3%81%8C%E3%81%82%E3%82%8B/" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/6e247a212b9ba9055f4b4abdd42238cd01860458/height=288;version=1;width=512/https%3A%2F%2Fmemorandum-plus.com%2Fwp-content%2Fplugins%2Fall-in-one-seo-pack%2Fimages%2Fdefault-user-image.png" alt="MySQL – ごく単純なUPDATEがなぜか遅い時がある | memorandum-plus"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4740884632452240655"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://memorandum-plus.com/2018/05/21/mysql-%E3%81%94%E3%81%8F%E5%8D%98%E7%B4%94%E3%81%AAupdate%E3%81%8C%E3%81%AA%E3%81%9C%E3%81%8B%E9%81%85%E3%81%84%E6%99%82%E3%81%8C%E3%81%82%E3%82%8B/" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20231201#bookmark-4740884632452240655" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2023/12/01</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-reaction-tag">パフォーマンス</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4740884632452240655/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://tech.iimon.co.jp/entry/2023/12/01/113000"> <div class="centerarticle-entry is-image-entry-unit"> <h3 class="centerarticle-entry-title"> <a href="https://tech.iimon.co.jp/entry/2023/12/01/113000" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Ftech.iimon.co.jp%2Fentry%2F2023%2F12%2F01%2F113000" alt="">MySQLで全文検索機能を使う際のパフォーマンスについて調査してみた - iimon TECH BLOG</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/tech.iimon.co.jp/entry/2023/12/01/113000" class="js-keyboard-entry-page-openable" title="MySQLで全文検索機能を使う際のパフォーマンスについて調査してみた - iimon TECH BLOG (60ブックマーク)" data-gtm-click-label="user-bookmark-users">60 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Ftech.iimon.co.jp%2F" title="『tech.iimon.co.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> tech.iimon.co.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">こんにちは、CTOの森です。iimonは今回が初のアドベントカレンダー参加です！ <a data-gtm-click-label="entry-summary-keyword" href="/q/%E6%9C%AC">本</a>記事はiimonアドベントカレンダー1日目の記事となります。はじめに検証した環境 <a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>/mecabのインストール大量のデータを入れる 1レコードのINSERTにかかった時間検索してみる検索文字列が「出来事」の場合インデックスなし N-gram(bi-gram) IN NATURAL LANGUAGE MODE IN BOOLEAN MODE MeCab IN NATURAL LANGUAGE MODE IN BOOLEAN MODE 検索文字列が「チューリングはロンドンのリッチモンドに住み」の場合まとめ参照したサイト最後にはじめに今回は<a data-gtm-click-label="entry-summary-keyword" href="/q/mysql">MySQL</a>で全文検索機能を使う際のパフォーマンスについて書こうと思います！全文検索をちゃんと使うのであればElasticsearchやSolrな</p> <a href="https://tech.iimon.co.jp/entry/2023/12/01/113000" class="centerarticle-entry-image" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-thumb"> <img src="https://cdn-ak-scissors.b.st-hatena.com/image/square/52e23dac6dd29b6714ca3c3e5e3c31dbf2942db5/height=288;version=1;width=512/https%3A%2F%2Fogimage.blog.st-hatena.com%2F6801883189062156672%2F6801883189062407818%2F1701409352" alt="MySQLで全文検索機能を使う際のパフォーマンスについて調査してみた - iimon TECH BLOG"> </a> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-4745798132153159343"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://tech.iimon.co.jp/entry/2023/12/01/113000" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20231201#bookmark-4745798132153159343" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2023/12/01</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> <li><a href="/R2M/%E3%83%91%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%B3%E3%82%B9/" data-gtm-click-label="user-reaction-tag">パフォーマンス</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/4745798132153159343/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li class="bookmark-item js-user-bookmark-item js-intent-share-bookmark" data-target-url="https://thinkit.co.jp/series/5588"> <div class="centerarticle-entry "> <h3 class="centerarticle-entry-title"> <a href="https://thinkit.co.jp/series/5588" class="js-clickable-link js-keyboard-openable" target="_blank" rel="noopener" data-gtm-click-label="user-bookmark-title"><img class="centerarticle-entry-favicon" src="https://cdn-ak2.favicon.st-hatena.com/64?url=https%3A%2F%2Fthinkit.co.jp%2Fseries%2F5588" alt="">MySQLマイスターに学べ！即効クエリチューニング</a> </h3> <ul class="centerarticle-entry-data"> <li> <span class="centerarticle-users"> <a href="/entry/s/thinkit.co.jp/series/5588" class="js-keyboard-entry-page-openable" title="MySQLマイスターに学べ！即効クエリチューニング (51ブックマーク)" data-gtm-click-label="user-bookmark-users">51 users</a> </span> </li> <li> <a href="/R2M/?url=https%3A%2F%2Fthinkit.co.jp%2F" title="『thinkit.co.jp』の新着エントリー" data-gtm-click-label="user-bookmark-domain"> thinkit.co.jp </a> </li> <li><a href="/hotentry/it" data-gtm-click-label="user-bookmark-category">テクノロジー</a></li> </ul> <div class="centerarticle-entry-contents"> <p class="centerarticle-entry-summary">Copyright © 2004-2024 Impress Corporation. An Impress Group Company. All rights reserved.</p> </div> </div> <div class="centerarticle-reaction js-user-bookmark-id-container" id="bookmark-286696470"> <div class="centerarticle-reaction-comment js-user-bookmark-comment " data-url="https://thinkit.co.jp/series/5588" data-user-name="R2M"> <a href="/R2M/" data-gtm-click-label="user-reaction-usericon" class="centerarticle-reaction-thumb"> <img src="https://cdn.profile-image.st-hatena.com/users/R2M/profile.png" alt="R2M" title="R2M" class="centerarticle-reaction-image"> </a> <div class="centerarticle-reaction-main"> <span class="centerarticle-reaction-username"><a href="https://b.hatena.ne.jp/R2M/20231130#bookmark-286696470" class="js-anchor-path" data-gtm-click-label="user-reaction-username">R2M</a></span> <span class="centerarticle-reaction-timestamp">2023/11/30</span> <span class="js-private-icon status is-hidden"><img src="/images/v4/public/userpage/icon-private.svg" alt="非公開" width="10px" height="10px"></span> <div class="centerarticle-reaction-main-comment-tags"> <span class="js-comment"></span> <ul class="centerarticle-reaction-tags js-tag-text"> <li><a href="/R2M/mysql/" data-gtm-click-label="user-reaction-tag">mysql</a></li> </ul> </div> <div class="centerarticle-reaction-foot"> <div class="centerarticle-reaction-meta"> <span class="comment-permalink js-comment-permalink"> <a href="/entry/286696470/comment/R2M" data-gtm-click-label="user-reaction-permalink" rel="nofollow">リンク</a> </span> <span class="list-star-container js-list-star-container"></span> <span class="twitter-click js-short-url-clicks"></span> </div> <ul class="centerarticle-reaction-menu"> <li class="js-add-star-container add-star-container"></li> </ul> </div> </div> </div> </div> <ul class="centerarticle-reaction-following js-user-following-bookmarks-icon"> </ul> <div class="js-user-following-bookmarks-detail is-hidden"> </div> </li> <li> <div class="centerarticle-pager"> <span class="centerarticle-waiting js-read-more-waiting is-hidden"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/loading@2x.gif" alt="残りのブックマークを読み込んでいます" width="16" height="16" /></span> <span>1</span> <span><a href="/R2M/mysql/?page=2">2</a></span> <span><a href="/R2M/mysql/?page=3">3</a></span> <span><a href="/R2M/mysql/?page=4">4</a></span> <span><a href="/R2M/mysql/?page=5">5</a></span> <span class="centerarticle-pager-next"><a href="/R2M/mysql/?page=2">次のページ</a></span> </div> </li> </ul> </div> </div> <script type="text/javascript"> // ---------------- dfp section ---------------- var valve = valve || []; valve.push(function(v) { v.defineDFPSlot({ unit: '/4374287/b_pc_o_18_3025_0_no', sizes: [[300,250]], slotId: 'user-sidebar-ad-top' }); v.defineDFPSlot({ unit: '/4374287/b_pc_o_19_3060_0_no', sizes: [[300,600],[300,250]], slotId: 'user-sidebar-ad-bottom' }); v.sealDFPSlots(); }); </script> <script> var valve = window.valve || []; valve.push(function(v) { var pageKeyValues = {}; if (document.cookie.split(';').some(function(item) { return item.indexOf('202011_guest_status=register_incomplete') >= 0})) { pageKeyValues.bookmark_status = 'register_incomplete'; } v.config({ pageKeyValues: pageKeyValues, content: { result: "ng" }, service: 'bookmark' }); }); </script> <script src="https://cdn.pool.st-hatena.com/valve/valve.js" async></script> <div class="right-container"> <div id="user-sidebar-ad-top" class="centerarticle-aside-ad"></div> <section class="centerarticle-aside-section"> <div class="centerarticle-aside-info"> <h3 class="centerarticle-aside-info-title">お知らせ</h3> <ul class="centerarticle-aside-info-list"> <li class="centerarticle-aside-info-item"> <a href="https://bookmark.hatenastaff.com/entry/transparencyreport_251q?utm_source=user_page_side_column&utm_medium=official_announcement&utm_campaign=transparencyreport_251q" target="_blank"> <p class="centerarticle-aside-info-category">透明性レポート</p> <h4 class="centerarticle-aside-info-item-title">はてなブックマーク透明性レポート（2024年8月～2024年10月）</h4> <time class="centerarticle-aside-info-item-time">2024/11/22</time> </a> </li> <li class="centerarticle-aside-info-item"> <a href="https://bookmark.hatenastaff.com/entry/transparencyreport_244q?utm_source=user_page_side_column&utm_medium=official_announcement&utm_campaign=transparencyreport_244q" target="_blank"> <p class="centerarticle-aside-info-category">透明性レポート</p> <h4 class="centerarticle-aside-info-item-title">はてなブックマーク透明性レポート（2024年5月～2024年7月）</h4> <time class="centerarticle-aside-info-item-time">2024/11/22</time> </a> </li> <li class="centerarticle-aside-info-item"> <a href="https://bookmark.hatenastaff.com/entry/2024/11/19/120854?utm_source=user_page_side_column&utm_medium=official_announcement&utm_campaign=2024%2F11%2F19%2F120854" target="_blank"> <p class="centerarticle-aside-info-category">ランキング</p> <h4 class="centerarticle-aside-info-item-title">今週のはてなブックマーク数ランキング（2024年11月第3週）</h4> <time class="centerarticle-aside-info-item-time">2024/11/19</time> </a> </li> </ul> <div class="enterarticle-aside-info-readmore"> <a href="https://bookmark.hatenastaff.com/?utm_source=user_page_side_column&utm_medium=official_announcement&utm_campaign=readmore" class="enterarticle-aside-info-readmore-button" target="_blank">もっと読む</a> </div> </div> </section> <section class="centerarticle-aside-section"> <h3 class="centerarticle-aside-title">公式Twitter</h3> <ul class="centerarticle-aside-twitter"> <li><a href="https://twitter.com/HatenaBookmark" target="_blank" rel="noopener" data-gtm-click-label="user-officialTwitter-name">@HatenaBookmark</a><p>リリース、障害情報などのサービスのお知らせ</p></li> <li><a href="https://twitter.com/hatebu" target="_blank" rel="noopener" data-gtm-click-label="user-hotentryTwitter-name">@hatebu</a><p>最新の人気エントリーの配信</p></li> </ul> </section> <div id="user-sidebar-ad-bottom" class="centerarticle-aside-ad"></div> </div> </div> </div> <div class="progress-modal is-hidden js-progress-modal"> <div class="progress-modal-spiner"></div> <div class="progress-modal-message"> <p class="progress-modal-message-text js-progress-message">処理を実行中です</p> <button class="progress-modal-cancel js-cancel-button">中止</button> </div> </div> <div class="message-modal js-message-modal is-hidden auto-hide"> <div class="message-modal-message"> <p class="message-modal-message-text js-message-modal-message-text"></p> <button class="message-modal-btn js-message-modal-close-button">閉じる</button> </div> </div> <div id="keyboard-shortcut-help" class="shortcut-help is-hidden"> <h3 class="shortcut-help-title">キーボードショートカット一覧</h3> <p><span class="shortcut-help-key">j</span>次のブックマーク</p> <p><span class="shortcut-help-key">k</span>前のブックマーク</p> <p><span class="shortcut-help-key">l</span>あとで読む</p> <p><span class="shortcut-help-key">e</span>コメント一覧を開く</p> <p><span class="shortcut-help-key">o</span>ページを開く</p> <button tyle="button" class="shortcut-help-close js-close-button">✕</button> </div> <div class="footer"> <div class="footer-inner"> <div class="footer-inner-group footer-bookmark"> <h2 class="footer-title"><a href="/" data-gtm-label="footer-btop">はてなブックマーク</a></h2> <div class="footer-list-wrapper"> <ul class="footer-list footer-list--pc"> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/all" class="hotentry js-keyboard-openable" data-gtm-label="footerCategories-hotentry">総合</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/general" class="general js-keyboard-openable" data-gtm-label="footerCategories-general">一般</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/social" class="cat-social js-keyboard-openable" data-gtm-label="footerCategories-social">世の中</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/economics" class="cat-economics js-keyboard-openable" data-gtm-label="footerCategories-economics">政治と経済</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/life" class="cat-life js-keyboard-openable" data-gtm-label="footerCategories-life">暮らし</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/knowledge" class="cat-knowledge js-keyboard-openable" data-gtm-label="footerCategories-knowledge">学び</a></li> </ul> <ul class="footer-list footer-list--pc"> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/it" class="cat-it js-keyboard-openable" data-gtm-label="footerCategories-it">テクノロジー</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/entertainment" class="cat-entertainment js-keyboard-openable" data-gtm-label="footerCategories-entertainment">エンタメ</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/game" class="cat-game js-keyboard-openable" data-gtm-label="footerCategories-game">アニメとゲーム</a></li> <li class="footer-list-item js-keyboard-selectable-item"><a href="/hotentry/fun" class="cat-fun js-keyboard-openable" data-gtm-label="footerCategories-fun">おもしろ</a></li> </ul> <ul class="footer-list"> <li class="footer-list-item"><a href="/guide/tools">アプリ・拡張機能</a></li> <li class="footer-list-item"><a href="https://bookmark.hatenastaff.com/">開発ブログ</a></li> <li class="footer-list-item"><a href="/help/">ヘルプ</a></li> <li class="footer-list-item"><a href="https://hatena.zendesk.com/hc/ja/categories/900000153166">お問い合わせ</a></li> <li class="footer-list-item footer-list-item--sp"><a href="/guide/guideline">ガイドライン</a></li> <li class="footer-list-item footer-list-item--sp"><a href="https://policies.hatena.ne.jp/rule">利用規約</a></li> <li class="footer-list-item footer-list-item--sp"><a href="https://policies.hatena.ne.jp/privacypolicy-ja">プライバシーポリシー</a></li> <li class="footer-list-item footer-list-item--sp"><a href="https://policies.hatena.ne.jp/cookie-policy">利用者情報の外部送信について</a></li> </ul> <ul class="footer-list footer-list--pc"> <li class="footer-list-item footer-list-item--pc"><a href="/guide/guideline">ガイドライン</a></li> <li class="footer-list-item footer-list-item--pc"><a href="https://policies.hatena.ne.jp/rule">利用規約</a></li> <li class="footer-list-item footer-list-item--pc"><a href="https://policies.hatena.ne.jp/privacypolicy-ja">プライバシーポリシー</a></li> <li class="footer-list-item footer-list-item--pc"><a href="https://policies.hatena.ne.jp/cookie-policy">利用者情報の外部送信について</a></li> </ul> </div> </div> <div class="footer-inner-group footer-bookmark-sns"> <h2 class="footer-title">公式Twitter</h2> <div class="footer-bookmark-list"> <ul class="footer-list"> <li class="footer-list-item"><a href="https://twitter.com/HatenaBookmark" target="_blank" rel="noopener" data-gtm-click-label="footer-officialTwitter-name">公式アカウント</a></li> <li class="footer-list-item"><a href="https://twitter.com/hatebu" target="_blank" rel="noopener" data-gtm-click-label="footer-hotentryTwitter-name">ホットエントリー</a></li> </ul> </div> </div> <div class="footer-inner-group footer-hatena"> <h2 class="footer-title">はてなのサービス</h2> <ul class="footer-list"> <li class="footer-list-item"><a href="https://hatenablog.com/" data-gtm-label="footerServices-blog">はてなブログ</a></li> <li class="footer-list-item"><a href="https://hatenablog.com/guide/pro?plus_via=hatenabookmark_footer&utm_source=hatenabookmark&utm_medium=referral&utm_campaign=hatenabookmark_to_hatenablog_pro&utm_content=hatenabookmark_footer" data-gtm-label="footerServices-blog-pro">はてなブログPro</a></li> <li class="footer-list-item"><a href="https://q.hatena.ne.jp/" data-gtm-label="footerServices-question">人力検索はてな</a></li> <li class="footer-list-item"><a href="http://d.hatena.ne.jp/" data-gtm-label="footerServices-keyword">はてなブログタグ</a></li> <li class="footer-list-item"><a href="http://hatenanews.com/" data-gtm-label="footerServices-hatenanews">はてなニュース</a></li> <li class="footer-list-item"><a href="https://soredoko.jp/" data-gtm-label="footerServices-soredoko">ソレドコ</a></li> </ul> </div> </div> <div class="footer-bottom"> <div class="footer-app"> <ul> <li class="footer-list-item"><a href="https://apps.apple.com/jp/app/hatenabukkumaku/id354976659?mt=8" target="_blank" rel="noopener" data-gtm-click-label="footer-app-ios"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/dl-button/appstore@2x.png" alt="App Storeからダウンロード"></a></li> <li class="footer-list-item"><a href="https://play.google.com/store/apps/details?id=com.hatena.android.bookmark&referrer=utm_source%3Dbookmark_sp%26utm_campaign%3Dbookmark_sp_user&hl=ja" target="_blank" rel="noopener" data-gtm-click-label="footer-app-android"><img src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/images/v4/public/common/dl-button/googleplay@2x.png" alt="Google Playで手に入れよう"></a></li> </ul> </div> <div class="copyright">Copyright © 2005-2024 <a href="http://www.hatena.ne.jp/">Hatena</a>. All Rights Reserved.</div> </div> </div> <div class="modal-overlay"></div> <script type="text/javascript" src="https://b.st-hatena.com/77d2ee6f79ddaf78eb2d198936bae315b6721993/js/v4/bookmark.star.js" async></script> <div class="js-head-notify is-hidden">設定を変更しました<span class="js-head-notify-close-button">x</span></div> </body> </html>

CINXE.COM

[B! mysql] R2Mのブックマーク