Anemometer icon indicating copy to clipboard operation
Anemometer copied to clipboard

MariaDB query error

Open yure opened this issue 9 years ago • 0 comments

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

yure avatar Apr 25 '15 10:04 yure