Announcement

Collapse
No announcement yet.

Many Problems since the upgrade.

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

  • George L
    replied
    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

    Leave a comment:


  • Brent
    replied
    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?

    Leave a comment:


  • Cliff
    replied
    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!

    Leave a comment:


  • Cliff
    started a topic Many Problems since the upgrade.

    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)
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X