Announcement

Collapse
No announcement yet.

Database and other errors

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

  • #16
    Here you go, will have to do it in two posts-

    |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout 300 |
    | delayed_queue_size 1000 |
    | flush OFF flush_time | have_bdb NO |
    | have_gemini | NO |
    | have_innodb | NO |
    | have_isam | YES
    | have_raid | NO |
    | have_openssl | NO
    init_file |
    | interactive_timeout | 28800 |
    | join_buffer_size | 4190208 |
    | key_buffer_size | 33550336 |
    | language | /usr/share/mysql/english/ |
    | large_files_support | ON |
    | locked_in_memory | OFF |
    | log | OFF |
    | log_update | OFF |
    | log_bin | OFF |
    | log_slave_updates | OFF |
    | log_long_queries | OFF |
    | long_query_time | 10 |
    | low_priority_updates | OFF |
    | lower_case_table_names | 0 |
    | max_allowed_packet | 8387584 |
    | max_binlog_cache_size | 4294967295 |
    | max_binlog_size | 1073741824 |
    | max_connections | 1000 |
    | max_connect_errors | 10 |
    | max_delayed_threads | 20 |
    | max_heap_table_size | 16777216 |
    | max_join_size | 4294967295
    | max_sort_length | 1024 |
    | max_user_connections | 150 |
    | max_tmp_tables | 32 |
    | max_write_lock_count | 4294967295 | myisam_max_extra_sort_file_size | 256 |
    | myisam_max_sort_file_size | 2047 |
    | myisam_recover_options | 0 | myisam_sort_buffer_size 8388608 |
    | net_buffer_length 16384 |
    | net_read_timeout 30 |
    | net_retry_count 10 |
    | net_write_timeout 60 |
    | open_files_limit | 0 |
    | pid_file | /var/lib/mysql/lake.vosn.net.pid |
    | port 3306 |
    | protocol_version | 10 |
    | record_buffer | 4190208 |
    | record_rnd_buffer 4190208 |
    | query_buffer_size 0 |
    | safe_show_database OFF |
    | server_id 0 |
    | slave_net_timeout 3600 |
    | skip_locking ON |
    | skip_networking OFF |
    | skip_show_database | OFF |
    | slow_launch_time | 2 |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer 6291448 |
    | sql_mode 0 |
    | table_cache 1024 |
    | table_type MYISAM |
    | thread_cache_size | 128 |
    | thread_stack | 65536 |
    | transaction_isolation | READ-COMMITTED |
    | timezone MDT |
    | tmp_table_size 33554432 |
    | tmpdir | /tmp/ |
    | version 3.23.45 |
    | wait_timeout 3600 ---------

    Comment


    • #17
      +--------------------------+------------+
      | Variable_name | Value |
      +--------------------------+------------+
      | Aborted_clients | 890 |
      | Aborted_connects | 34 |
      | Bytes_received | 1038018215 |
      | Bytes_sent | 1334410736 |
      | Connections | 339601 |
      | Created_tmp_disk_tables | 26142 |
      | Created_tmp_tables | 209688 |
      | Created_tmp_files | 0 |
      | Delayed_insert_threads | 0 |
      | Delayed_writes | 0 |
      | Delayed_errors | 0 |
      | Flush_commands | 1 |
      | Handler_delete | 58387 |
      | Handler_read_first | 261631 |
      | Handler_read_key | 49635770 |
      | Handler_read_next | 454732263 |
      | Handler_read_prev | 115841 |
      | Handler_read_rnd | 139343088 |
      | Handler_read_rnd_next | 2218046980 |
      | Handler_update | 5325913 |
      | Handler_write | 19854406 |
      | Key_blocks_used | 31168 |
      | Key_read_requests | 222038948 |
      | Key_reads | 297815 |
      | Key_write_requests | 5056492 |
      | Key_writes | 282585 |
      | Max_used_connections | 91 |
      | Not_flushed_key_blocks | 0 |
      | Not_flushed_delayed_rows | 0 |
      | Open_tables | 1024 |
      | Open_files | 1713 |
      | Open_streams | 0 |
      | Opened_tables | 3220 |
      | Questions | 7045373 |
      | Select_full_join | 21061 |
      | Select_full_range_join | 14 |
      | Select_range | 1084257 |
      | Select_range_check | 0 |
      | Select_scan | 1483548 |
      | Slave_running | OFF |
      | Slave_open_temp_tables | 0 |
      | Slow_launch_threads | 1 |
      | Slow_queries | 25569 |
      | Sort_merge_passes | 0 |
      | Sort_range | 1159050 |
      | Sort_rows | 144104931 |
      | Sort_scan | 855411 |
      | Table_locks_immediate | 7389116 |
      | Table_locks_waited | 6168 |
      | Threads_cached | 82 |
      | Threads_created | 92 |
      | Threads_connected | 10 |
      | Threads_running | 2 |
      | Uptime | 81556 |
      +--------------------------+------------+

      Thanks
      Joanne

      Comment


      • #18
        you could try asking them to either

        1. increase max_allowed_packet from 8M to 16M
        or
        2. increase wait_timeout further from 3600 to 7200
        :: 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

        Loading...
        Working...
        X