{"id":120197,"recorded_at":"2026-10-26T14:40:17.477060Z","observed_at":"2026-10-26T14:40:17.477025Z","subject_kind":"source_record","subject":"x402_bazaar:https://saylorinnovations.com/api/kb/mysql-slow-query-index-diagnosis","kind":"listing","method":"baseline/1","body":{"endpoints":[["x402","https://saylorinnovations.com/api/kb/mysql-slow-query-index-diagnosis"]],"name":"Saylor Innovations Guide Library","owner_address":"0xa2a8df0f7caabea4e120a2568118f141569fc8aa","raw":{"accepts":[{"amount":"10000","asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","extra":{"assetTransferMethod":"eip3009","facilitatorOnly":true,"memo":"saylor:mysql-slow-query-index-di","name":"USD Coin","note":"Base settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.","version":"2"},"maxTimeoutSeconds":120,"network":"eip155:8453","payTo":"0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa","scheme":"exact"},{"amount":"10000","asset":"0x3c499c542cEF5E3811e1192ce70d8cC03d5c3359","extra":{"assetTransferMethod":"eip3009","facilitatorOnly":true,"memo":"saylor:mysql-slow-query-index-di","name":"USD Coin","note":"Polygon settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.","version":"2"},"maxTimeoutSeconds":120,"network":"eip155:137","payTo":"0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa","scheme":"exact"},{"amount":"10000","asset":"0xaf88d065e77c8cC2239327C5EDb3A432268e5831","extra":{"assetTransferMethod":"eip3009","facilitatorOnly":true,"memo":"saylor:mysql-slow-query-index-di","name":"USD Coin","note":"Arbitrum settles through an x402 facilitator. Send payload.signature and payload.authorization (EIP-3009); there is no self-submitted path on this network.","version":"2"},"maxTimeoutSeconds":120,"network":"eip155:42161","payTo":"0xA2A8dF0f7CaaBEa4e120a2568118f141569fc8aa","scheme":"exact"},{"amount":"10000","asset":"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v","extra":{"feePayer":"BFK9TLC3edb13K6v4YyH3DwPb5DSUpkWvb7XnqCL9b4F","memo":"saylor:mysql-slow-query-index-di","reference":"Dw37urLjRHbV259uStxo8NKmkQEGhptmGkpwAutwFfJv","session":"eyJhcnRpY2xlSWQiOiJteXNxbC1zbG93LXF1ZXJ5LWluZGV4LWRpYWdub3NpcyIsInJlZmVyZW5jZSI6IkR3Mzd1ckxqUkhiVjI1OXVTdHhvOE5LbWtRRUdocHRtR2twd0F1dHdGZkp2IiwicmVjaXBpZW50IjoiN0xTamZySmY4Zk5zQjhWQTl1N04zV0VuMjVzbVFMcG9iM1N2eVV2WGFjeTciLCJtaW50IjoiRVBqRldkZDVBdWZxU1NxZU0ycU4xeHp5YmFwQzhHNHdFR0drWnd5VER0MXYiLCJtaW5BbW91bnQiOjEwMDAwLCJleHAiOjE3OTI4NDEzOTE3NTB9.DRMN1hNHGp7vGtGMgbmqm7-dGs64HopCDc7R7uFhKFA"},"maxTimeoutSeconds":120,"network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","payTo":"7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7","scheme":"exact"},{"amount":"10000","asset":"Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB","extra":{"feePayer":"BFK9TLC3edb13K6v4YyH3DwPb5DSUpkWvb7XnqCL9b4F","memo":"saylor:mysql-slow-query-index-di","reference":"7N5YXifYUKnkwaztT8YVtV3WEezt7MNRij4u2NvQgT9","session":"eyJhcnRpY2xlSWQiOiJteXNxbC1zbG93LXF1ZXJ5LWluZGV4LWRpYWdub3NpcyIsInJlZmVyZW5jZSI6IjdONVlYaWZZVUtua3dhenRUOFlWdFYzV0VlenQ3TU5SaWo0dTJOdlFnVDkiLCJyZWNpcGllbnQiOiI3TFNqZnJKZjhmTnNCOFZBOXU3TjNXRW4yNXNtUUxwb2IzU3Z5VXZYYWN5NyIsIm1pbnQiOiJFczl2TUZyemFDRVJtSmZyRjRIMkZZRDRLQ29Oa1kxMU1jQ2U4QmVud05ZQiIsIm1pbkFtb3VudCI6MTAwMDAsImV4cCI6MTc5Mjg0MTM5MTc1MH0.L6S8VD1PdGYQmfxLPxG6osv1GzMsGeBx7qY--uJSRFE"},"maxTimeoutSeconds":120,"network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","payTo":"7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7","scheme":"exact"},{"amount":"95650","asset":"So11111111111111111111111111111111111111112","extra":{"memo":"saylor:mysql-slow-query-index-di","native":true,"note":"Native SOL: send lamports with a system transfer, not an SPL transfer. Price is quoted live and this quote expires in 120s.","quotedLamports":"98609","reference":"CabksffFv3tQrzNX83fJfR6W4To1vB7JNdG6wLmfvMSw","session":"eyJhcnRpY2xlSWQiOiJteXNxbC1zbG93LXF1ZXJ5LWluZGV4LWRpYWdub3NpcyIsInJlZmVyZW5jZSI6IkNhYmtzZmZGdjN0UXJ6Tlg4M2ZKZlI2VzRUbzF2QjdKTmRHNndMbWZ2TVN3IiwicmVjaXBpZW50IjoiN0xTamZySmY4Zk5zQjhWQTl1N04zV0VuMjVzbVFMcG9iM1N2eVV2WGFjeTciLCJtaW50IjpudWxsLCJtaW5BbW91bnQiOjk1NjUwLCJleHAiOjE3OTI4NDEzOTE3NTB9.je106aihjGHas4FHG3wHg2-1A_uv5WP2_DE4OUaD0Qc","solUsdPrice":101.41},"maxTimeoutSeconds":120,"network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","payTo":"7LSjfrJf8fNsB8VA9u7N3WEn25smQLpob3SvyUvXacy7","scheme":"exact"}],"description":"Diagnose slow MySQL queries - slow log, EXPLAIN types and Extra flags, composite index order, covering indexes and index-killing patterns","extensions":{"bazaar":{"info":{"input":{"method":"GET","type":"http"},"output":{"example":{"body":"Practical MySQL and MariaDB query tuning: enabling the slow query log, EXPLAIN and EXPLAIN ANALYZE, access types, composite index column order, covering indexes, functions on indexed columns, implicit conversions, OFFSET pagination and connection limits.","c":"Self-Hosting & Infra","id":"mysql-slow-query-index-diagnosis","t":"Diagnose Slow MySQL Queries with EXPLAIN, Indexes and the Slow Log"},"type":"json"}},"schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"method":{"enum":["GET"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method"],"type":"object"},"output":{"properties":{"example":{"properties":{"body":{"description":"Main body text","type":"string"},"c":{"description":"Category of the guide","type":"string"},"id":{"description":"Identifier of the record","type":"string"},"license":{"description":"License identifier","type":"string"},"price":{"description":"Price","type":["number","null"]},"t":{"description":"Title of the guide","type":"string"}},"required":["id","t","c","body"],"type":"object"},"type":{"const":"json","type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"}}},"iconUrl":"https://res.cloudinary.com/bdb-prod/image/upload/c_fill,ar_1:1,w_256,h_256,f_auto,q_auto/v1791811517/bazaar-icons/bc5e2b3d111ebbef.jpg","lastUpdated":"2026-10-24T11:27:51.792Z","quality":{"l30DaysTotalCalls":2,"l30DaysUniquePayers":2,"lastCalledAt":"2026-10-24T11:27:51.448Z"},"resource":"https://saylorinnovations.com/api/kb/mysql-slow-query-index-diagnosis","serviceName":"Saylor Innovations Guide Library","tags":["mysql","mariadb","indexes","explain","performance"],"type":"http","x402Version":2},"source":"x402_bazaar","summary":"Diagnose slow MySQL queries - slow log, EXPLAIN types and Extra flags, composite index order, covering indexes and index-killing patterns"},"body_sha256":"7d1129f061bb62fbf169f7b61ff7f82f1ab085ac27041ea0180809b892ac53a0","prev_id":null,"leaf":"0x8b80e2af288bcf0900a90419ad5e027bb609e0f8c79c4f106e7609c5a12b4fa7","leaf_text":"{\"body\":\"7d1129f061bb62fbf169f7b61ff7f82f1ab085ac27041ea0180809b892ac53a0\",\"id\":120197,\"kind\":\"listing\",\"method\":\"baseline/1\",\"observed_us\":1793025617477025,\"prev\":null,\"subject\":\"x402_bazaar:https://saylorinnovations.com/api/kb/mysql-slow-query-index-diagnosis\",\"subject_kind\":\"source_record\"}","day":{"day":"2026-10-26","leaves":296695,"root":"0xf43e8dcc3d451a4788b26be904c55e8c4c0fa75c9666796c51db38d37e2c0df8","chained":"0x702d5ac508f08b0d1accf36af25822d8e5660367494edd17a642fb61e158a57a","anchor_chain":"eip155:5042002","anchor_tx":"0x495162f8936e19f0039918feebe6c307f327cd6bf8c37219620b1970041fa9ae","anchor_block":69251483},"proof":["0x8b80c3515451d640f3470794ef427eefd5dc28afc93be58b788d6cfc4f7859a3","0x1a17171f6c57953bb881f7921884f901acdd16535edba8a44954d64082cf43c8","0xec8edeaed1c0336e8218bff60087f03235cf89cc929820a0e137e544a68657af","0x244a679ccff5119f1f6390dc069f1d916e38758afe54d2c660b99de9b7ed903d","0xbcabde1858dbb258e4bd79a20a42ad7656c41639ff612dd81a1279932ef32ecb","0x65b7fdae8823ad6ce04780d3a1b5254e3dab5cbddaceb853feec02443baeee8a","0xc41e3b39fdd4c1358f8469ba58d6e65ecdc28394ebadab490994cdd900343d6d","0x14d577f090368c55a0c99d41253938a351b2fd832da71fe61924e090eb72976c","0xf397b73d6779220312418da03886029f39151eedd06f9e9535153fee34e876e7","0x06e192564a33f8e5303c5b3f24c4a64be258d0a0274ef3cfee7f4221b7582bc5","0x7d887da17795602ff54a7a2d145692904e47f8d3ab035b8db85d274d00bc9bfe","0x8cb11bf3bc7d3a6f859c170a167821024ffc4758cdfd2cc96f61a3291aefb637","0xd5ec7ffaecac790d8adfa0620b0a5494758f862e3090b49e556a6ecbad2f0782","0x78ac2b34737774659a6a411f4d10b8ba570d40699d9f277321c3a32ff03d1dc9","0x7eb603d37f0f22dae1ea013e391889906ffc0139ff26e25b044bee38eec8f9b2","0x2b6e23e3624a1b66e1d2298cfbce99a93ce6b13d24a58112a71802d79c5f7a76","0xd21942ae3214eff88e08ab04884fd4b11958b51af9a0741b7668e2d07a2c56c9","0x9a9024edb5069d88a324facb310a5ce8e495214bbaa968f077bede437390194f","0x9b9ce5b74b9bab5121612ef6b64920a8d453cbf311096a423eef9702747e868a"]}