Professional Web Applications Themes

MySQL Crash - MySQL

Hi, MySQL server alway crash after some time. This the error in the windows EventViewer: Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619 My Hardware is 2,5 GB of RAM Where can I solve the problem? (I've have 150 web sites hosted in this server... I've also Apache installed on the same MySQL machine) This is my my.ini: port=3306 default-storage-engine=INNODB sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=800 query_cache_size=84M table_cache=1520 tmp_table_size=30M thread_cache_size=38 *** MyISAM Specific options myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=30M key_buffer_size=129M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K #*** INNODB Specific options *** innodb_additional_mem_pool_size=6M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=3M innodb_buffer_pool_size=512M innodb_log_file_size=50M innodb_thread_concurrency=10 thanks a lot...

  1. #1

    Default MySQL Crash

    Hi,
    MySQL server alway crash after some time.
    This the error in the windows EventViewer:
    Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619

    My Hardware is 2,5 GB of RAM
    Where can I solve the problem?

    (I've have 150 web sites hosted in this server... I've also Apache installed
    on the same MySQL machine)

    This is my my.ini:

    port=3306

    default-storage-engine=INNODB
    sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    max_connections=800
    query_cache_size=84M
    table_cache=1520
    tmp_table_size=30M
    thread_cache_size=38

    *** MyISAM Specific options


    myisam_max_sort_file_size=100G
    myisam_max_extra_sort_file_size=100G
    myisam_sort_buffer_size=30M
    key_buffer_size=129M
    read_buffer_size=64K
    read_rnd_buffer_size=256K
    sort_buffer_size=256K


    #*** INNODB Specific options ***

    innodb_additional_mem_pool_size=6M
    innodb_flush_log_at_trx_commit=1
    innodb_log_buffer_size=3M
    innodb_buffer_pool_size=512M
    innodb_log_file_size=50M
    innodb_thread_concurrency=10

    thanks a lot


    Andrea Guest

  2. #2

    Default Re: MySQL Crash

    == Quote from Andrea (net)'s article 


    looks like you may have an innodb heavy server. here's what mysql has for heavy
    innodb server:

    max_connections = 100
    max_connect_errors = 10
    table_cache = 2048
    max_allowed_packet = 16M
    binlog_cache_size = 1M
    max_heap_table_size = 64M
    sort_buffer_size = 8M
    join_buffer_size = 8M
    thread_cache_size = 8
    thread_concurrency = 8
    query_cache_size = 64M
    query_cache_limit = 2M
    ft_min_word_len = 4
    default_table_type = MYISAM
    thread_stack = 192K
    transaction_isolation = REPEATABLE-READ
    tmp_table_size = 64M
    long_query_time = 2
    server-id = 1
    key_buffer_size = 32M
    read_buffer_size = 2M
    read_rnd_buffer_size = 16M
    bulk_insert_buffer_size = 64M
    myisam_sort_buffer_size = 128M
    myisam_max_sort_file_size = 10G
    myisam_max_extra_sort_file_size = 10G
    myisam_repair_threads = 1
    innodb_additional_mem_pool_size = 16M
    innodb_buffer_pool_size = 2G
    innodb_data_file_path = ibdata1:10M:autoextend
    innodb_file_io_threads = 4
    innodb_thread_concurrency = 16
    innodb_flush_log_at_trx_commit = 1
    innodb_log_buffer_size = 8M
    innodb_log_file_size = 256M
    innodb_log_files_in_group = 3
    innodb_max_dirty_pages_pct = 90
    innodb_lock_wait_timeout = 120
    max_allowed_packet = 16M
    key_buffer = 512M
    sort_buffer_size = 512M
    read_buffer = 8M
    write_buffer = 8M
    key_buffer = 512M
    sort_buffer_size = 512M
    read_buffer = 8M
    write_buffer = 8M
    open-files-limit = 8192
    --
    POST BY: lark with PHP News Reader
    lark Guest

  3. #3

    Default Re: MySQL Crash

    Hi,
    no I've have a lot of MyISAM Tables.
    All my Db are MAMBO.
    I've only one inno tables for some db.
    How can I modify my config?

     


    Andrea Guest

  4. #4

    Default Re: MySQL Crash

    == Quote from Andrea (net)'s article [/ref]

    well, if you have a lot of myisam tables, try something like this:

    port = 3306
    socket = /tmp/mysql.sock
    skip-locking
    key_buffer = 384M
    max_allowed_packet = 1M
    table_cache = 512
    sort_buffer_size = 2M
    read_buffer_size = 2M
    read_rnd_buffer_size = 8M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    query_cache_size = 32M
    thread_concurrency = 8


    log-bin=mysql-bin
    --
    POST BY: lark with PHP News Reader
    lark Guest

  5. #5

    Default Re: MySQL Crash

    a little more that i should have added:
    innodb_buffer_pool_size = 16M
    innodb_additional_mem_pool_size = 2M
    # Set .._log_file_size to 25 % of buffer pool size
    innodb_log_file_size = 5M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 1
    innodb_lock_wait_timeout = 50
    --
    POST BY: lark with PHP News Reader
    lark Guest

  6. #6

    Default Re: MySQL Crash

    lark wrote: 

    one more thing:
    to change configuration on windows machine, you need to edit a file
    called "my.ini" usually in windows installation directory (c:\windows).
    lark Guest

Similar Threads

  1. #26208 [Fbk->Ver]: phpmyadmin-2.5.4 + mysql-4.0.15 = crash
    By iliaa@php.net in forum PHP Development
    Replies: 0
    Last Post: November 17th, 11:24 PM
  2. #26208 [Opn->Fbk]: phpmyadmin-2.5.4 + mysql-4.0.15 = crash
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: November 17th, 11:17 PM
  3. #26208 [NEW]: phpmyadmin-2.5.4 + mysql-4.0.15 = crash
    By temnota at kmv dot ru in forum PHP Development
    Replies: 0
    Last Post: November 11th, 08:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139