Results 1 to 6 of 6
  1. #1
    Join Date
    May 2013

    Server not responding while one user click


    I bought a service from , which to manage my server, my server worked fine until I bought a ssd for my server and asked them to transfer mysql from SATA to SSD because of many people recommended SSD.
    Now What is my problem?
    my site is kind of social website, which has so many query to be run. one of the page has a so heavy processing to be run. before transferring I could see some times some cores full 100%, but now when user visits the page, one core is 100% but other core suddenly get 0% and other users face with waiting!

    I asked they asked for 200USD, but I'm not affordable to pay. So open the topic to diagnose problem with myself.

    ** Also add picture of output 'htop'.
    this is picture of problem:
    Click image for larger version. 

Name:	problem.png 
Views:	33 
Size:	101.9 KB 
ID:	26649
    This is picture of normal:
    Click image for larger version. 

Name:	normal.png 
Views:	31 
Size:	14.3 KB 
ID:	26650

    I have a dedicate server with below specification:
    CPU: Dual Xeon L5520
    RAM: 36 GB DDR3
    HDD: 1TB SATA , 146GB SSD

    Centos 6.4
    Last edited by pejman_view; 10-17-2013 at 03:27 PM.

  2. #2
    Join Date
    May 2012

  3. #3
    Join Date
    May 2013
    Quote Originally Posted by kevincheri View Post
    Don't see any reason for that unless you have something in config limiting a query to 1 core maximum.
    I also change my.cnf configuration, found some configuration and mixed them and result is below.

    # From
    key_buffer = 384M
    key-buffer-size = 10G
    max_allowed_packet = 64M
    max_connections = 3500
    max_user_connections = 1000
    table_cache = 1024
    sort_buffer_size = 2M
    read_buffer_size = 8M
    read_rnd_buffer_size = 64M
    myisam_sort_buffer_size = 512M
    thread_cache_size = 8
    query_cache_size = 512M
    thread_concurrency = 8
    # SAFETY #
    max-allowed-packet             = 16M
    tmp-table-size                 = 32M
    max-heap-table-size            = 32M
    query-cache-type               = 0
    query-cache-size               = 0
    thread-cache-size              = 100
    open-files-limit               = 65535
    table-definition-cache         = 1024
    table-open-cache               = 2048
    # INNODB #
    innodb-flush-method = O_DIRECT
    innodb-flush-log-at-trx-commit = 1
    innodb-file-per-table = 1
    innodb-buffer-pool-size  = 8M

  4. #4
    Definitely sounds like your issue could be solved by optimizing mysql... to bad your host is asking for $200 to do so. The db doesn't seem so heavy that it would require a dedicated mysql box. I wish I had more to offer.
    Lee Linton - Hivelocity Hosting- Dedicated Account Manager
    Bare Metal Servers. Colocation. Private Cloud.
    Customers in over 130 countries. Privately Owned and Operated Data Centers.
    Limited Supply Outlet Server Specials

  5. #5
    Join Date
    Mar 2003
    Moved > Hosting Security and Technology .
    Specially 4 You
    JoneSolutions.Com ( Jones.Solutions ) is on the net 24/7 providing stable and reliable web hosting solutions and services since 2001

  6. #6
    I suggest you try percona mysql server. It has many tweaks and advantages over the standard mysql server. There's a lot of things you can optimize on your my.cnf, everything is documented on their page.

Similar Threads

  1. Server Not Responding
    By Irose in forum Hosting Software and Control Panels
    Replies: 8
    Last Post: 04-25-2013, 01:14 PM
  2. Server Down, WholeSaleInternet Not Responding!!
    By scribby in forum Dedicated Server
    Replies: 6
    Last Post: 01-24-2007, 07:03 AM
  3. Server Down, But responding to PING
    By WebHostingNeeds in forum Hosting Security and Technology
    Replies: 15
    Last Post: 02-20-2005, 08:40 PM
  4. Server Not Responding or...
    By ShaneS in forum Domain Names
    Replies: 7
    Last Post: 11-30-2003, 12:05 AM
  5. postgresql server is not responding
    By francois in forum Dedicated Server
    Replies: 4
    Last Post: 09-26-2002, 02:47 PM

Posting Permissions

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