Disable Guest_Info logging for Bandwidth (DB issues)
I am trying to figure out how to disable the logging of Guest Info, ( I think it is to track BW usage), the stats come in like this...
| 149100 | db978vtube | 69.5.93.253:37628 | db978vtube | Query | 1 | Locked | UPDATE guest_info SET use_bw='246' WHERE guest_ip='67.191.219.20' AND log_date='09-02-09' |
| 149109 | db978vtube | 69.5.93.253:37638 | db978vtube | Query | 0 | Locked | SELECT * FROM guest_info WHERE guest_ip='68.50.18.24' AND log_date='09-02-09' |
| 149110 | db978vtube | 69.5.93.253:37639 | db978vtube | Query | 0 | Locked | SELECT * FROM guest_info WHERE guest_ip='86.14.125.238' AND log_date='09-02-09'
How can I disable the logging of the IPs in MySQL?
Also has anyone had an issue with a large amount of traffic putting demand stress on the DB because the tube script has to query the DB in order to play the vids?
Re: Disable Guest_Info logging for Bandwidth (DB issues)
This is a common problem. As of today, you cannot disable the logging. What many of us do is clear out that table every so many minutes. The querying isn't the issue as mySQL is designed for that. It's the storing that becomes the problem. That table can easily fill up with millions of rows, causing your site to slow down tremendously. Thus, clearing it every few minutes resolves this. Search the forum for this issue as there are tuns of posts on how to setup a script to clear it automatically.