Announcement

Collapse
No announcement yet.

Mysql Server crashes all couple of minutes.

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

  • Wayne Luke
    replied
    If you are on a dedicated server I would advise that you request server optimization help by starting a thread in the Server Configuration forum supplying the information requested in this thread:

    http://www.vbulletin.com/go/tweak

    Since this is not an official service the response may not be as fast as you are used to in the ticket system.

    Leave a comment:


  • Articulador
    started a topic Mysql Server crashes all couple of minutes.

    Mysql Server crashes all couple of minutes.

    The process is killing mysql, please someone help me.

    Top Process %CPU 351 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.thegenius.ws.pid --skip-external-locking --port3306 --socket/var/lib/mysql/mysql.sock

    I have to days trying to solve this problem and I can not.

    I sent email to support and he told me that it is no problem on the server, I was asked to contact the holder of the vBulletin them to verify and optimize the tables...

    Someone knows why this happens?

    Below is my my.cnf, and my server config

    port = 3306
    socket = / var / lib / mysql / mysql.sock

    # Here follows entries for some specific programs

    # The MySQL server
    [mysqld]
    port = 3306
    socket = / var / lib / mysql / mysql.sock
    skip-locking
    # key_buffer = 312M
    key_buffer = 128M
    max_allowed_packet = 1M
    # table_cache = 20000
    table_cache = 2048
    sort_buffer_size = 1M
    read_buffer_size = 4M
    read_rnd_buffer_size = 4M
    myisam_sort_buffer_size = 64M
    thread_cache_size = 8
    query_cache_size = 16M
    # Try number of CPU's * 2 for thread_concurrency
    thread_concurrency = 8
    # max_user_connections = 4000
    # max_connections = 10000
    max_connections = 1000
    long_query_time = 5
    log-slow-queries = / var / log / slow-sql.log

    max_heap_table_size = 16M
    tmp_table_size = 64M
    DC Softlayer
    Quad Core Xeon 5320 Clovertown
    4 GB Ram
    HD 400GB SCSI
    100 Mbps
    And I am also receiving many sql errors on my email.

    mysql_connect () [<a href='function.mysql-connect'> function.mysql-connect </ a>]: Can not connect to local MySQL server through socket '/ var / lib / mysql / mysql.sock' ( 11)
    / home / thege / public_html / forum / includes / class_core.php on line 311
    Please help me.

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