Issues
- No client_host data in pmm.metrics table from clickhouse(mysql_slowlog_agent)PMM-6470Resolved issue: PMM-6470Lalit Choudhary
- Can't configure new PMM client because of NOT NULL constraintPMM-5919Resolved issue: PMM-5919
- PMM Server: Timeout when simultaneously generating and accessing logs via download or APIPMM-5823Resolved issue: PMM-5823
- In Dashboard, postgresql instances have links to Mysql Instance SummaryPMM-5771Resolved issue: PMM-5771
- Graph image share link brokenPMM-5735Resolved issue: PMM-5735
- Temporary files activity and utilization charts (rate & irate) were added to the PostgreSQL Instance overview.PMM-5734Resolved issue: PMM-5734
- QAN Overview - TOTALS and N/A are selected together each time and Details are shown for TOTALSPMM-5727Resolved issue: PMM-5727
- User-installed Grafana plugins unaffected by PMM upgradePMM-5706Resolved issue: PMM-5706
- Query Time incorrect in QAN Details viewPMM-5704Resolved issue: PMM-5704
- Home Dashboard: Incorrect metric for 'DB uptime'PMM-5701Resolved issue: PMM-5701
- Documentation included in PMM 2 for deprecated check-network commandPMM-5690Resolved issue: PMM-5690Paul Jacobs
- Queries inserted with the wrong timestamp after a network outagePMM-5688
- Cumulative charts for Disk Details were not showing any data if metrics were returning 'NaN' results.PMM-5687Resolved issue: PMM-5687
- Increase the limit on shared dashboard sizePMM-5682Resolved issue: PMM-5682Anton Bystrov
- pmm-client doesn't work when i configure with node-namePMM-5681Resolved issue: PMM-5681Lalit Choudhary
- pmm-admin summary doesn't include client exporter and some other logsPMM-5680Resolved issue: PMM-5680Yaroslav Podorvanov
- Broken Slow log rotation for 1 server monitored from several placesPMM-5679Resolved issue: PMM-5679Zoriana Stefanyshyn
- pmm-admin remove does not seem to work as documentedPMM-5670Resolved issue: PMM-5670Andrei Minkin
- New flag --paths-base in pmm-agent to avoid problems with hardcoded pathsPMM-5669Resolved issue: PMM-5669Jiří Čtvrtka
- Configurable pmm-agent log levelPMM-5668Resolved issue: PMM-5668
- upgrade pmm-client from 1.17 to 2.4.0PMM-5667Resolved issue: PMM-5667
- The 'version' value was not being refreshed in various MySQL dashboards.PMM-5663Resolved issue: PMM-5663
- Adding RDS instance breaks MySQL Instances Overview filtering optionsPMM-5661Resolved issue: PMM-5661Vadim Yalovets
- docker environment for SERVER_USER and SERVER_PASSWORD not workingPMM-5658
- Properly remove node (instances) from pmm serverPMM-5657Resolved issue: PMM-5657
- Change scrape_timeout parameter for low metric resolutionsPMM-5653
- information_schema queries are not properly filteredPMM-5646
- Advanced Data Exploration charts were showing 'N/A' for Metric Resolution and 'No data to show' in the Metric Data Table.PMM-5643Resolved issue: PMM-5643
- First data bucket lost in SparklinePMM-5641Resolved issue: PMM-5641
- Adding mariadb with disabled Perfshema shows no error and no data in QANPMM-5627Resolved issue: PMM-5627
- PMM client 2.4.0 QAN not working for MongoDBPMM-5626Resolved issue: PMM-5626
- Query Count with errors have no SparklinePMM-5625Resolved issue: PMM-5625
- Empty charts were being shown in some Node Temperature dashboards.PMM-5624Resolved issue: PMM-5624
- Sorting data by Query Time was not working in Query Analytics.PMM-5613Resolved issue: PMM-5613
- remove extra spaces in elements names on DashboardsPMM-5605Resolved issue: PMM-5605
- PMM Server Grafana plugins can now be updated on the command line with the grafana-cli command-line utility.PMM-5581Resolved issue: PMM-5581
- Present part of information about units in QAN in titles instead of text to save some spacePMM-5555Resolved issue: PMM-5555
- Totals in charts were inconsistently plotted with different colors across charts.PMM-5554Resolved issue: PMM-5554
- There is an error while trying to change Prometheus datasource HTTP methodPMM-5553
- Editing Metrics in "Explore" scrambles TextPMM-5552Resolved issue: PMM-5552
- Prometheus alerting rule changes needs docker restart to activatePMM-5524Resolved issue: PMM-5524
- CLI - pmm-admin summary commands generate duplicated client folder inside output zipPMM-5490Resolved issue: PMM-5490
- QAN Details is not displayedPMM-5483Resolved issue: PMM-5483
- "Failed to get PMM Server parameter" after config.PMM-5368Resolved issue: PMM-5368Dávid Mikuš
- Client fails to send non-UTF-8 query analytics content to serverPMM-5365Resolved issue: PMM-5365
- Can't see table definition if query has FROM table AS t1PMM-5281
- user table name is replaced with SYSTEM_USER in fingerprintsPMM-5188
- Remove or modify column used for sorting in QAN makes dashboard unusable until page reloadedPMM-5173Resolved issue: PMM-5173
- PMM query errors and warning metrics seem to not be workingPMM-5144Roma Novikov
- Query Example is often emptyPMM-5135Resolved issue: PMM-5135Jiří Čtvrtka
50 of 50
Hi,
I want to query data from clickhouse,
but it seems that pmm doesn't collect the client_host data from mysql_slowlog_agent.
It will be nice to impove this,thanks.
my query sql:
SELECT period_start,queryid,service_name,schema,cluster,client_host,
fingerprint,example,username,service_type,node_name,
num_queries,m_query_time_sum,m_query_time_max,m_rows_examined_max,m_rows_sent_max,m_lock_time_sum
FROM pmm.metrics
where service_type='mysql'
and period_start>'2020-08-09 00:50:00'
and period_start<'2020-08-09 01:00:00'
order by period_start;