MYSQL教程之How to Install Orabm

MySQLAB公司的一个高级开发者者表示，“这个特点使得MySQL可以根据你当前的系统的需要来进行调整。”

原文链接:


http://www.eygle.com/special/How.to.Install.Orabm.TPC.htm

1.起首下载orabm包

你能够从以下地点下载:

http://www.linxcel.co.uk/orabm/orabm.tar

也能够从当地下载.



[gqgai@eyglegqgai]$wgethttp://www.linxcel.co.uk/orabm/orabm.tar--17:46:55--http://www.linxcel.co.uk/orabm/orabm.tar=>`orabm.tarResolvingwww.linxcel.co.uk...done.Connectingtowww.linxcel.co.uk[212.227.127.109]:80...connected.HTTPrequestsent,awaitingresponse...200OKLength:1,280,000[application/x-tar]100%[========================================================================================>]1,280,00026.53K/sETA00:0017:47:43(26.53KB/s)-`orabm.tarsaved[1280000/1280000]

2.检察相干文件



$tar-xvf*.tarxorabm,0bytes,0tapeblocksxorabm/src,0bytes,0tapeblocksxorabm/src/orabmload.pc,24200bytes,48tapeblocksxorabm/src/orabm.c,9346bytes,19tapeblocksxorabm/src/init.ora,1442bytes,3tapeblocksxorabm/src/BUILD_FROM_SOURCE.txt,863bytes,2tapeblocksxorabm/install,0bytes,0tapeblocksxorabm/install/orabm_analyze.sql,1068bytes,3tapeblocksxorabm/install/orabm_cache.sql,1116bytes,3tapeblocksxorabm/install/orabm_ind.sql,1124bytes,3tapeblocksxorabm/install/orabm_query_cache.sql,497bytes,1tapeblocksxorabm/install/orabm_serverside_stress.sql,8528bytes,17tapeblocksxorabm/install/orabm_tab.sql,2321bytes,5tapeblocksxorabm/install/orabm_tab_rm.sql,197bytes,1tapeblocksxorabm/install/orabm_user.sql,233bytes,1tapeblocksxorabm/bin,0bytes,0tapeblocksxorabm/bin/orabm_tps.awk,182bytes,1tapeblocksxorabm/bin/orabm_tps.sh,70bytes,1tapeblocksxorabm/bin/solaris,0bytes,0tapeblocksxorabm/bin/solaris/orabmload,85940bytes,168tapeblocksxorabm/bin/solaris/orabm,53140bytes,104tapeblocksxorabm/bin/linux,0bytes,0tapeblocksxorabm/bin/linux/orabm,42332bytes,83tapeblocksxorabm/bin/linux/orabmload,50741bytes,100tapeblocksxorabm/bin/orabm.linuxd2.log,559bytes,2tapeblocksxorabm/bin/windows,0bytes,0tapeblocksxorabm/bin/windows/orabm.exe,196653bytes,385tapeblocksxorabm/bin/windows/orabmload.exe,233525bytes,457tapeblocksxorabm/orabm.pdf,239954bytes,469tapeblocksxorabm/orabm.htm,200488bytes,392tapeblocksxorabm/orabm_files,0bytes,0tapeblocksxorabm/orabm_files/image001.jpg,46143bytes,91tapeblocksxorabm/orabm_files/image002.jpg,8437bytes,17tapeblocksxorabm/orabm_files/_vti_cnf,0bytes,0tapeblocksxorabm/orabm_files/_vti_cnf/image002.jpg,724bytes,2tapeblocksxorabm/orabm_files/_vti_cnf/image001.jpg,725bytes,2tapeblocksxorabm/orabm_files/_vti_cnf/image003.gif,699bytes,2tapeblocksxorabm/orabm_files/_vti_cnf/editdata.mso,708bytes,2tapeblocksxorabm/orabm_files/_vti_cnf/filelist.xml,707bytes,2tapeblocksxorabm/orabm_files/_vti_cnf/header.htm,1264bytes,3tapeblocksxorabm/orabm_files/_vti_cnf/.fp_folder_info,58bytes,1tapeblocksxorabm/orabm_files/editdata.mso,2976bytes,6tapeblocksxorabm/orabm_files/filelist.xml,289bytes,1tapeblocksxorabm/orabm_files/image003.gif,14667bytes,29tapeblocksxorabm/orabm_files/header.htm,4705bytes,10tapeblocks$lsorabmorabm.tar$cdorabm$lsbininstallorabm.htmorabm.pdforabm_filessrc$lsbininstallorabm.htmorabm.pdforabm_filessrc$cdinstall$lsorabm_analyze.sqlorabm_ind.sqlorabm_serverside_stress.sqlorabm_tab_rm.sqlorabm_cache.sqlorabm_query_cache.sqlorabm_tab.sqlorabm_user.sql



注重:缺省的orabm测试用用户会创建在tools表空间,假如你想把数据放在其他表空间能够修正orabm_user.sql来调剂.

3.安装的步骤以下:

#

Operation

Command

1

createtheORABMuser(assumesTOOLStablespace,TEMPtemporarytablespace)

sqlplussystem/pwd@orabm_user

2

createthetables

sqlplussystem/pwd@orabm_tab

3

loadthedata

$orabmloadWarehouses1

4

createtheindexes

sqlplussystem/pwd@orabm_ind

5

analyzethetablesandindexes

sqlplussystem/pwd@orabm_analyze

6

createthestress-testPL/SQLprocedures

sqlplussystem/pwd@orabm_serverside_stress

7

cachethetableandindexdataintheSGA

sqlplussystem/pwd@orabm_cache

4.安装日记及以下



$sqlplus"/assysdba"@orabm_userSQL*Plus:Release9.2.0.4.0-ProductiononSatSep2517:55:402004Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-ProductionUsercreated.Grantsucceeded.Useraltered.Useraltered.Revokesucceeded.DisconnectedfromOracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-Production$sqlplus"/assysdba"@orabm_tabSQL*Plus:Release9.2.0.4.0-ProductiononSatSep2517:55:562004Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-ProductionTablecreated.Tablecreated.Tablecreated.Tablecreated.Tablecreated.Tablecreated.Tablecreated.Tablecreated.Tablecreated.DisconnectedfromOracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-Production$cd..$lsbininstallorabm.htmorabm.pdforabm_filessrc$cdbin$lslinuxorabm.linuxd2.logorabm_tps.awkorabm_tps.shsolariswindows$cdsolaris$lsorabmorabmload$./orabmloadWarehouse1ld.so.1:./orabmload:fatal:/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0:wrongELFclass:ELFCLASS64Killed$LD_LIBRARY_PATH=${ORACLE_HOME}/lib32:${LD_LIBRARY_PATH}exportLD_LIBRARY_PATH$./orabmloadWarehouses1ConnectedtoORACLEasuser:ORABMusingtimestamp=20040925181524TPCCDataLoadStarted...LoadingItem....................20000....................40000....................60000....................80000....................100000ItemDone.LoadingWarehouseLoadingStockWid=1....................20000....................40000....................60000....................80000....................100000StockDone.LoadingDistrictLoadingCustomerforDID=1,WID=1...CustomerDone.LoadingCustomerforDID=2,WID=1...CustomerDone.LoadingCustomerforDID=3,WID=1...CustomerDone.LoadingCustomerforDID=4,WID=1...CustomerDone.LoadingCustomerforDID=5,WID=1...CustomerDone.LoadingCustomerforDID=6,WID=1...CustomerDone.LoadingCustomerforDID=7,WID=1...CustomerDone.LoadingCustomerforDID=8,WID=1...CustomerDone.LoadingCustomerforDID=9,WID=1...CustomerDone.LoadingCustomerforDID=10,WID=1...CustomerDone.LoadingOrdersforD=1,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=2,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=3,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=4,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=5,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=6,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=7,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=8,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=9,W=1.1000.2000.3000OrdersDone.LoadingOrdersforD=10,W=1.1000.2000.3000OrdersDone....DATALOADINGCOMPLETEDSUCCESSFULLY.$cd../../install$lsorabm_analyze.sqlorabm_ind.sqlorabm_serverside_stress.sqlorabm_tab_rm.sqlorabm_cache.sqlorabm_query_cache.sqlorabm_tab.sqlorabm_user.sql$sqlplus"/assysdba"@orabm_indSQL*Plus:Release9.2.0.4.0-ProductiononSatSep2518:31:052004Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-ProductionDOC>*DOC>*sameindexesasusedbyOraclerecordbreaking32-CPUDOC>*RACTPC-CbenchmarkonLinux-Sept2002DOC>*DOC>*GeoffIngram(geoff@dbcool.com)DOC>*/Sessionaltered.Indexcreated.Indexcreated.Indexcreated.Indexcreated.Indexcreated.Indexcreated.Indexcreated.Indexcreated.Indexcreated.Indexcreated.DisconnectedfromOracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-Production$sqlplus"/assysdba"@orabm_analyzeSQL*Plus:Release9.2.0.4.0-ProductiononSatSep2518:32:172004Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-ProductionSessionaltered.Tableanalyzed.Tableanalyzed.Tableanalyzed.Tableanalyzed.Tableanalyzed.Tableanalyzed.Tableanalyzed.Tableanalyzed.Tableanalyzed.Indexanalyzed.Indexanalyzed.Indexanalyzed.Indexanalyzed.Indexanalyzed.Indexanalyzed.Indexanalyzed.Indexanalyzed.Indexanalyzed.Indexanalyzed.DisconnectedfromOracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-Production$sqlplus"/assysdba"@orabm_serverside_stressSQL*Plus:Release9.2.0.4.0-ProductiononSatSep2518:35:502004Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-ProductionDOC>*DOC>*v2.0DOC>*DOC>*Copyright(c)2002,GeoffIngram(geoff@dbcool.com)-ProtonTechnologyLtdDOC>*DOC>*orabm_serverside_stress.sql:OraclepackageforCPUstresstestbenchmarkDOC>*DOC>*Youmaydistributeorabm_serverside_stress.sqlunderthetermsofeithertheDOC>*widelyavailableGNUGeneralPublicLicenseortheArtisticLicenseDOC>*withtheexceptionthatitcannotbeplacedonaCD-ROMorsimilarmediaDOC>*forcommercialdistributionwithoutthepriorapprovaloftheauthor.DOC>*DOC>*/Procedurecreated.Procedurecreated.Procedurecreated.Procedurecreated.DisconnectedfromOracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-Production$sqlplus"/assysdba"@orabm_cacheSQL*Plus:Release9.2.0.4.0-ProductiononSatSep2518:36:072004Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-ProductionTablealtered.COUNT(*)----------30000Tablealtered.COUNT(*)----------10Tablealtered.COUNT(*)----------30000Tablealtered.COUNT(*)----------299952Tablealtered.COUNT(*)----------100000COUNT(*)----------30000COUNT(*)----------30000COUNT(*)----------100000COUNT(*)----------299952COUNT(*)----------30000COUNT(*)----------30000COUNT(*)----------100000DisconnectedfromOracle9iEnterpriseEditionRelease9.2.0.4.0-64bitProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.4.0-Production

至此安装完成.


客户还是可以使用DBaaS系统所能提供的所有能力。数据库云服务消除了组织对专职人员、本地数据库存储设备的需要。他们不必安装、配置和维护任何软硬件。

一直以来个人感觉SQLServer的优化器要比Oracle的聪明。SQL2005的更是比2k聪明了不少。（有次作试验发现有的语句在200万级时还比50万级的相同语句要快show_text的一些提示没有找到解释。一直在奇怪。）

多加的系统视图和实时系统信息这些东西对DBA挑优非常有帮助，但是感觉粒度还是不太细。

我个人认为就是孜孜不懈的学习

对于数据库来说，查询是数据库的灵魂，那么SQL查询效率究竟效率如何呢？下文将带对SQL查询的相关问题进行讨论，供您参考。

理解了存储结构，再阅读下性能优化的章节基本上会对sqlserver有个清晰地认识

学习SQL语言的话如果要学会去做网站就不是很难!但是要做数据库管理的话就有难度了!

比如日志传送、比如集群。。。

这就引发了对varchar和char效率讨论的老问题。到底如何分配varchar的数据，是否会出现大规模的碎片？