Search code examples
databasenetwork-programmingbandwidthforums

Database bandwidth much higher compared to server bandwidth. Normal?


A while back we were transferring our reasonably popular forum to a new dedicated server (with the same host), and we noticed something weird. At first we used the new server to host just the database as this was the biggest issue. Then later we transferred the forum files and changed the dns for the domain.

When we look back at the bandwidth used we see this for the bytes sent by the server:

database use: 100k/sec  
whole forum use: 25k/sec  

Note: bytes received by the server stayed very low throughout.

So is it normal for a forum database to use 4 times more network traffic then the server actually sends back to the user? It sounds very inefficient to me, like requesting much more than what is needed from the database, but this is the latest version of vBulletin we're talking about here.


Solution

  • vBulletin is known to use incredible amount of traffic between webserver and database. They suggest you run a crossed cat6 ethernet-cable on a dedicated Gbit-NIC between your servers because if this.

    I would say it's bad design (maybe because the do more logic in the application layer than in the database) where they pick out a lot more data than they actually present to the client.

    So I would say it's normal for vBulletin, but not normal in most other software-solutions.

    If you google regarding this issue I believe you would find a lot of people with the same issue.

    example: http://www.vbulletin.org/forum/archive/index.php/t-111191.html

    If your hosting measures bandwidth incorrectly, you might end up paying for huge amount of internal traffic as well, not cool :)