Announcement

Collapse
No announcement yet.

Many Problems since the upgrade.

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

  • Many Problems since the upgrade.

    Before we upgraded we were running 1.1.5 and had not problems but since our upgrade the server crashed about ever 12 -14 hours. All memory is used and all swap is used. A couple of time I have caught the server before it crashed which is where I get the resource information. This is getting a little upsetting - having to go to a noc and hard reboot a machine every day where the machines uptime is usually pretty high! Please assist in any way that you possibly can.

    System Config.
    Linux
    Dual P3 733
    1 Gig Ram
    Raid 10
    176 Swap

    Forum Stats:
    18589 Registered Members
    24125 threads in total
    295662 posts in total
    400 Adverage On-Line Users
    600 Adverage Peak On-Line Users (3pm - 1 am)

    Mysql Stats/Config
    Mysql v3.22.32 with Raid Support

    [mysqld]
    port = 3306
    socket = /tmp/mysql.sock
    skip-locking
    set-variable = max_connections=400
    set-variable = key_buffer=16M
    set-variable = max_allowed_packet=1M
    set-variable = join_buffer=150M
    set-variable = table_cache=256
    set-variable = sort_buffer=10M
    set-variable = record_buffer=1M
    set-variable = myisam_sort_buffer_size=64M
    set-variable = thread_cache=128
    #set-variable = temp_table_size=4M
    set-variable = thread_concurrency=8 # Try number of CPU's*2
    set-variable = thread_stack=128K
    log-bin
    server-id = 1

    # Uncomment the following if you are using BDB tables
    #set-variable = bdb_cache_size=64M
    #set-variable = bdb_max_lock=100000

    # Point the following paths to different dedicated disks
    #tmpdir = /tmp/
    #log-update = /path-to-dedicated-directory/hostname

    [mysqldump]
    quick
    set-variable = max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    #safe-updates # Remove the comment character if you are not familiar with SQL

    [isamchk]
    set-variable = key_buffer=128M
    set-variable = sort_buffer=128M
    set-variable = read_buffer=2M
    set-variable = write_buffer=2M

    [myisamchk]
    set-variable = key_buffer=128M
    set-variable = sort_buffer=128M

    Threads: 18 Questions: 188841 Slow queries: 4 Opens: 229 Flush tables: 1 Open tables: 223 Queries per second avg: 78.163
    (note: just after a hard reboot)
    and they said that it could not be done.....

  • #2
    Cont...

    +--------------------------+-----------+
    | Variable_name | Value |
    +--------------------------+-----------+
    | Aborted_clients | 0 |
    | Aborted_connects | 0 |
    | Bytes_received | 31823937 |
    | Bytes_sent | 446524598 |
    | Connections | 8926 |
    | Created_tmp_disk_tables | 9 |
    | Created_tmp_tables | 3298 |
    | Created_tmp_files | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Delayed_errors | 0 |
    | Flush_commands | 1 |
    | Handler_delete | 1553 |
    | Handler_read_first | 2938 |
    | Handler_read_key | 1816674 |
    | Handler_read_next | 14291999 |
    | Handler_read_prev | 0 |
    | Handler_read_rnd | 1670548 |
    | Handler_read_rnd_next | 162598766 |
    | Handler_update | 20494 |
    | Handler_write | 119958 |
    | Key_blocks_used | 15582 |
    | Key_read_requests | 8698623 |
    | Key_reads | 17249 |
    | Key_write_requests | 10960 |
    | Key_writes | 10020 |
    | Max_used_connections | 41 |
    | Not_flushed_key_blocks | 0 |
    | Not_flushed_delayed_rows | 0 |
    | Open_tables | 224 |
    | Open_files | 251 |
    | Open_streams | 0 |
    | Opened_tables | 230 |
    | Questions | 201894 |
    | Select_full_join | 12 |
    | Select_full_range_join | 0 |
    | Select_range | 31541 |
    | Select_range_check | 0 |
    | Select_scan | 31393 |
    | Slave_running | OFF |
    | Slave_open_temp_tables | 0 |
    | Slow_launch_threads | 0 |
    | Slow_queries | 8 |
    | Sort_merge_passes | 0 |
    | Sort_range | 34040 |
    | Sort_rows | 2654626 |
    | Sort_scan | 19945 |
    | Table_locks_immediate | 215196 |
    | Table_locks_waited | 1358 |
    | Threads_cached | 26 |
    | Threads_created | 42 |
    | Threads_connected | 16 |
    | Threads_running | 1 |
    | Uptime | 2545 |
    +--------------------------+-----------+
    (note: just after reboot)

    Additional Comments:
    The only thing that is running on the this box is mysql and apache (1.3.14) Mod_gzip was compiled but I removed it because I thought that it may be the problem.


    It is almost like that there is a memory leak.... But I am at a total loss, all that I can say is that the current performance is not acceptable and I may be forced to move back to a previous version!
    and they said that it could not be done.....

    Comment


    • #3
      Bump

      Anybody got any clues? I'm at the limits of my knowledge with this problem Cliff is having, any help would be appreciated

      Would upgrading to the latest and greatest MySQL help?

      What about the final build of vB would that help, etc...

      thoughts?

      Comment


      • #4
        cliff check my reply here

        http://vbulletin.com/forum/showthrea...threadid=15733

        i was checking out hardforum the other day and saw nearly 700 users

        trying to find out what the hell happened with overclockers.com.au's forum and that vendor
        :: 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

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