Announcement

Collapse
No announcement yet.

3 Database Errors After 4.1.7 Upgrade

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Thanks Paul.

    They are all small web-sites for other TV engineers like myself. Not too busy, just there so they have a web-presence really.
    Having spoken to 1and1 I now realise that I will have to download all files from the current server, upload them all to the new one. Create a new database and upload the current one into it and then get all the domains transferred across with a downtime of 24 hours or more.

    A lot of trouble considering I don't really know if the virtual server is up to the job.
    Regards
    Trevor

    Comment


    • #17
      well vps would be worth the trouble just for the fact that after you move, you'll have full root access so can monitor and find out your real usage loads with info asked at http://www.vbulletin.com/go/tweak and know if you need to move to a higher vps plan or stay with your vps etc.
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

      Comment


      • #18
        I've also been getting "MySQL server has gone away" dB errors on my site since upgrading to 4.1.7. About 20 a day and it's almost always the same query.

        Code:
        SELECT *
        				FROM style
        				WHERE (styleid = 24 AND userselect = 1)
        					OR styleid = 51
        				ORDER BY styleid ASC
        				LIMIT 1;
        I have been increasing wait_timeout & max_allowed_packet, but it hasn't helped yet. Should I just keep increasing these values as they seem pretty high already?

        Full server stats

        Code:
        [client]
        port = 3306
        socket = /var/run/mysqld/mysqld.sock
        
        [mysqld]
        bind-address = 127.0.0.1
        user = mysql
        pid-file = /var/run/mysqld/mysqld.pid
        socket = /var/run/mysqld/mysqld.sock
        port = 3306
        basedir = /usr
        datadir = /var/lib/mysql
        tmpdir = /tmp
        language = /usr/share/mysql/english
        ft_min_word_len = 3
        safe-show-database
        back_log = 50
        # skip-innodb
        innodb_buffer_pool_size = 218M
        max_connections = 400
        key_buffer_size = 256M
        myisam_sort_buffer_size = 64M
        myisam_max_sort_file_size = 2048M
        join_buffer_size = 4M
        read_buffer_size = 1M
        sort_buffer_size = 2M
        table_cache = 1536
        thread_cache_size = 512
        wait_timeout = 300
        interactive_timeout = 60
        connect_timeout = 10
        tmp_table_size = 128M
        max_heap_table_size = 256M
        max_allowed_packet = 256M
        net_buffer_length = 16384
        max_connect_errors = 100000
        thread_concurrency = 4
        concurrent_insert = 2
        table_lock_wait_timeout = 30
        read_rnd_buffer_size = 786432
        bulk_insert_buffer_size = 8M
        query_cache_limit = 4M
        query_cache_size = 128M
        query_cache_type = 1
        query_prealloc_size = 262144
        query_alloc_block_size = 65536
        range_alloc_block_size = 4096
        transaction_alloc_block_size = 8192
        transaction_prealloc_size = 4096
        default-storage-engine = MyISAM
        max_write_lock_count = 8
        #set-variable=long_query_time=8
        log-slow-queries=/var/log/mysql/log-slow-queries.log
        #log-queries-not-using-indexes
        
        [mysqld_safe]
        socket = /var/run/mysqld/mysqld.sock
        open_files_limit = 16384
        
        [mysqldump]
        quick
        max_allowed_packet = 128M
        
        [myisamchk]
        ft_min_word_len = 3
        key_buffer_size = 256M
        sort_buffer_size = 64M
        read_buffer_size = 16M
        write_buffer_size = 16M
        
        [mysqlhotcopy]
        interactive-timeout
        SpankMe
        Kiwi Biker
        SV Portal

        Comment


        • #19
          SpankMe, you may want to head over to Server Configuration forum https://www.vbulletin.com/forum/foru...-Configuration for a new tune up and optimisation of your settings as that thread is old and your stats and traffic/server usage patterns may have changed since Jan 2010 ~ 22 months.

          Start a new thread in that forum with info asked at https://www.vbulletin.com/forum/show...sts-13-07-2011. If you have CentOS/RHEL or Debian OS based server you can also use mysqlmymonlite.sh to gather all info required.
          :: Always Back Up Forum Database + Attachments BEFORE upgrading !
          :: Nginx SPDY SSL - World Flags Demo [video results]
          :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

          Comment


          • #20
            Originally posted by eva2000 View Post
            SpankMe
            lol

            Comment


            • #21
              Originally posted by SpankMe View Post
              I have been increasing wait_timeout & max_allowed_packet, but it hasn't helped yet. Should I just keep increasing these values as they seem pretty high already?
              The values you have seem more than sufficient, your issue must lie elsewhere.
              Baby, I was born this way

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X