Anemometer
Anemometer copied to clipboard
MariaDB query error
Hi! After installation and web setup i get this error, not sure if it's related to mariadb or not, any ideas?
'slow_query_log.dimension.sample' isn't in GROUP BY (1055)
SELECT checksum AS checksum
,
LEFT(dimension.sample,20) AS snippet
,
ROUND(SUM(Rows_examined_sum)/SUM(rows_sent_sum),2) AS index_ratio
,
SUM(Query_time_sum) / SUM(ts_cnt) AS query_time_avg
,
ROUND(SUM(Rows_sent_sum)/SUM(ts_cnt),0) AS rows_sent_avg
,
SUM(ts_cnt) AS ts_cnt
,
SUM(Query_time_sum) AS Query_time_sum
,
SUM(Lock_time_sum) AS Lock_time_sum
,
SUM(Rows_sent_sum) AS Rows_sent_sum
,
SUM(Rows_examined_sum) AS Rows_examined_sum
,
SUM(Tmp_table_sum) AS Tmp_table_sum
,
SUM(Filesort_sum) AS Filesort_sum
,
SUM(Full_scan_sum) AS Full_scan_sum
FROM global_query_review
AS fact
JOIN global_query_review_history
AS dimension
USING (checksum
)
WHERE dimension.ts_min >= "2015-04-24 12:30:12"
AND dimension.ts_min <= "2015-04-25 12:30:12"
GROUP BY checksum
ORDER BY Query_time_sum DESC
LIMIT 20