-
Notifications
You must be signed in to change notification settings - Fork 15
Problems for capacity test: 1. deadlock 2. low TpmC #84
Comments
Hi, What CPU do you run this on?
I'd guess so, too. It might also be related to RocksDB. Do you use InnoDB or Myrocks as storage engine for the MySQL baseline? |
Hi, Thanks for your quick response.
|
{
"sql": [
"GRANT ALL ON *.* TO root"
]
} Then you can connect with user root without password or certificate. 2. We did the benchmark on an Icelake CPU. Prior generations like your CPU suffer from small EPC size, so performance difference to native MariaDB is expected to be larger. 2.2 That's probably true. |
Hi, @thomasten . I use the manifest like you provided, but I could not connect edb anyway. And the problem mentioned here no longer appear.
|
@thomasten Could you help me at your convenience? |
Hi @zeuson0,
and then initialize it with that manifest
I can connect to it with
Does this work for you? If not, please post any error messages you see. |
Thanks for your response @thomasten.
And edb didn't not post any error. |
Does it make a difference if you run it on another port with
and connect with
? |
I originally used port 3307 to try it because the port was occupied. And I tried port 3306 just now, it caused the same error. |
Try debug mode with
and manifest
Then edb may print something if you try to connect. |
Hi,
I want to test the capacity of EdgelessDB (e.g., throughput). Given open-sourced TPC-C is for innoDB and sysbench does not support certificate authentication, I have to build a testing program myself (BTW, what tool do you use to gain the experimental result, EdgelessDB delivers close to the native performance?), which is finally decided to be built on the TPC-C GitHub repo.
While the testing program works well on my MySQL, the test on EdgelessDB results in:
There are deadlock reports for new order and payment operations through the whole process. (But there is 0 failure, as the final testing report showed. So I guess there is no bug for my program and EdgelessDB, since there is no failure, and possibly just because of the workload is too heavy?)
The values of TpmC for EdgelessDB and my MySQL under the same experimental setting are 3196.839 TpmC and 6860.572 TpmC, respectively.
While I know that there are many possible reasons for the result and have a few plans to evaluate them, it will be my honor if I can know your ideas and opinions about the issues. Hearty thanks for your time and patience : )
The text was updated successfully, but these errors were encountered: