# How to monitor mysql performance by giving the clients Ip?

**URL:** <https://discuss.elastic.co/t/how-to-monitor-mysql-performance-by-giving-the-clients-ip/1462>\
**Category:** Beats\
**Tags:** packetbeat\
**Created:** [May 28, 2015, 11:21am UTC](https://discuss.elastic.co/t/how-to-monitor-mysql-performance-by-giving-the-clients-ip/1462 "2015-05-28T11:21:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Akhilesh\_Anb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/akhilesh_anb/32/4343_2.png) [@Akhilesh\_Anb](https://discuss.elastic.co/u/Akhilesh_Anb)\
**Post date:** [May 28, 2015, 11:21am UTC](https://discuss.elastic.co/t/how-to-monitor-mysql-performance-by-giving-the-clients-ip/1462/1 "2015-05-28T11:21:55Z")

</div>

I want to monitor the performance of mysql, http requests of the client. I'm having clients ip and they are running mysql. I have to monitor the quiries what they are running. So, what are the changes i have to do?

---

<div class="post-metadata">

**Author:** ![tudor](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tudor/32/3753_2.png) [@tudor](https://discuss.elastic.co/u/tudor)\
**Post date:** [May 28, 2015, 4:34pm UTC](https://discuss.elastic.co/t/how-to-monitor-mysql-performance-by-giving-the-clients-ip/1462/2 "2015-05-28T16:34:20Z")

</div>

Packetbeat stores the source IP address for any request in the `client_ip` field. If you want to see all the queries done by a particular IP address, do a simple `client_ip: X.X.X.X` search in the Discover tab.

You could also do a "Top 10 IP addresses making queries", that's usually quite cool. Do a histogram queries, and put on the X axis "terms" on `client_ip`.

---

<div class="post-metadata">

**Author:** ![Akhilesh\_Anb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/akhilesh_anb/32/4343_2.png) [@Akhilesh\_Anb](https://discuss.elastic.co/u/Akhilesh_Anb)\
**Post date:** [May 29, 2015, 11:01am UTC](https://discuss.elastic.co/t/how-to-monitor-mysql-performance-by-giving-the-clients-ip/1462/3 "2015-05-29T11:01:32Z")

</div>

What are the changes i have to make in configuration file.. where i have to give ip address of the client in conf file... In conf file its asking the port and output to elasticsearch.. but its not asking from which ip we have to monitor the ports... kindly help me for this..

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 9:59pm UTC](https://discuss.elastic.co/t/how-to-monitor-mysql-performance-by-giving-the-clients-ip/1462/4 "2017-07-05T21:59:17Z")

</div>