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?
Bookmarks