比如添加一下几个配置

    max_connections=1000
    wait_timeout=100
    interactive_timeout=100
    skip-name-resolve

     

    必须把这些内容添加到 [mysqld]的后面。

    我之前是添加到整个文件的结尾处。结尾的处已经不是[mysqld]的配置了 。比如如下的配置文件 如果加到结尾处。不会生效。

     

    [mysqld]
    port            = 3306
    socket          = /usr/local/mysql/var/mysql.sock
    skip-locking
    key_buffer = 16M
    max_allowed_packet = 1M
    table_cache = 64
    sort_buffer_size = 512K
    net_buffer_length = 8K
    read_buffer_size = 256K
    read_rnd_buffer_size = 512K
    myisam_sort_buffer_size = 8M

    [mysqldump]
    quick
    max_allowed_packet = 16M

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

    [isamchk]
    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M

    [myisamchk]
    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M

    [mysqlhotcopy]
    interactive-timeout