{"action":"created","issue":{"url":"https://api.github.com/repos/akopytov/sysbench/issues/60","repository_url":"https://api.github.com/repos/akopytov/sysbench","labels_url":"https://api.github.com/repos/akopytov/sysbench/issues/60/labels{/name}","comments_url":"https://api.github.com/repos/akopytov/sysbench/issues/60/comments","events_url":"https://api.github.com/repos/akopytov/sysbench/issues/60/events","html_url":"https://github.com/akopytov/sysbench/issues/60","id":173956105,"number":60,"title":"Different results while using parallel_prepare.lua from repo","user":{"login":"ShahriyarR","id":3852029,"avatar_url":"https://avatars.githubusercontent.com/u/3852029?v=3","gravatar_id":"","url":"https://api.github.com/users/ShahriyarR","html_url":"https://github.com/ShahriyarR","followers_url":"https://api.github.com/users/ShahriyarR/followers","following_url":"https://api.github.com/users/ShahriyarR/following{/other_user}","gists_url":"https://api.github.com/users/ShahriyarR/gists{/gist_id}","starred_url":"https://api.github.com/users/ShahriyarR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ShahriyarR/subscriptions","organizations_url":"https://api.github.com/users/ShahriyarR/orgs","repos_url":"https://api.github.com/users/ShahriyarR/repos","events_url":"https://api.github.com/users/ShahriyarR/events{/privacy}","received_events_url":"https://api.github.com/users/ShahriyarR/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/akopytov/sysbench/labels/need%20feedback","name":"need feedback","color":"5319e7"},{"url":"https://api.github.com/repos/akopytov/sysbench/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-30T08:13:41Z","updated_at":"2016-09-01T12:59:02Z","closed_at":null,"body":"Hi dear all,\r\nUsing parallel_prepare.lua after installing using yum:\r\n```\r\n[root@ps-pxb-5 PTB]# sysbench --test=/usr/share/doc/sysbench/tests/db/parallel_prepare.lua --mysql-socket=/tmp/mysql_sandbox5713.sock --mysql-user=root --mysql-password=msandbox --oltp-tables-count=16 --oltp-table-size=100000 --num-threads=2 --mysql-table-engine=innodb run\r\nsysbench 0.5:  multi-threaded system evaluation benchmark\r\n\r\nRunning the test with following options:\r\nNumber of threads: 2\r\nRandom number generator seed is 0 and will be ignored\r\n\r\n\r\nInitializing worker threads...\r\n\r\nthread prepare1\r\nCreating table 'sbtest2'...\r\nthread prepare0\r\nCreating table 'sbtest1'...\r\nInserting 100000 records into 'sbtest2'\r\nInserting 100000 records into 'sbtest1'\r\nCreating table 'sbtest4'...\r\nCreating table 'sbtest3'...\r\nInserting 100000 records into 'sbtest4'\r\nInserting 100000 records into 'sbtest3'\r\nCreating table 'sbtest6'...\r\nCreating table 'sbtest5'...\r\nInserting 100000 records into 'sbtest6'\r\nInserting 100000 records into 'sbtest5'\r\nCreating table 'sbtest8'...\r\nCreating table 'sbtest7'...\r\nInserting 100000 records into 'sbtest8'\r\nInserting 100000 records into 'sbtest7'\r\nCreating table 'sbtest10'...\r\nCreating table 'sbtest9'...\r\nInserting 100000 records into 'sbtest10'\r\nInserting 100000 records into 'sbtest9'\r\nCreating table 'sbtest12'...\r\nCreating table 'sbtest11'...\r\nInserting 100000 records into 'sbtest12'\r\nInserting 100000 records into 'sbtest11'\r\nCreating table 'sbtest14'...\r\nInserting 100000 records into 'sbtest14'\r\nCreating table 'sbtest13'...\r\nInserting 100000 records into 'sbtest13'\r\nCreating table 'sbtest16'...\r\nInserting 100000 records into 'sbtest16'\r\nCreating table 'sbtest15'...\r\nInserting 100000 records into 'sbtest15'\r\nThreads started!\r\n```\r\n\r\nAnd using parallel_prepare.lua script from cloned repo:\r\n\r\n```\r\n[root@ps-pxb-5 PTB]# sysbench --test=/mnt/sysbench/sysbench/tests/db/parallel_prepare.lua --mysql-socket=/tmp/mysql_sandbox5713.sock --mysql-user=root --mysql-password=msandbox --oltp-tables-count=16 --oltp-table-size=100000 --num-threads=2 --mysql-table-engine=innodb run\r\nsysbench 0.5:  multi-threaded system evaluation benchmark\r\n\r\nRunning the test with following options:\r\nNumber of threads: 2\r\nRandom number generator seed is 0 and will be ignored\r\n\r\n\r\nInitializing worker threads...\r\n\r\nthread prepare0\r\nCreating table 'sbtest1'...\r\nThreads started!\r\n\r\nthread prepare1\r\nCreating table 'sbtest2'...\r\nInserting 100000 records into 'sbtest2'\r\nInserting 100000 records into 'sbtest1'\r\nCreating secondary indexes on 'sbtest1'...\r\nCreating secondary indexes on 'sbtest2'...\r\nCreating table 'sbtest3'...\r\nCreating table 'sbtest4'...\r\nInserting 100000 records into 'sbtest3'\r\nInserting 100000 records into 'sbtest4'\r\nCreating secondary indexes on 'sbtest3'...\r\nCreating secondary indexes on 'sbtest4'...\r\nCreating table 'sbtest5'...\r\nCreating table 'sbtest6'...\r\nInserting 100000 records into 'sbtest5'\r\nInserting 100000 records into 'sbtest6'\r\nCreating secondary indexes on 'sbtest5'...\r\nCreating secondary indexes on 'sbtest6'...\r\nCreating table 'sbtest7'...\r\nCreating table 'sbtest8'...\r\nInserting 100000 records into 'sbtest7'\r\nInserting 100000 records into 'sbtest8'\r\nCreating secondary indexes on 'sbtest8'...\r\nCreating secondary indexes on 'sbtest7'...\r\nCreating table 'sbtest10'...\r\nCreating table 'sbtest9'...\r\nInserting 100000 records into 'sbtest10'\r\nInserting 100000 records into 'sbtest9'\r\nCreating secondary indexes on 'sbtest10'...\r\nCreating secondary indexes on 'sbtest9'...\r\nCreating table 'sbtest12'...\r\nCreating table 'sbtest11'...\r\nInserting 100000 records into 'sbtest12'\r\nInserting 100000 records into 'sbtest11'\r\nCreating secondary indexes on 'sbtest12'...\r\nCreating secondary indexes on 'sbtest11'...\r\nCreating table 'sbtest14'...\r\nCreating table 'sbtest13'...\r\nInserting 100000 records into 'sbtest14'\r\nInserting 100000 records into 'sbtest13'\r\nCreating secondary indexes on 'sbtest14'...\r\nCreating secondary indexes on 'sbtest13'...\r\nCreating table 'sbtest16'...\r\nCreating table 'sbtest15'...\r\nInserting 100000 records into 'sbtest16'\r\nInserting 100000 records into 'sbtest15'\r\nCreating secondary indexes on 'sbtest16'...\r\nCreating secondary indexes on 'sbtest15'...\r\nthread prepare1\r\nCreating table 'sbtest2'...\r\nALERT: mysql_drv_query() returned error 1050 (Table 'sbtest2' already exists) for query 'CREATE TABLE sbtest2 (\r\nid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\r\nk INTEGER UNSIGNED DEFAULT '0' NOT NULL,\r\nc CHAR(120) DEFAULT '' NOT NULL,\r\npad CHAR(60) DEFAULT '' NOT NULL,\r\nPRIMARY KEY (id)\r\n) /*! ENGINE = innodb MAX_ROWS = 1000000 */ '\r\nFATAL: failed to execute function `event': 3\r\n```"},"comment":{"url":"https://api.github.com/repos/akopytov/sysbench/issues/comments/244070645","html_url":"https://github.com/akopytov/sysbench/issues/60#issuecomment-244070645","issue_url":"https://api.github.com/repos/akopytov/sysbench/issues/60","id":244070645,"user":{"login":"akopytov","id":1174709,"avatar_url":"https://avatars.githubusercontent.com/u/1174709?v=3","gravatar_id":"","url":"https://api.github.com/users/akopytov","html_url":"https://github.com/akopytov","followers_url":"https://api.github.com/users/akopytov/followers","following_url":"https://api.github.com/users/akopytov/following{/other_user}","gists_url":"https://api.github.com/users/akopytov/gists{/gist_id}","starred_url":"https://api.github.com/users/akopytov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akopytov/subscriptions","organizations_url":"https://api.github.com/users/akopytov/orgs","repos_url":"https://api.github.com/users/akopytov/repos","events_url":"https://api.github.com/users/akopytov/events{/privacy}","received_events_url":"https://api.github.com/users/akopytov/received_events","type":"User","site_admin":false},"created_at":"2016-09-01T12:59:02Z","updated_at":"2016-09-01T12:59:02Z","body":"Hi Shahriyar,\r\n\r\nAs the comment in parallel_prepare.lua says, \"for proper initialization use --max-requests = N, where N is --num-threads\". Can you try it?\r\n\r\nBut generally, parallel_prepare.lua is dumb and needs to fixed."}}
{"actor":{"display_login":"akopytov"}}