mysql ndb 测试_ndbcluster测试，性格比起innodb来说，还有些差距，不知道是否是我配置有问题呢？...

最新推荐文章于 2024-05-19 02:35:40 发布

Cyber FISH

最新推荐文章于 2024-05-19 02:35:40 发布

阅读量130

点赞数

文章标签： mysql ndb 测试

本文链接：https://blog.csdn.net/weixin_34218582/article/details/114328952

版权

-- ndbcluster 总体 100 0000 次操作

mysqlslap --engine=ndbcluster --auto-generate-sql-write-number=100000 --auto-generate-sql-guid-primary --concurrency=200,400,600 --number-of-queries=1000000 --iterations=2 --number-char-cols=10 --number-int-cols=10 --auto-generate-sql --create-schema=ndb –-commint=1000 --auto-generate-sql-load-type=mixed

Benchmark

Running for engine ndbcluster

Average number of seconds to run all queries: 432.925 seconds

Minimum number of seconds to run all queries: 432.853 seconds

Maximum number of seconds to run all queries: 432.998 seconds

Number of clients running queries: 200

Average number of queries per client: 5000

Benchmark

Running for engine ndbcluster

Average number of seconds to run all queries: 305.912 seconds

Minimum number of seconds to run all queries: 303.713 seconds

Maximum number of seconds to run all queries: 308.111 seconds

Number of clients running queries: 400

Average number of queries per client: 2500

mysqlslap: Cannot run query INSERT INTO t1 VALUES (uuid(),1857037729,502468165,975130342,448587637,935374297,114202904,1877832873,721286010,6487637,787766131,'IbYqBJt21kzOx30PaAMm13BGgp05BHcTs8J3RCyKoxkmsdBQnPChSGx05x5G7ZezZxv02tDqqpSiQg0E55nQLkQIZYQgx4gXubNwSceAQ7ksfkychl2uLL4vtXbqR7','DLad9uDowfngOQHMuq8plLApG3Cklgjz1AS3whrtDWZdwiziZzXALhzTcCDMkpDlzhgvEXgR1E4powYLv3X8dNeDRjRBYYoN5TBKsrnuxsbeozzbvNkYeEl5p5GEdw','djPg3IOi4LQXz6XriQ6IqkORhDYpR2lxlBdgL1MPFpw6vJpTdvfRX3nCHB1cDnZqq3WB4lcBQOIDk7jDvEhQIKXRXY3dBdR1gqCcRggtxq6hphukwR36faZB6coI57','BdpOEGwu9tc8QPhDATYDbCn0NlT3va27CsNI8J4A5gAX5rc7D9KgLzhcdAXYcZfoH26QEASJieioTJvaK8Fh7wHcyg9aDgFNbLppOH06namGlir5qympuvQkRRIZ7P','wifdNvuF1ZqghbMYZ4MBlGz3sQW3zWSvC7YS2IjwrZcZ1qxamKdNScJD3hGuBcqGkEkePRQGtuhmcXCEjpeBQxGLeYFi9xylCaFd1almSRYxqkBZapcsetDHHSrQQp','3WNB7GlsvDBRA1CEQe33WiwjrDBaYTNRzeeymNjhTu1XoDlErp9LN5w6BzgjTvAKPhJB42lZom5crqjaXsvmqjs1iYcBJeYkJroGlZpZBmA2Tlc0TNfJ6XCgwgsFBG','sWzgmk5SHG6JAbweSQ17dzeqfQMNiZXQwM6i6B2GJ9RTkO7Ci0BJrq1MGOmqx9GtYESWHWecXy58M4K4wYFnEHAMho5WpDGLKkkd6EEeCBmQGyM4MesSnujSioqXt6','lDqLrpbxRg856GvTLAz5emzL6h1w4n3p0l2jaWgtApyG5mdIwcNaEMoKvpH0cKhTxkCYEtPGaGYX22qyW5OlSC5FuMFMapjYPwwXhDn7TBeNDKLkQeTmqQ1cp9rFya','fNMbuvhZ2Akhay1naRPv58L7c2GRI62pTGHFCyoE8OvaEpMo8fjEnxDOzLj9Rdzwu8366jC670hMpvApam3Ej8WaTDkwrjkdjnbpMnvWnSsSFuIiYDw7MQirXQgM1O','rk4QPQECwthgEoROWzTQ7rkhb877W0XEcRg1umDiYmNmbq25hXOgF0Li8SpXKClwgHxQ438cpNEG5GEnnWR2MhkX9PuMeXIAo8ck3cKk0Q15i7kWd4Ozl1MmQ884fJ')

ERROR : Lock wait timeout exceeded; try restarting transaction