Importing UBB Archives

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Herb
    Senior Member
    • Apr 2000
    • 106

    Importing UBB Archives

    How do everyone,

    I can't seem to import my archives from UBB.. The error I keep getting is "MySQL client run out of memory"

    I know this is not necessarily a vB problem.. I had the same problem importing forums but with the forums your allowed to set how many to do at a time and with archives you are not..

    Anyways does anyone know which variable needs to be upped in mysql..

    sorry if I should have posted this in the mysql forum..

    Herb
    The Cannabis Edge
  • Chris Schreiber
    Senior Member
    • Jun 2000
    • 4113
    • 4.0.x

    #2
    Hi Herb-

    This should be pretty easy to fix.... we just need to tweak some of your MySQL settings. Do you have a file called /etc/my.cnf on your server? Also could you post your server specs and the your average number of concurrent users.

    Thanks,
    -Chris

    Comment

    • Herb
      Senior Member
      • Apr 2000
      • 106

      #3
      lol

      high chris - Please dont laugh to hard at me, but we are on a shared mysql server and all settings are global and I dont have access to see what they are currently set at..

      My provider (netnation.com) told me they would possibly accomidate our needs if the db admins agree with my request.. I just need to tell them what settings I would like changed and for what reason..

      As you can see I am stuck in a rock and uhhh, hows that go.. Our website is also on a shared web server.. this is all going to change here in the next few months but for now I would like to at least get some of our settings bumped up.. I am also having problems running all my counts and re-indexing, getting the same error..

      I either loosed connection in mid query or run out of memory, depending on what I am doing..

      concurrent users is averagre about 50-60 users a day..
      mysql ver 3.22.27(I think)
      php ver 3.015 (yuck)

      I am sorry I cannot provide anymore information..

      Thanks so much for your efforts..

      Herb
      The Cannabis Edge

      Comment

      • Chris Schreiber
        Senior Member
        • Jun 2000
        • 4113
        • 4.0.x

        #4
        Ok, well at least your host is willing to consider some MySQL changes, there are many that just refuse. Can you ask them for the current settings, printed from the "mysqladmin variables" command, and I can make suggestions from there. Also, there are some indexes that you can add into your database that can really help with performance and memory issues.

        -Chris

        Comment

        • Herb
          Senior Member
          • Apr 2000
          • 106

          #5
          Here ya go

          Ok Chris, this is what I got when I ran a show variables in the mysql client..


          back_log - 5
          connect_timeout - 5
          basedir - /usr/local/mysql/ -
          datadir - /usr/local/mysql/var/
          delayed_insert_limit - 100
          delayed_insert_timeout - 300
          delayed_queue_size - 1000
          join_buffer - 131072
          flush_time - 0
          key_buffer - 8388600
          language - /usr/local/mysql/data/mysql/english/
          log - OFF
          log_update - OFF
          long_query_time - 10
          low_priority_updates - OFF
          max_allowed_packet - 1048576
          max_connections - 100
          max_connect_errors - 10
          max_delayed_insert_threads - 20
          max_join_size - 4294967295
          max_sort_length - 1024
          net_buffer_length - 16384
          pid_file - /usr/local/mysql/var/db.pid
          port - 4000
          protocol_version - 10
          record_buffer - 131072
          skip_locking - ON
          skip_networking - OFF
          socket - /tmp/mysql.sock
          sort_buffer - 2097144
          table_cache - 64
          thread_stack - 65536
          tmp_table_size - 1048576
          tmpdir - /tmp/
          version - 3.22.26a
          wait_timeout - 28800


          Herb..
          The Cannabis Edge

          Comment

          • Chris Schreiber
            Senior Member
            • Jun 2000
            • 4113
            • 4.0.x

            #6
            Re: Here ya go

            Ok, I would recommend these changes to the current configuration:

            join_buffer - 262144
            record_buffer - 262144
            key_buffer - 16777200
            max_connections - 150
            table_cache - 128

            If fact, they could probably increase these a little more then that, but I am not sure how much, if any, free memory they still have left on your server.

            -Chris

            Comment

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