p6spy mysql8_moqui-mysql-p6spy配置（阿超编写）

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数据源

jdbc-username="moqui" jdbc-password="moqui" pool-minsize="2"

pool-maxsize="50" />

jdbc-username="moqui" jdbc-password="moqui" pool-m