support.monitor.mysql.datasource.sql Maven / Gradle / Ivy

Show more of this group Show more artifacts with this name
Show all versions of druid Show documentation

An JDBC datasource implementation.

There is a newer version: 1.2.23

CREATE TABLE druid_datasource (
	id bigint(20) AUTO_INCREMENT NOT NULL, 
	domain varchar(45) NOT NULL, 
	app varchar(45) NOT NULL, 
	cluster varchar(45) NOT NULL, 
	host varchar(128), 
	pid int(10) NOT NULL, 
	collectTime datetime NOT NULL, 
	name varchar(256), 
	dbType varchar(256), 
	driverClassName varchar(256), 
	activeCount int(10), 
	activePeak int(10), 
	activePeakTime bigint(20), 
	poolingCount int(10), 
	poolingPeak int(10), 
	poolingPeakTime bigint(20), 
	connectCount bigint(20), 
	closeCount bigint(20), 
	waitThreadCount bigint(20), 
	notEmptyWaitCount bigint(20), 
	notEmptyWaitNanos bigint(20), 
	logicConnectErrorCount bigint(20), 
	physicalConnectCount bigint(20), 
	physicalCloseCount bigint(20), 
	physicalConnectErrorCount bigint(20), 
	executeCount bigint(20), 
	errorCount bigint(20), 
	commitCount bigint(20), 
	rollbackCount bigint(20), 
	pstmtCacheHitCount bigint(20), 
	pstmtCacheMissCount bigint(20), 
	startTransactionCount bigint(20), 
	txn_0_1 bigint(20), 
	txn_1_10 bigint(20), 
	txn_10_100 bigint(20), 
	txn_100_1000 bigint(20), 
	txn_1000_10000 bigint(20), 
	txn_10000_100000 bigint(20), 
	txn_more bigint(20), 
	clobOpenCount bigint(20), 
	blobOpenCount bigint(20), 
	sqlSkipCount bigint(20), 
	PRIMARY KEY (id)
);

CREATE INDEX druid_datasource_index ON druid_datasource (collectTime, domain, app);