Sysbench --config-file=config oltp_point_select --tables=32 --table-size=10000000 warmup

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: sysbench --config-file=config oltp_point_select --tables=32 --table-size=10000000 warmup

| username: 会飞的企鹅

[Test Environment for TiDB] Testing
[TiDB Version] 6.5
[Reproduction Path] Sysbench testing TiDB
[Encountered Issues: Phenomenon and Impact]
[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

How to Test TiDB with Sysbench | PingCAP Documentation Center
I followed the official documentation above to test TiDB with Sysbench, but encountered an error during data preheating. Could the experts please help clarify?

| username: wzf0072 | Original post link

Try updating the sysbench version.

| username: 啦啦啦啦啦 | Original post link

Try changing “warmup” to “prepare”.

| username: 会飞的企鹅 | Original post link

The prepare has been executed.

| username: 啦啦啦啦啦 | Original post link

I made a mistake… I have an older version of sysbench. I tried version 1.0.20 and it indeed doesn’t have the warmup option. I suspect it’s a documentation error. Version 1.1.0 does have it, or you can manually warm up the data and collect statistics. For example, SELECT count(pad) from sbtest1 use index(k_1); ANALYZE TABLE sbtest1;