菜单
Generic logic for DBClient executionloop test mode: DatabaseTester.executionLoop() periodic execution and intermediate reporting. Use this skill when modifying long-running tests or scheduled report logic.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Practical guide for adding a new database or middleware engine to DBClient. Use this skill when you need to introduce a new dbType.
Cross-cutting core mechanisms of DBClient: CLI argument parsing, DBConfig, TesterFactory, TestExecutor, and the DatabaseTester interface. Use this skill when modifying generic flows or adding engine registration, validation, or dependencies.
KV / coordination engines in DBClient: Redis, RedisCluster, Redis Sentinel, Camellia-Proxy, Etcd, and Zookeeper. Use this skill when adding, debugging, or modifying such a Tester.
Message-queue engines in DBClient: Kafka, Pulsar, RabbitMQ, and RocketMQ. Use this skill when adding, debugging, or modifying such a Tester.
Relational / JDBC-protocol-compatible engines in DBClient. Covers MySQL-compatible, PostgreSQL-compatible, Oracle, SQLServer, domestic / regulated databases, and analytical databases such as StarRocks, Doris, and ClickHouse. Use this skill when adding, debugging, or modifying such a Tester.
Search / log-retrieval engines in DBClient: Elasticsearch 8.x and OpenSearch. Use this skill when adding, debugging, or modifying such a Tester.
| name | dbclient-testmode-loop |
| description | Generic logic for DBClient executionloop test mode: DatabaseTester.executionLoop() periodic execution and intermediate reporting. Use this skill when modifying long-running tests or scheduled report logic. |
TestExecutor.executeTest()
tester.connect()
tester.executionLoop(connection, query, duration, interval, database, table)
String executionLoop(
DatabaseConnection connection,
String query,
int duration,
int interval,
String database,
String table
);
| Parameter | Default | Description |
|---|---|---|
duration | 60 seconds | Total loop duration |
interval | 1 second | Intermediate report interval; 0 disables intermediate reports |
database | "" | Database name needed by some engines |
table | "" | Table name needed by some engines |
query | "" | Query to execute in loop; some engines may ignore it |
duration seconds.interval seconds.| File | Responsibility |
|---|---|
src/main/java/com/apecloud/dbtester/commons/DatabaseTester.java | executionLoop() interface |
src/main/java/com/apecloud/dbtester/commons/TestExecutor.java | Parameter validation and dispatch |
java -jar build/libs/oneclient-1.0-all.jar \
-h 127.0.0.1 -P 3306 -u root -p password -d test \
-e mysql -t executionloop -q "SELECT 1" -s 60 -I 10
| Symptom | Investigation Point |
|---|---|
| No intermediate reports | Whether interval is set to 0 |
| Ends early | Whether duration is parsed correctly (note that -s is shared with stress) |
| Inaccurate statistics | Whether counters are thread-safe; whether interval boundaries are double-counted |
| Some engines unsupported | Whether that Tester's executionLoop() is fully implemented |
DBConfig.validate() requires duration; sync dbclient-core when changing it.