Results 1 to 10 of 29

Thread: Unable to execute query ....MySQL server has gone away

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Sep 2008
    Posts
    1,019

    Default

    Quote Originally Posted by cybra View Post
    wait_timeout=30
    There is the problem right there. Basically, that is saying that after 30 seconds, close mySQL. That is obviously not set to 1800 like your host stated. I would sit it to 900 (15 minutes) and see if that works. If not, you can increase it further.
    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!

  2. #2
    Join Date
    Apr 2010
    Posts
    88

    Default

    Ah I see. How would I actually change it using putty. Is it just like setting a cron command?

  3. #3
    Join Date
    Apr 2010
    Posts
    88

    Default

    I just got a response from my host so lets see if they will do it
    Now that they have been busted..:)

  4. #4
    Join Date
    Apr 2010
    Posts
    88

    Default

    I accidentally deleted some important lines because I tried to just change the time out command but didn't realize I had to change them all at once.
    Al my sites were down that hole time, and I almost had a brain spasm. But thanks for the info. Although I havent tested it yet Im sure it works.

    skip-locking
    character-sets-dir=/usr/share/mysql/charsets/
    query_cache_limit=1M
    query_cache_size=16M
    query_cache_type=1
    max_user_connections=100
    max_connections=250
    interactive_timeout=120
    wait_timeout=1800
    connect_timeout=3000
    thread_cache_size=96
    key_buffer=16M
    join_buffer=2M
    max_allowed_packet=16M
    table_cache=1024
    record_buffer=2M
    sort_buffer_size=1024K
    read_buffer_size=1024K

  5. #5
    Join Date
    Apr 2010
    Posts
    88

    Default

    Yep :) Even went to my remote server.

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

    Default

    That's good to here. Tell your host that the next time you ask for them to do something, you now know how to go in and check to make sure that they did :)
    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!

  7. #7
    Join Date
    Apr 2010
    Posts
    88

    Default

    Exactly.
    Hey bplex I appreciate all your help with this so far and I don't expect but so much help. But now the videos I convert are not streaming and the player has no time at 00:00. The videos are converting and the time is in the descr, but when I click through to like skip forward nothing happens and the video just keeps playing. I am importing wmv files so they can be watermarked. I have tried ffmpeg and mplayer but same thing. Do you have any idea what could be the cause?

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
  •