Announcement

Collapse
No announcement yet.

Mysql Server crashes all couple of minutes.

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

  • 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

  • #2
    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.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment

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