I ran benchmark but got trapped in a trouble, error message would be pasted followed.

[polardb]

I ran benchmark but got trapped in a trouble, error message would be pasted followed.

[adzfolc]

Yesterday I faced up with the same question, i tried several ways while none of them be useful:

[adzfolc]

PolardbX topology yml

Server 220 info

Server 221 info

Server 222 info

[earayu]

"foreign key" is not supported by now.

PolarDB-X didn't ban this kind of syntax, it's a bug. Will fix it later.

To solve your problem, you can cancel the DDL JOB by modifying the metadata.
Replace the question mark by actual job_id, you can get it from: show ddl .

/*+TDDL:node('__META_DB__')*/update ddl_engine set supported_commands=3 where job_id = ?;
/*+TDDL:node('__META_DB__')*/update ddl_engine_task set state='READY' where name = 'AlterTablePhyDdlTask' and job_id = ?;
cancel ddl ?;

[adzfolc]

Does PolarX support sysbench gramma?

[agapple]

You can refer to the test steps of TPC-C

Benchmarsksql does not support mysql protocol by default, and some modifications need to be made. You can download our version of benchmarsksql, including table definitions tpcc.tar.gz