p6spy监测mysql"/>
p6spy监测mysql
1.添加p6spy-2.0-SNAPSHOT.jar到runtime\lib下。
2.runtime\classes下添加spy.properties文件,修改47-49
# mysql Connector/J driver
realdriver=com.mysql.jdbc.Driver 去掉此行前的注释
3.runtime\conf\MoquiProductionConf.xml重定义mysql的连接信息
修改driver为"com.p6spy.engine.spy.P6SpyDriver",改后如下:
table-engine="InnoDB" character-set="utf8" collate="utf8_general_ci"
default-isolation-level="ReadCommitted" default-jdbc-driver="com.p6spy.engine.spy.P6SpyDriver"
default-test-query="SELECT 1">
4.runtime\conf\MoquiProductionConf.xml 中定义mysql数据源
schema-name="">
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2"
pool-maxsize="50" />
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2"
pool-maxsize="50" />
jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2"
pool-maxsize="50" />
5.数据库环境略
CREATE DATABASE moquitransactional DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE moquianalytical DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE moquitenantcommon DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
6.用java -Dmoqui.conf=conf/MoquiProductionConf.xml -jar moqui-1.2.0.war -load 加载数据。
7.java -Dfile.encoding=UTF-8 -Dmoqui.conf=conf/MoquiProductionConf.xml -jar moqui-1.2.0.war 启动服务
感谢“啊菠萝波罗密”同学的指导
阿超 QQ 46488820
更多推荐
p6spy监测mysql
发布评论