{"id":3392,"date":"2025-08-12T15:51:41","date_gmt":"2025-08-12T07:51:41","guid":{"rendered":"https:\/\/199604.com\/?p=3392"},"modified":"2025-08-12T15:51:41","modified_gmt":"2025-08-12T07:51:41","slug":"%e9%ba%92%e9%ba%9fv10-benchmarksql5-1%e9%83%a8%e7%bd%b2","status":"publish","type":"post","link":"https:\/\/199604.com\/3392","title":{"rendered":"\u9e92\u9e9fv10 BenchmarkSQL5.1\u90e8\u7f72"},"content":{"rendered":"

\u9e92\u9e9fv10 BenchmarkSQL5.1\u90e8\u7f72<\/h1>\n

\u73af\u5883<\/h2>\n

\u5de5\u5177\u7248\u672c\uff1abenchmarksql-5.1
\n\u8fbe\u68a6\u7248\u672c\uff1adm8
\n\u7cfb\u7edf\u7248\u672c\uff1aKylin Linux Advanced Server V10<\/p>\n

\u5b89\u88c5benchmarkSQL5.1<\/h2>\n
#\u5b89\u88c5\u4f9d\u8d56\u5305\nyum install gcc glibc-headers gcc-c++ gcc-gfortran readline-devel  libXt-devel pcre-devel libcurl libcurl-devel -y\nyum install ncurses ncurses-devel autoconf automake zlib zlib-devel bzip2 bzip2-devel xz-devel -y\n\n# \u5b89\u88c5jdk\nrpm -iv jdk-11.0.24_linux-aarch64_bin.rpm\n\n# \u5b89\u88c5ant\ntar -xzvf apache-ant-1.10.15-bin.tar.gz -C \/usr\/local\nvim \/etc\/profile\nexport ANT_HOME=\/usr\/local\/apache-ant-1.10.15\nexport PATH=$PATH:$ANT_HOME\/bin\nsource \/etc\/profile\n\n\n# \u7f16\u8bd1\u5b89\u88c5R\u8bed\u8a00\nyum install pango-devel pango libpng-devel cairo cairo-devel -y\ntar -zxf R-3.6.3.tar.gz\ncd R-3.6.3\n.\/configure && make && make install\n\n\n#\u7f16\u8bd1\u5b89\u88c5htop\nunzip htop-3.3.0.zip\ncd htop-3.3.0\n.\/autogen.sh && .\/configure && make && make install\n##########\nwget https:\/\/hisham.hm\/htop\/releases\/2.2.0\/htop-2.2.0.tar.gz\ntar -zxvf htop-2.2.0.tar.gz\ncd htop-2.2.0\/\n.\/configure && make && make install\n\n\n#\u68c0\u67e5\u5b89\u88c5\u60c5\u51b5\n[root@kescs01 R-3.6.3]# java -version\njava version \"11.0.24\" 2024-07-16 LTS\nJava(TM) SE Runtime Environment 18.9 (build 11.0.24+7-LTS-271)\nJava HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.24+7-LTS-271, mixed mode)\n[root@kescs01 R-3.6.3]# ant -version\nApache Ant(TM) version 1.10.15 compiled on August 25 2024\n[root@kescs01 R-3.6.3]# \n[root@kescs01 R-3.6.3]# htop --version\nhtop 2.2.0 - (C) 2004-2025 Hisham Muhammad\nReleased under the GNU GPL.\n\n[root@kescs01 R-3.6.3]# \n[root@kescs01 R-3.6.3]# R --version\nR version 3.6.3 (2020-02-29) -- \"Holding the Windsock\"\nCopyright (C) 2020 The R Foundation for Statistical Computing\nPlatform: aarch64-unknown-linux-gnu (64-bit)\n\nR is free software and comes with ABSOLUTELY NO WARRANTY.\nYou are welcome to redistribute it under the terms of the\nGNU General Public License versions 2 or 3.\nFor more information about these matters see\nhttps:\/\/www.gnu.org\/licenses\/.\n\n<\/code><\/pre>\n
\u914d\u7f6e\u8fbe\u68a6\u652f\u6301<\/h3>\n
\u4e0b\u8f7dbenchmarkSQL<\/code>\u5730\u5740\uff1ahttps:\/\/github.com\/petergeoghegan\/benchmarksql\/tree\/master<\/code><\/p>\n
benchmarksql\u9ed8\u8ba4\u4e0d\u652f\u6301\u8fbe\u68a6\uff0c\u7f16\u8bd1\u524d\u9700\u8981\u4fee\u6539\u4e24\u4e2a\u914d\u7f6e\u6587\u4ef6<\/p>\n
# \u89e3\u538b\u540e\u8fdb\u5165benchmarksql\u76ee\u5f55\nunzip benchmarksql-master.zip\n\n# src\/client\/jTPCC.java\u6587\u4ef6\u4e2d\u6dfb\u52a0\u5982\u4e0b\u5185\u5bb9\nif (iDB.equals(\"firebird\"))\n    dbType = DB_FIREBIRD;\nelse if (iDB.equals(\"oracle\"))\n    dbType = DB_ORACLE;\nelse if (iDB.equals(\"postgres\"))\n    dbType = DB_POSTGRES;\nelse if (iDB.equals(\"dm\"))\n    dbType = DB_UNKNOWN;\n\n# run\/funcs.sh\u6587\u4ef6\u4e2d\u6dfb\u52a0\u5982\u4e0b\u5185\u5bb9\nfunction setCP()\n{\n    case \"$(getProp db)\" in\n    firebird)\n        cp=\"..\/lib\/firebird\/*:..\/lib\/*\"\n        ;;\n    oracle)\n        cp=\"..\/lib\/oracle\/*\"\n        if [ ! -z \"${ORACLE_HOME}\" -a -d ${ORACLE_HOME}\/lib ] ; then\n        cp=\"${cp}:${ORACLE_HOME}\/lib\/*\"\n        fi\n        cp=\"${cp}:..\/lib\/*\"\n        ;;\n    postgres)\n        cp=\"..\/lib\/postgres\/*:..\/lib\/*\"\n        ;;\n    dm)\n        cp=\"..\/lib\/dm\/*:..\/lib\/*\"\n        ;;    \n    esac\n    myCP=\".:${cp}:..\/dist\/*\"\n    export myCP\n}\n<\/code><\/pre>\n
\"image-20250812154342769\"<\/div><\/p>\n
\"image-20250812154410438\"<\/div><\/p>\n
\u66ff\u6362JDBC\u9a71\u52a8<\/h3>\n
mkdir -p \/usr\/local\/src\/benchmarksql-master\/lib\/dm\ncp \/home\/dmdba\/dmdbms\/drivers\/jdbc\/DmJdbcDriver*.jar \/usr\/local\/src\/benchmarksql-master\/lib\/dm\n[root@localhost.localdomain:\/root\/benchmarksql5.1-master\/lib\/dm]# ls -l\n\u603b\u7528\u91cf 6336\n-rwxr-xr-x 1 root root 1618183  8\u6708 12 15:46 DmJdbcDriver11.jar\n-rwxr-xr-x 1 root root 1620655  8\u6708 12 15:46 DmJdbcDriver6.jar\n-rwxr-xr-x 1 root root 1619913  8\u6708 12 15:46 DmJdbcDriver7.jar\n-rwxr-xr-x 1 root root 1618261  8\u6708 12 15:46 DmJdbcDriver8.jar\n<\/code><\/pre>\n
\u7f16\u8bd1<\/h3>\n
#\u4f7f\u7528ant\u7f16\u8bd1BenchmarkSQL\n[root@kescs01 benchmarksql-master]# ant\nBuildfile: \/usr\/local\/src\/benchmarksql-master\/build.xml\ninit:\ncompile:\n    [javac] Compiling 11 source files to \/usr\/local\/src\/benchmarksql-master\/build\ndist:\n      [jar] Building jar: \/usr\/local\/src\/benchmarksql-master\/dist\/BenchmarkSQL-6.devel.jar\nBUILD SUCCESSFUL\nTotal time: 1 second\n\n<\/code><\/pre>\n
\u53c2\u8003<\/h2>\n
1.https:\/\/eco.dameng.com\/community\/article\/20240419141047S3X2PJBNKG4S1IBXBO<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"
\u9e92\u9e9fv10 BenchmarkSQL5.1\u90e8\u7f72 \u73af\u5883 \u5de5\u5177\u7248\u672c\uff1abenchmarksql-5.1 \u8fbe\u68a6\u7248\u672c\uff1ad […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[260],"tags":[565],"class_list":["post-3392","post","type-post","status-publish","format-standard","hentry","category-linux","tag-benchmarksql"],"_links":{"self":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/3392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/comments?post=3392"}],"version-history":[{"count":1,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/3392\/revisions"}],"predecessor-version":[{"id":3393,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/posts\/3392\/revisions\/3393"}],"wp:attachment":[{"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/media?parent=3392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/categories?post=3392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/199604.com\/wp-json\/wp\/v2\/tags?post=3392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}