Member Avatar for Member 785497

I have a site that uses apache(php) & mysql
I recently moved the mysql to another dedicated server
in order to increase performace.


This is the problem now :

MYSQL Server is showing ~150GBs daily outgoing transfer to Web Server !
And at the same time the Web server is showing ~150Gbs daily incoming transfer from the mysql server !

This is too much,
especially considering the fact that the total daily outgoing bandwidth of the Web Server is ~40Gbs


How can I find the process/es responsible for the high mysql bandwidth usage between the 2 servers ?
Is there any way to monitor/log mysql data transfer per query?

Any help or advice would be appreciated !

Thank you in advance,

  • 2 Contributors
  • 1 Reply
  • 224 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

Your headed in the right direction. Look at the system logs and see what is going on. ls -lart will list files with the most recent entries at the bottom.

How are you connecting to the database server from the application server?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.