Results 1 to 2 of 2

Thread: Disable Guest_Info logging for Bandwidth (DB issues)

  1. #1
    Join Date
    Jul 2008
    Posts
    14

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

  2. #2
    Join Date
    Sep 2008
    Posts
    1,019

    Default 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.
    vShare Solutions
    Custom vShare Modules and Services

    Now, your visitors can watch videos on your site using their mobile or tablet device with the Mobility Mod for vShare 2.8!

Similar Threads

  1. guest_info table
    By killahboo in forum Bug Reports
    Replies: 26
    Last Post: 04-09-2009, 07:28 PM
  2. High Bandwidth Issues
    By topfreaks in forum General Discussions
    Replies: 1
    Last Post: 07-02-2008, 07:29 AM
  3. Disable Flagging
    By codyr1951 in forum General Discussions
    Replies: 1
    Last Post: 04-23-2008, 06:06 AM
  4. disable Right Click
    By sam in forum Installation Support
    Replies: 10
    Last Post: 09-27-2007, 05:36 PM
  5. Allow owners to disable downloads?
    By leki in forum Fixed Bugs
    Replies: 0
    Last Post: 08-27-2007, 04:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •