Announcement

Collapse
No announcement yet.

mysql erro - need eva2000 help

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

  • mysql erro - need eva2000 help

    Help please:

    error:

    Link-ID == false, connect failed
    mysql error: Too many connections

    mysql error number: 1040

    DI dedicated server. P800 + 756MB ram - dual scsi

    PHP Version 4.1.2

    mysql 3.23.48

    VB 2.24 0 no hacks

    Contents of: /etc/my.cnf file:

    bind-address=127.0.0.1

    -------end

    +--------------------------+-----------+
    | Variable_name | Value |
    +--------------------------+-----------+
    | Aborted_clients | 0 |
    | Aborted_connects | 0 |
    | Bytes_received | 4884801 |
    | Bytes_sent | 268002973 |
    | Com_admin_commands | 0 |
    | Com_alter_table | 0 |
    | Com_analyze | 0 |
    | Com_backup_table | 0 |
    | Com_begin | 0 |
    | Com_change_db | 1548 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_commit | 0 |
    | Com_create_db | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_table | 0 |
    | Com_delete | 123 |
    | Com_drop_db | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_table | 0 |
    | Com_flush | 0 |
    | Com_grant | 0 |
    | Com_insert | 301 |
    | Com_insert_select | 4 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_load_master_table | 0 |
    | Com_lock_tables | 0 |
    | Com_optimize | 0 |
    | Com_purge | 0 |
    | Com_rename_table | 0 |
    | Com_repair | 0 |
    | Com_replace | 113 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_restore_table | 0 |
    | Com_revoke | 0 |
    | Com_rollback | 0 |
    | Com_select | 21443 |
    | Com_set_option | 39 |
    | Com_show_binlogs | 0 |
    | Com_show_create | 39 |
    | Com_show_databases | 0 |
    | Com_show_fields | 39 |
    | Com_show_grants | 0 |
    | Com_show_keys | 0 |
    | Com_show_logs | 0 |
    | Com_show_master_stat | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_processlist | 0 |
    | Com_show_slave_stat | 0 |
    | Com_show_status | 1412 |
    | Com_show_tables | 1 |
    | Com_show_variables | 9 |
    | Com_slave_start | 0 |
    | Com_slave_stop | 0 |
    | Com_truncate | 0 |
    | Com_unlock_tables | 0 |
    | Com_update | 2156 |
    | Connections | 256 |
    | Created_tmp_disk_tables | 6 |
    | Created_tmp_tables | 951 |
    | Created_tmp_files | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Delayed_errors | 0 |
    | Flush_commands | 1 |
    | Handler_delete | 209 |
    | Handler_read_first | 807 |
    | Handler_read_key | 194954 |
    | Handler_read_next | 674018 |
    | Handler_read_prev | 0 |
    | Handler_read_rnd | 186740 |
    | Handler_read_rnd_next | 4781946 |
    | Handler_update | 9238 |
    | Handler_write | 25810 |
    | Key_blocks_used | 6227 |
    | Key_read_requests | 971887 |
    | Key_reads | 6133 |
    | Key_write_requests | 8000 |
    | Key_writes | 7738 |
    | Max_used_connections | 100 |
    | Not_flushed_key_blocks | 0 |
    | Not_flushed_delayed_rows | 0 |
    | Open_tables | 64 |
    | Open_files | 117 |
    | Open_streams | 0 |
    | Opened_tables | 70 |
    | Questions | 25974 |
    | Select_full_join | 0 |
    | Select_full_range_join | 0 |
    | Select_range | 6698 |
    | Select_range_check | 0 |
    | Select_scan | 3202 |
    | Slave_running | OFF |
    | Slave_open_temp_tables | 0 |
    | Slow_launch_threads | 0 |
    | Slow_queries | 1 |
    | Sort_merge_passes | 0 |
    | Sort_range | 6253 |
    | Sort_rows | 519125 |
    | Sort_scan | 2044 |
    | Table_locks_immediate | 28846 |
    | Table_locks_waited | 1 |
    | Threads_cached | 0 |
    | Threads_created | 255 |
    | Threads_connected | 101 |
    | Threads_running | 1 |
    | Uptime | 5954 |
    +--------------------------+-----------+

    I restarted mysql but I think I need some edits to my.cnf please? Typical on line users is 20-30

    NOTE: $usepconnect = 1; and up untill today this has worked fine. No other databases. When I set this to 0 I get errors.

    Thanks in advance.
    Have a great day :)
    http://www.StopScum.com

  • #2
    mysql variables:

    http://www.searchblitz.com/mysql_variables.htm


    Edit:

    also see: http://www.geekcult.com/phpinfo.php
    Last edited by Steve_S; Thu 8th Aug '02, 11:20am.
    Have a great day :)
    http://www.StopScum.com

    Comment


    • #3
      yup my.cnf needs tweaking

      try this one
      [client]
      port = 3306
      socket = /var/lib/mysql/mysql.sock

      [mysqld]
      port = 3306
      socket = /var/lib/mysql/mysql.sock
      skip-locking
      set-variable = max_connections=350
      set-variable = key_buffer=16M
      set-variable = myisam_sort_buffer_size=64M
      set-variable = join_buffer=1M
      set-variable = record_buffer=1M
      set-variable = sort_buffer=2M
      set-variable = table_cache=1024
      set-variable = thread_cache_size=256
      set-variable = wait_timeout=3600
      set-variable = connect_timeout=10
      set-variable = max_allowed_packet=16M
      set-variable = max_connect_errors=10

      [safe_mysqld]
      open_files_limit=8192

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

      [myisamchk]
      set-variable = key_buffer=64M
      set-variable = sort_buffer=64M
      set-variable = read_buffer=16M
      set-variable = write_buffer=16M
      and restart mysql
      :: 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


      • #4
        much thanks DONE

        Question: this is a DI server so I left the first line from the original my.cnf in place in the following section :


        [mysqld]
        bind-address=127.0.0.1
        port = 3306
        socket = /var/lib/mysql/mysql.sock
        skip-locking
        set-variable = max_connections=350
        set-variable = key_buffer=16M
        set-variable = myisam_sort_buffer_size=64M
        set-variable = join_buffer=1M
        set-variable = record_buffer=1M
        set-variable = sort_buffer=2M
        set-variable = table_cache=1024
        set-variable = thread_cache_size=256
        set-variable = wait_timeout=3600
        set-variable = connect_timeout=10
        set-variable = max_allowed_packet=16M
        set-variable = max_connect_errors=10

        Is that OK?
        Have a great day :)
        http://www.StopScum.com

        Comment


        • #5
          bump
          Have a great day :)
          http://www.StopScum.com

          Comment


          • #6
            Originally posted by Steve_S
            much thanks DONE

            Question: this is a DI server so I left the first line from the original my.cnf in place in the following section :


            [mysqld]
            bind-address=127.0.0.1
            port = 3306
            socket = /var/lib/mysql/mysql.sock
            skip-locking
            set-variable = max_connections=350
            set-variable = key_buffer=16M
            set-variable = myisam_sort_buffer_size=64M
            set-variable = join_buffer=1M
            set-variable = record_buffer=1M
            set-variable = sort_buffer=2M
            set-variable = table_cache=1024
            set-variable = thread_cache_size=256
            set-variable = wait_timeout=3600
            set-variable = connect_timeout=10
            set-variable = max_allowed_packet=16M
            set-variable = max_connect_errors=10

            Is that OK?
            yeah that's fine
            :: 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


            • #7
              thank you kind sir

              see you on the "other side"
              Have a great day :)
              http://www.StopScum.com

              Comment

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