{"id":3758,"date":"2026-11-07T14:50:05","date_gmt":"2026-11-07T05:50:05","guid":{"rendered":"https:\/\/qol-kk.com\/wp2\/?p=3758"},"modified":"2026-11-07T14:50:05","modified_gmt":"2026-11-07T05:50:05","slug":"20261107-plan090","status":"publish","type":"post","link":"https:\/\/qol-kk.com\/wp2\/blog\/2026\/11\/07\/20261107-plan090\/","title":{"rendered":"MySQL \u306e\u30ed\u30c3\u30af\u6a5f\u69cb\u3068\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u5bfe\u7b56 \u5165\u9580"},"content":{"rendered":"

\u6982\u8981<\/h2>\n

Web \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u540c\u6642\u30a2\u30af\u30bb\u30b9\u304c\u5897\u3048\u308b\u3068\u3001\u300cDeadlock found when trying to get lock\u300d\u3084\u300cLock wait timeout exceeded\u300d\u3068\u3044\u3063\u305f\u30a8\u30e9\u30fc\u306b\u906d\u9047\u3057\u307e\u3059\u3002\u3053\u308c\u3089\u306f MySQL\uff08InnoDB\uff09\u306e\u30ed\u30c3\u30af\u6a5f\u69cb\u3092\u7406\u89e3\u3057\u3066\u3044\u306a\u3044\u3068\u539f\u56e0\u304c\u3064\u304b\u3081\u307e\u305b\u3093\u3002<\/p>\n

\u3053\u306e\u8a18\u4e8b\u3067\u306f\u3001InnoDB \u306e\u30ed\u30c3\u30af\u306e\u7a2e\u985e\u3092\u6574\u7406\u3057\u3001\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u304c\u306a\u305c\u8d77\u304d\u308b\u306e\u304b\u3001\u3069\u3046\u5bfe\u7b56\u3059\u308b\u306e\u304b\u3092\u5165\u9580\u8005\u5411\u3051\u306b\u307e\u3068\u3081\u307e\u3059\u3002\u524d\u63d0\u306f MySQL 8.0 \/ InnoDB\u3001\u5206\u96e2\u30ec\u30d9\u30eb\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u306e REPEATABLE READ<\/code> \u3067\u3059\u3002<\/p>\n

\u30ed\u30c3\u30af\u306e\u7a2e\u985e\u3092\u6574\u7406\u3059\u308b<\/h2>\n

\u5171\u6709\u30ed\u30c3\u30af\u3068\u6392\u4ed6\u30ed\u30c3\u30af\uff08S \/ X \u30ed\u30c3\u30af\uff09<\/h3>\n

\u884c\u30ec\u30d9\u30eb\u30ed\u30c3\u30af\u306b\u306f2\u7a2e\u985e\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n
\u7a2e\u985e<\/th>\n\u8a18\u6cd5<\/th>\n\u7528\u9014<\/th>\n\u4ed6\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u53ef\u5426<\/th>\n<\/tr>\n<\/thead>\n
\u5171\u6709\u30ed\u30c3\u30af (S)<\/td>\nSELECT ... FOR SHARE<\/code><\/td>\n\u8aad\u307f\u53d6\u308a\u4e2d\u306b\u5909\u66f4\u3055\u305b\u305f\u304f\u306a\u3044<\/td>\n\u4ed6\u306e S \u306f\u53ef\u3001X \u306f\u4e0d\u53ef<\/td>\n<\/tr>\n
\u6392\u4ed6\u30ed\u30c3\u30af (X)<\/td>\nSELECT ... FOR UPDATE<\/code> \/ UPDATE<\/code> \/ DELETE<\/code><\/td>\n\u66f8\u304d\u8fbc\u307f\u306e\u305f\u3081\u306b\u78ba\u4fdd<\/td>\nS \u3082 X \u3082\u4e0d\u53ef<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
-- \u5171\u6709\u30ed\u30c3\u30af\uff08\u4ed6\u8005\u306e\u66f4\u65b0\u3092\u30d6\u30ed\u30c3\u30af\u3059\u308b\u304c\u3001\u8aad\u307f\u53d6\u308a\u306f\u8a31\u3059\uff09\nSTART TRANSACTION;\nSELECT * FROM accounts WHERE id = 1 FOR SHARE;\n\n-- \u6392\u4ed6\u30ed\u30c3\u30af\uff08\u66f4\u65b0\u524d\u63d0\u3002\u4ed6\u8005\u306e\u8aad\u307f\u66f8\u304d\u3092\u30d6\u30ed\u30c3\u30af\uff09\nSTART TRANSACTION;\nSELECT * FROM accounts WHERE id = 1 FOR UPDATE;<\/pre>\n
\u30a4\u30f3\u30c6\u30f3\u30b7\u30e7\u30f3\u30ed\u30c3\u30af\uff08\u610f\u56f3\u30ed\u30c3\u30af\uff09<\/h3>\n
\u30c6\u30fc\u30d6\u30eb\u30ec\u30d9\u30eb\u306e\u30ed\u30c3\u30af\u3067\u3001\u300c\u3053\u306e\u5148\u3001\u884c\u306b S\/X \u30ed\u30c3\u30af\u3092\u53d6\u308b\u610f\u56f3\u304c\u3042\u308b\u300d\u3053\u3068\u3092\u793a\u3057\u307e\u3059\u3002IS<\/code>\uff08\u610f\u56f3\u5171\u6709\uff09\u3068 IX<\/code>\uff08\u610f\u56f3\u6392\u4ed6\uff09\u304c\u3042\u308a\u3001InnoDB \u304c\u81ea\u52d5\u53d6\u5f97\u3059\u308b\u305f\u3081\u901a\u5e38\u306f\u610f\u8b58\u3057\u307e\u305b\u3093\u3002<\/p>\n
\u30ec\u30b3\u30fc\u30c9\u30fb\u30ae\u30e3\u30c3\u30d7\u30fb\u30cd\u30af\u30b9\u30c8\u30ad\u30fc\u30ed\u30c3\u30af<\/h3>\n
InnoDB \u306e\u30ed\u30c3\u30af\u3067\u6700\u3082\u8aa4\u89e3\u3055\u308c\u3084\u3059\u3044\u90e8\u5206\u3067\u3059\u3002InnoDB \u306f\u300c\u884c\u305d\u306e\u3082\u306e\u300d\u3060\u3051\u3067\u306a\u304f\u300c\u884c\u3068\u884c\u306e\u9699\u9593\uff08\u30ae\u30e3\u30c3\u30d7\uff09\u300d\u3082\u30ed\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n\n
\u7a2e\u985e<\/th>\n\u30ed\u30c3\u30af\u5bfe\u8c61<\/th>\n<\/tr>\n<\/thead>\n
\u30ec\u30b3\u30fc\u30c9\u30ed\u30c3\u30af<\/td>\n\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u7279\u5b9a\u306e1\u30ec\u30b3\u30fc\u30c9<\/td>\n<\/tr>\n
\u30ae\u30e3\u30c3\u30d7\u30ed\u30c3\u30af<\/td>\n\u30ec\u30b3\u30fc\u30c9\u9593\u306e\u9699\u9593\uff08\u5b58\u5728\u3057\u306a\u3044\u7bc4\u56f2\uff09<\/td>\n<\/tr>\n
\u30cd\u30af\u30b9\u30c8\u30ad\u30fc\u30ed\u30c3\u30af<\/td>\n\u30ec\u30b3\u30fc\u30c9\u30ed\u30c3\u30af + \u76f4\u524d\u306e\u30ae\u30e3\u30c3\u30d7<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
REPEATABLE READ<\/code> \u3067\u306f\u30d5\u30a1\u30f3\u30c8\u30e0\u30ea\u30fc\u30c9\u3092\u9632\u3050\u305f\u3081\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u30cd\u30af\u30b9\u30c8\u30ad\u30fc\u30ed\u30c3\u30af\u304c\u4f7f\u308f\u308c\u307e\u3059\u3002\u3053\u308c\u304c\u300c\u66f4\u65b0\u3057\u3066\u3044\u306a\u3044\u7bc4\u56f2\u307e\u3067\u30ed\u30c3\u30af\u3055\u308c\u3066\u5f85\u305f\u3055\u308c\u308b\u300d\u539f\u56e0\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
-- \u8a72\u5f53\u884c\u3060\u3051\u3067\u306a\u304f\u3001id > 100 \u306e\u30ae\u30e3\u30c3\u30d7\u3082\u30ed\u30c3\u30af\u3055\u308c\n-- id=150 \u306e INSERT \u304c\u5f85\u305f\u3055\u308c\u3046\u308b\nSTART TRANSACTION;\nUPDATE orders SET status = 'done' WHERE id > 100;<\/pre>\n
\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u3068\u306f<\/h2>\n
\u8907\u6570\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u4e92\u3044\u306b\u76f8\u624b\u306e\u6301\u3064\u30ed\u30c3\u30af\u306e\u89e3\u653e\u3092\u5f85\u3061\u3001\u6c38\u4e45\u306b\u9032\u3081\u306a\u304f\u306a\u308b\u72b6\u614b\u3067\u3059\u3002InnoDB \u306f\u691c\u77e5\u3059\u308b\u3068\u7247\u65b9\u3092\u81ea\u52d5\u7684\u306b\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u3057\u3066\u30a8\u30e9\u30fc\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n
ERROR 1213 (40001): Deadlock found when trying to get lock;\ntry restarting transaction<\/pre>\n
\u5178\u578b\u7684\u306a\u767a\u751f\u30d1\u30bf\u30fc\u30f3: \u30ed\u30c3\u30af\u9806\u5e8f\u306e\u4ea4\u5dee<\/h3>\n
\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 A \u3068 B \u304c\u3001\u540c\u30582\u884c\u3092\u9006\u306e\u9806\u5e8f<\/strong>\u3067\u30ed\u30c3\u30af\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n
-- \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 A\nSTART TRANSACTION;\nUPDATE accounts SET balance = balance - 100 WHERE id = 1;  -- id=1 \u3092\u30ed\u30c3\u30af\nUPDATE accounts SET balance = balance + 100 WHERE id = 2;  -- id=2 \u5f85\u3061\n\n-- \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3 B\uff08\u307b\u307c\u540c\u6642\uff09\nSTART TRANSACTION;\nUPDATE accounts SET balance = balance - 50 WHERE id = 2;   -- id=2 \u3092\u30ed\u30c3\u30af\nUPDATE accounts SET balance = balance + 50 WHERE id = 1;   -- id=1 \u5f85\u3061<\/pre>\n
A \u306f id=2 \u306e\u89e3\u653e\u3092\u5f85\u3061\u3001B \u306f id=1 \u306e\u89e3\u653e\u3092\u5f85\u3064\u3002\u4e92\u3044\u306b\u76f8\u624b\u5f85\u3061\u3067\u9032\u3081\u307e\u305b\u3093\u3002<\/p>\n
\u539f\u56e0<\/h2>\n
    \n
  1. \u30ed\u30c3\u30af\u53d6\u5f97\u9806\u5e8f\u304c\u4e00\u5b9a\u3067\u306a\u3044<\/strong> \u2014 \u51e6\u7406\u306b\u3088\u3063\u3066\u89e6\u308b\u884c\u306e\u9806\u5e8f\u304c\u9055\u3046<\/li>\n
  2. \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304c\u9577\u3044<\/strong> \u2014 \u9577\u6642\u9593\u30ed\u30c3\u30af\u3092\u4fdd\u6301\u3057\u885d\u7a81\u7a93\u304c\u5e83\u304c\u308b<\/li>\n
  3. \u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u4e0d\u8db3\u306b\u3088\u308b\u904e\u5270\u30ed\u30c3\u30af<\/strong> \u2014 WHERE \u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u306a\u3044\u3068\u5168\u884c\u8d70\u67fb\u3067\u30ed\u30c3\u30af\u7bc4\u56f2\u304c\u5e83\u304c\u308b<\/li>\n
  4. \u30ae\u30e3\u30c3\u30d7\u30ed\u30c3\u30af\u306e\u885d\u7a81<\/strong> \u2014 \u7bc4\u56f2\u66f4\u65b0\u3068 INSERT \u304c\u7af6\u5408\u3059\u308b<\/li>\n<\/ol>\n
    \u5bfe\u5fdc\u65b9\u6cd5<\/h2>\n
    \u5bfe\u7b561: \u30ed\u30c3\u30af\u53d6\u5f97\u9806\u5e8f\u3092\u7d71\u4e00\u3059\u308b<\/h3>\n
    \u8907\u6570\u884c\u3092\u66f4\u65b0\u3059\u308b\u3068\u304d\u306f\u3001\u5e38\u306b\u540c\u3058\u9806\u5e8f\uff08\u4f8b: \u4e3b\u30ad\u30fc\u6607\u9806\uff09\u3067\u30a2\u30af\u30bb\u30b9\u3057\u307e\u3059\u3002\u3053\u308c\u3060\u3051\u3067\u4ea4\u5dee\u578b\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306e\u591a\u304f\u304c\u6d88\u3048\u307e\u3059\u3002<\/p>\n
    START TRANSACTION;\nUPDATE accounts SET balance = balance - 100 WHERE id = 1;\nUPDATE accounts SET balance = balance + 100 WHERE id = 2;  -- \u5e38\u306b id \u6607\u9806\nCOMMIT;<\/pre>\n
    \u5bfe\u7b562: \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3092\u77ed\u304f\u4fdd\u3064<\/h3>\n
    \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5185\u3067\u5916\u90e8 API \u547c\u3073\u51fa\u3057\u3084\u91cd\u3044\u8a08\u7b97\u3092\u3057\u306a\u3044\u3002\u53d6\u3063\u305f\u3089\u6700\u5c0f\u9650\u306e\u66f4\u65b0\u3092\u3057\u3066\u901f\u3084\u304b\u306b COMMIT \u3057\u307e\u3059\u3002<\/p>\n
    \u5bfe\u7b563: \u9069\u5207\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u5f35\u308b<\/h3>\n
    CREATE INDEX idx_orders_user_id ON orders (user_id);<\/pre>\n
    WHERE \u6761\u4ef6\u306e\u30ab\u30e9\u30e0\u306b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u5f35\u308a\u3001\u30ed\u30c3\u30af\u5bfe\u8c61\u3092\u8a72\u5f53\u884c\u306b\u7d5e\u308a\u307e\u3059\u3002<\/p>\n
    \u5bfe\u7b564: \u30ea\u30c8\u30e9\u30a4\u51e6\u7406\u3092\u524d\u63d0\u306b\u3059\u308b<\/h3>\n
    \u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306f\u5b8c\u5168\u306b\u306f\u9632\u3052\u307e\u305b\u3093\u3002\u767a\u751f\u3057\u305f\u3089\u77ed\u3044\u5f85\u6a5f\u5f8c\u306b\u518d\u5b9f\u884c\u3059\u308b\u4ed5\u7d44\u307f\u3092\u30a2\u30d7\u30ea\u5074\u306b\u6301\u305f\u305b\u307e\u3059\u3002<\/p>\n
    function runWithRetry(callable $txn, int $maxRetry = 3): mixed\n{\n    $attempt = 0;\n    while (true) {\n        try {\n            $pdo->beginTransaction();\n            $result = $txn($pdo);\n            $pdo->commit();\n            return $result;\n        } catch (PDOException $e) {\n            $pdo->rollBack();\n            \/\/ 1213: Deadlock, 1205: Lock wait timeout\n            if (in_array($e->errorInfo[1] ?? 0, [1213, 1205], true)\n                && $attempt < $maxRetry) {\n                $attempt++;\n                usleep(100000 * $attempt); \/\/ \u7dda\u5f62\u30d0\u30c3\u30af\u30aa\u30d5\n                continue;\n            }\n            throw $e;\n        }\n    }\n}<\/pre>\n
    \u78ba\u8a8d\u65b9\u6cd5<\/h2>\n
    -- \u76f4\u8fd1\u306e\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306e\u8a73\u7d30\uff08LATEST DETECTED DEADLOCK \u3092\u898b\u308b\uff09\nSHOW ENGINE INNODB STATUS\\G\n\n-- \u73fe\u5728\u306e\u30ed\u30c3\u30af\u3068\u5f85\u3061\u4f9d\u5b58\uff08MySQL 8.0\uff09\nSELECT * FROM performance_schema.data_locks;\nSELECT * FROM performance_schema.data_lock_waits;\n\n-- \u30ed\u30c3\u30af\u5f85\u3061\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\nSELECT @@innodb_lock_wait_timeout;  -- \u30c7\u30d5\u30a9\u30eb\u30c8 50 \u79d2<\/pre>\n
    \u6ce8\u610f\u70b9<\/h2>\n
      \n
    • 1213\uff08\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\uff09\u3068 1205\uff08\u30ed\u30c3\u30af\u5f85\u3061\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\uff09\u306f\u5225\u7269<\/strong>\u3002\u524d\u8005\u306f\u691c\u77e5\u306b\u3088\u308b\u5373\u30ed\u30fc\u30eb\u30d0\u30c3\u30af\u3001\u5f8c\u8005\u306f\u5f85\u3061\u6642\u9593\u8d85\u904e\u3067\u3001\u539f\u56e0\u3082\u5bfe\u51e6\u3082\u7570\u306a\u308a\u307e\u3059\u3002<\/li>\n
    • \u5206\u96e2\u30ec\u30d9\u30eb\u3092 READ COMMITTED<\/code> \u306b\u4e0b\u3052\u308b\u3068\u30ae\u30e3\u30c3\u30d7\u30ed\u30c3\u30af\u304c\u57fa\u672c\u7121\u52b9\u5316\u3055\u308c\u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u304c\u6e1b\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u30d5\u30a1\u30f3\u30c8\u30e0\u30ea\u30fc\u30c9\u3092\u8a31\u5bb9\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002\u8981\u4ef6\u3068\u76f8\u8ac7\u304c\u5fc5\u8981\u3067\u3059\u3002<\/li>\n
    • \u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u3092\u300c0 \u306b\u3059\u308b\u300d\u3053\u3068\u3092\u76ee\u6a19\u306b\u3057\u306a\u3044\u3002\u983b\u5ea6\u3092\u4e0b\u3052\u3064\u3064\u30ea\u30c8\u30e9\u30a4\u3067\u5438\u53ce\u3059\u308b\u8a2d\u8a08\u304c\u73fe\u5b9f\u7684\u3067\u3059\u3002<\/li>\n<\/ul>\n
      \u307e\u3068\u3081<\/h2>\n
        \n
      • InnoDB \u306e\u30ed\u30c3\u30af\u306f S\/X \u30ed\u30c3\u30af\u30fb\u610f\u56f3\u30ed\u30c3\u30af\u30fb\u30ae\u30e3\u30c3\u30d7\u7cfb\u306e3\u5c64<\/li>\n
      • REPEATABLE READ<\/code> \u3067\u306f\u30ae\u30e3\u30c3\u30d7\u30ed\u30c3\u30af\u304c\u50cd\u304d\u3001\u66f4\u65b0\u3057\u3066\u3044\u306a\u3044\u7bc4\u56f2\u307e\u3067\u5f85\u305f\u3055\u308c\u308b\u3053\u3068\u304c\u3042\u308b<\/li>\n
      • \u30c7\u30c3\u30c9\u30ed\u30c3\u30af\u306e\u4e3b\u56e0\u306f\u300c\u30ed\u30c3\u30af\u9806\u5e8f\u306e\u4ea4\u5dee\u300d\u300c\u9577\u3044\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u300d\u300c\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u4e0d\u8db3\u300d<\/li>\n
      • \u5bfe\u7b56\u306f\u9806\u5e8f\u7d71\u4e00\u30fb\u77ed\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u30fb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30fb\u30ea\u30c8\u30e9\u30a4\u306e4\u672c\u67f1<\/li>\n
      • SHOW ENGINE INNODB STATUS<\/code> \u3068 performance_schema.data_locks<\/code> \u3067\u539f\u56e0\u3092\u8ffd\u3048\u308b<\/li>\n<\/ul>\n
        \u307e\u305a\u73fe\u72b6\u3092\u53ef\u8996\u5316\u3057\u3001\u305d\u306e\u3046\u3048\u3067\u8a2d\u8a08\u3067\u885d\u7a81\u3092\u6e1b\u3089\u3059\u2014\u2014\u3053\u306e\u9806\u5e8f\u304c\u9060\u56de\u308a\u306b\u898b\u3048\u3066\u4e00\u756a\u901f\u3044\u5bfe\u51e6\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
        Web \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u540c\u6642\u30a2\u30af\u30bb\u30b9\u304c\u5897\u3048\u308b\u3068\u3001\u300cDeadlock found when trying to get lock\u300d\u3084\u300cLock wait timeout exceeded\u300d\u3068\u3044\u3063\u305f\u30a8\u30e9\u30fc\u306b\u906d\u9047\u3057\u307e\u3059\u3002\u3053\u308c\u3089\u306f MySQL\uff08I\u2026<\/p>\n","protected":false},"author":1,"featured_media":3757,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"","vkexunit_cta_each_option":"","_lightning_design_setting":[],"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[35],"tags":[99,231,410,1162],"class_list":["post-3758","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql-memorandum","tag-mysql","tag-231","tag-410","tag-1162"],"veu_head_title_object":{"title":"","add_site_title":""},"jetpack_publicize_connections":[],"jetpack-related-posts":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/qol-kk.com\/wp2\/wp-content\/uploads\/2026\/11\/20261107-plan090-thumbnail.jpg","_links":{"self":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts\/3758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/comments?post=3758"}],"version-history":[{"count":1,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts\/3758\/revisions"}],"predecessor-version":[{"id":3759,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/posts\/3758\/revisions\/3759"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/media\/3757"}],"wp:attachment":[{"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/media?parent=3758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/categories?post=3758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qol-kk.com\/wp2\/wp-json\/wp\/v2\/tags?post=3758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}