MySQL

Database

mysql://

Drive MySQL over its wire protocol: one query per request, with ? placeholders bound safely by the driver and a connection pool per VU via sqlx (only the mysql feature).

Install

$ loadr plugin install mysql

mysql.yaml

plugins:
  - name: mysql          # resolves mysql:// at runtime

scenarios:
  reads:
    executor: constant-arrival-rate
    rate: 100
    duration: 30s
    pre_allocated_vus: 10
    max_vus: 40
    flow:
      - request:
          url: mysql://loadr:loadr@db:3306/loadr
          sql:
            query: SELECT COUNT(*) AS n FROM products WHERE stock > ?
            params: ["0"]
          checks:
            - { type: status, equals: 1 }

thresholds:
  mysql_req_duration: [ "p(95)<300ms" ]
  mysql_reqs: [ "count>0" ]

Metrics: mysql_reqs · mysql_req_duration · mysql_rows.

Read the docs → Watch the demo

Install the plugin, then run a steady query workload against MySQL — see demo #17.

A runtime plugin, never in the binary

Installing pulls a per-platform driver from the signed index, verifies its SHA-256 and checks its ABI before it ever loads. Remove it any time with loadr plugin remove mysql.

← PostgreSQL All plugins Redis →