Unable to get mysql performance in packetbeat

Elastic Stack Beats
22

As you said if im starting mysql as shown below im able to see everything..

mysql -h 127.0.0.1 -u root

If im giving normally

mysql -u root

Its not working.

Likewise... how to start PGSQL to get the performance?

23

Yes, that's because without -h 127..0.0.1 it's using the Unix socket, and we don't support sniffing from that. We need it to use the network (even localhost).

2 Likes
24

How to start PGSQL ... if im starting normally im unable to view performance in packetbeat... Tell me how to run it..

25

First you need to make sure you have ssl = false in your postgressql.conf. Then restart postgres and start the CLI like this:

 psql -h 127.0.0.1 -U psql
2 Likes