We are in the process of migrating this forum. A new space will be available soon. We are sorry for the inconvenience.

Konfiguracja MYSQL


Offline
12-10-2010, 22:21
Witam

Poszukuję normalnego bardziej optymalnego configu dla mojego serwera aktualnie posiadam taki config lecz bazy mysql bardzo mulą i mysql się zawiesza prosił bym o pomoc w optymalizacji tego configu.

Kod:
 [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-innodb
    max_connections = 500
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 1800
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M

    [mysql.server]
    user=mysql