Anemometer
Anemometer copied to clipboard
Problem installing in MariaDB
MariaDB checks if default date makes sense, and fails on default date 0000-00-00.
Here is a patch to fix the issue
index 8803f38..6f84644 100644
--- a/install.sql
+++ b/install.sql
@@ -23,8 +23,8 @@ CREATE TABLE global_query_review_history
(
db_max
varchar(64) DEFAULT NULL,
checksum
bigint(20) unsigned NOT NULL,
sample
longtext NOT NULL,
-
ts_min
datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -
ts_max
datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -
ts_min
datetime NOT NULL DEFAULT '1990-01-01 00:00:00', -
ts_max
datetime NOT NULL DEFAULT '1990-01-01 00:00:00',ts_cnt
float DEFAULT NULL,Query_time_sum
float DEFAULT NULL,Query_time_min
float DEFAULT NULL,
Thank you, this solve my problem and I am using mysql