Data sent from/to databases

[Diablotic]

I went live with my website on Friday/Saturday night. And now after migrating from phpbb to vbulletin my hosting company is saying that 24h data amount sent from/to databases is exceeded.

As you can see on the graph below there is a hugh peak in data sent from/to databases when I went live.

My hosting company provided my a file from the last 20 minutes with all the data being sent from and to my databases. I believe this might sensitive data so I'd rather not post it public - the file is 4MB and is only from past 20 minutes!

Can you please tell me where is the problem might be? It is very important for me as my hosting company want to put me offline if I cannot fix that problem. Please

[Marco van Herwaarden]

Have you been backing up/restoring databases or done a migration that would count for this increase?

[Diablotic]

Yes, I have migrated as you can see on the chart on friday/saturday night. But yesterday I was not doing anything special - board was running as normal and still amount sent from/to databases was ~40GB.

[kmike]

The large traffic between the db backend and web frontend is not unusual for vBulletin - apart from the page data, it retrieves a datastore on each request, and some datastore entries are unnecessarily large and/or not needed on each page. So if the forum activity is high enough, 40GB/day is nothing unusual. One of our forums is generating an average 60GB/day backend traffic (and that's with datastore caching enabled and vB Optimise installed), another fairly active forum is close to 350GB/day on the peak days.

What's your board activity? How many forums do you have?
Could you run this query, adjusting YOUR_FORUM_DB accordingly:

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='YOUR_FORUM_DB' and TABLE_NAME='datastore'\G

You can reduce the backend traffic by enabling one of the local datastore caching methods in vBulletin: XCache, APC, eAccelerator. You can also use memcached, but it has to be running on the same server for the traffic to stay local. You can further reduce the backend traffic by installing the vB Optimise product.