{
  "app": {
    "name": "Mokabla",
    "url": "https://www.mokabla.com",
    "description": "Real interview questions from companies in Egypt, organised by company. Access is sold per company for 30 days."
  },
  "page": {
    "kind": "question",
    "title": "Question · database-bottlenecks",
    "humanPath": "/en/c/blink22/database-bottlenecks",
    "humanOnly": false
  },
  "identity": {
    "class": "declared",
    "agent": "ClaudeBot",
    "operator": "Anthropic",
    "verified": false,
    "reason": "The user agent is ClaudeBot (Anthropic), which identifies itself as an AI agent.",
    "signals": [
      "Known agent user agent"
    ],
    "claimable": false
  },
  "state": {
    "question": {
      "slug": "database-bottlenecks",
      "title": "Database Bottlenecks",
      "difficulty": "medium",
      "tags": [
        "system-design",
        "technical",
        "backend"
      ],
      "is_free": true,
      "locked": false,
      "frequency": 0.333,
      "last_reported_at": "2025-04-14T13:12:32.106351Z",
      "url": "https://www.mokabla.com/en/c/blink22/database-bottlenecks",
      "agent": {
        "page": "https://www.mokabla.com/agent/en/c/blink22/database-bottlenecks",
        "question": "https://www.mokabla.com/agent/_call/get_question?company=blink22&question=database-bottlenecks"
      },
      "company": {
        "slug": "blink22",
        "name_en": "Blink22"
      },
      "body_md": "## What they ask\nAn open-ended design question in the same long technical session: \"Suppose our bottleneck is writing to the database. What do you do? And if the bottleneck is reading from it?\" There is no fixed answer; you lead and the two interviewers probe whichever direction you take.\n\n## What a strong answer covers\n**First, measure.** Slow query log, `EXPLAIN` on the top offenders, connection pool saturation, lock waits, replication lag. Say this before proposing anything.\n\n**Read bottleneck**\n- Missing or wrong indexes, N+1 queries from the ORM, selecting more columns than needed.\n- Caching at the right layer (application cache, Redis for hot keys, HTTP caching for public content) and the invalidation cost that comes with it.\n- Read replicas and routing reads to them, with the consistency caveat.\n- Denormalising or precomputing views for the heaviest reports.\n\n**Write bottleneck**\n- Batching inserts and cutting per-row round trips; fewer indexes on write-heavy tables.\n- Moving non-critical writes to a queue and processing them asynchronously.\n- Partitioning or sharding by a key that matches the access pattern, and what that breaks (cross-shard joins, transactions).\n- Vertical scaling as the boring first step, and when it stops being enough.\n\n## What they look for\n- Diagnosis before prescription, and trade-offs stated for every lever (cache staleness, replica lag, shard complexity).\n- Concrete examples from something you actually built, even if small.\n- Comfort with being pushed: \"the cache did not help, now what?\" is the normal follow-up.",
      "follow_ups_md": "- The cache hit rate is 40 percent and not improving. What next?\n- How would you migrate to a sharded schema with zero downtime?"
    },
    "paid": false,
    "access": "Question bodies are paid content: a person buys 30 days of access per company (200 EGP or 200 points) in the human app. Agents get titles, tags and difficulty; bodies only for free questions."
  },
  "actions": [
    {
      "name": "get_question",
      "description": "One question with its body. Bodies are paid content unless the question is free.",
      "permission": "allow",
      "sideEffect": "read",
      "input": {
        "company": "string",
        "question": "string"
      },
      "href": "https://www.mokabla.com/agent/_call/get_question?company=blink22&question=database-bottlenecks",
      "ready": true,
      "missing": [],
      "humanPath": "https://www.mokabla.com/en/pricing"
    },
    {
      "name": "list_questions",
      "description": "The questions reported at a company: titles, tags, difficulty, whether each is free or paid.",
      "permission": "allow",
      "sideEffect": "read",
      "input": {
        "company": "string",
        "page": "number?"
      },
      "href": "https://www.mokabla.com/agent/_call/list_questions?company=blink22",
      "ready": true,
      "missing": []
    },
    {
      "name": "buy_access",
      "description": "Buy 30 days of access to a company.",
      "permission": "block",
      "reason": "This action is for people only",
      "ruleId": "R1",
      "sideEffect": "payment",
      "input": {
        "company": "string"
      },
      "href": "https://www.mokabla.com/agent/_call/buy_access?company=blink22",
      "ready": true,
      "missing": [],
      "humanPath": "https://www.mokabla.com/en/pricing"
    },
    {
      "name": "post_comment",
      "description": "Comment on a question.",
      "permission": "block",
      "reason": "This action is for people only",
      "ruleId": "R1",
      "sideEffect": "write",
      "input": {
        "question": "string",
        "text": "string"
      },
      "href": "https://www.mokabla.com/agent/_call/post_comment?question=database-bottlenecks",
      "ready": false,
      "missing": [
        "text"
      ],
      "humanPath": "https://www.mokabla.com/en/companies"
    }
  ],
  "navigate": [
    {
      "label": "This question, as data (free questions only)",
      "href": "https://www.mokabla.com/agent/_call/get_question?company=blink22&question=database-bottlenecks"
    },
    {
      "label": "All questions at this company",
      "href": "https://www.mokabla.com/agent/_call/list_questions?company=blink22"
    },
    {
      "label": "The company page",
      "href": "https://www.mokabla.com/agent/en/c/blink22"
    },
    {
      "label": "Database Bottlenecks · page",
      "href": "https://www.mokabla.com/agent/en/c/blink22/database-bottlenecks"
    }
  ],
  "notices": [
    {
      "severity": "info",
      "message": "This classification is final for the session: it came from a strong signal, not a guess. The human pages are not served to agents."
    },
    {
      "severity": "info",
      "message": "Unverified agents are read-only. Signed requests (Web Bot Auth) are the path to write access."
    }
  ],
  "meta": {
    "requestId": "ag_943c95678dc5",
    "policyVersion": "mokabla-2026-11-03",
    "generatedAt": "2026-11-03T18:40:23.806Z",
    "jsonUrl": "https://www.mokabla.com/agent/en/c/blink22/database-bottlenecks?format=json",
    "manifestUrl": "https://www.mokabla.com/.well-known/agentgate.json",
    "humanUrl": "https://www.mokabla.com/en/c/blink22/database-bottlenecks",
    "humanClaimUrl": "https://www.mokabla.com/agent/_claim/human?to=%2Fen%2Fc%2Fblink22%2Fdatabase-bottlenecks"
  }
}