A lot of query download from the db server

  • Hello, my problem is this: i have www on one server and the db is on another, both dedicated and the www download A LOT of data from the db causing troubles on the db server.
    Thats my bwm-ng

    bwm-ng v0.6 (probing every 0.500s), press 'h' for help
  input: /proc/net/dev type: avg (30s)
  |         iface                   Rx                   Tx                Total
  ==============================================================================
             eth0:        4506.89 KB/s          365.03 KB/s         4871.91 KB/s
               lo:           0.05 KB/s            0.05 KB/s            0.11 KB/s
  ------------------------------------------------------------------------------
            total:        4506.94 KB/s          365.08 KB/s         4872.02 KB/s

    There are any way to reduce the data downloaded?

Viewing 1 replies (of 1 total)

  • # ### Check the server active connections (check whether it relates to MySQL/MariaDB or not)
    netstat -naop

    # ### If it is the database server, you may check the running processes –
    Goto phpMyAdmin (or mysql client in SSH console or else), and issue the SQL –
    show full processlist;

Viewing 1 replies (of 1 total)
  • The topic ‘A lot of query download from the db server’ is closed to new replies.