Search code examples
mysqlnetwork-programmingifconfig

How to monitor Network traffic with MySQL?

ifconfig -output is somewhat messy thing to look at. When I saw the nice output below with the command (source), the question emerged:

Is there some more structured way, let say MySQL, to look at ifconfig or similar data?

It would be cool, if I could monitor the network traffic in databases.

[prompt]$ mysqladmin -h localhost -u root -p processlist

+----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host      | db | Command | Time | State | Info             |
+----+------+-----------+----+---------+------+-------+------------------+
| 15 | root | localhost |    | Query   | 0    |       | show processlist |
+----+------+-----------+----+---------+------+-------+------------------+
Solution

  • MySQL GUI Tools and administrator tools allow you to monitor to some extent. if you want raw packets, you can either use Ethereal or Wireshark