Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2012
    Posts
    75

    WHM taking too much time to respond restoring backups and terminating accounts

    I noticed this recently. My whm is taking too much time restoring cpanel backups as well as terminating accounts.
    I recieved a cron mail with this info
    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95'

    Please help.
    what could be wrong and what can I do to fix this ?
    Thanks

  2. #2
    Join Date
    May 2013
    Location
    India
    Posts
    748
    what does "top -c" command output shows when you experience the slowness?

  3. #3
    Join Date
    May 2012
    Location
    India
    Posts
    1,026

  4. #4
    Join Date
    Apr 2012
    Posts
    75
    The last thing I can remember I did was editing my etc/my.cnf file adding some lines.
    I guess the problem is with my sql.
    I tried restarting it ang got this error
    "Waiting for mysql to restart....................................................................finished.


    mysql has failed, please contact the sysadmin (result was "mysql is not running").
    Please what can I do to resolve this ? sorry for my nob question please

  5. #5
    Join Date
    Apr 2012
    Posts
    75
    I tried checking the error log on /var/lib/mysql/$(hostname).err via SSH but got an error
    "Permission Denied"
    please how can I access the log file ?

  6. #6
    Join Date
    Apr 2012
    Posts
    75
    Thanks for that! it works well now.
    But I guess my problem is with the etc/my.cnf file I edited.
    Can someone please provide me with a Good etc/my.cnf file I can just use to replace mine ?
    please help if you can please with probably the one you are using.
    Thanks

  7. #7
    Quote Originally Posted by Lordemma View Post
    Thanks for that! it works well now.
    But I guess my problem is with the etc/my.cnf file I edited.
    Can someone please provide me with a Good etc/my.cnf file I can just use to replace mine ?
    please help if you can please with probably the one you are using.
    Thanks
    Something like

    Code:
    [mysqld]
    set-variable = max_connections=500
    log-slow-queries
    safe-show-database
    local-infile=0
    innodb_file_per_table=1
    and then use mysqltuner to optimize after.

  8. #8
    Join Date
    Jan 2006
    Location
    India
    Posts
    563
    Try vmstat and see if it is the disk i/o wait that is causing the issue.
    ►ExpertWebHost.NET- Instant reliable CPanel hosting since 2008+
    ►Quality Shared, Reseller and VPS hosting
    ►Choose to host from US/Uk/Canada/Netherlands/Australia - 10 locations

  9. #9
    Join Date
    Apr 2012
    Posts
    75
    here is my log file


    tail: no files remaining
    [email protected] [/]# tail -f /var/lib/mysql/$(hostname).err
    131223 00:47:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    131223 0:47:34 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
    131223 0:47:34 [Note] Plugin 'InnoDB' is disabled.
    131223 0:47:34 [Note] Plugin 'FEDERATED' is disabled.
    131223 0:47:34 [ERROR] Unknown/unsupported storage engine: InnoDB
    131223 0:47:34 [ERROR] Aborting

    131223 0:47:34 [Note] /usr/sbin/mysqld: Shutdown complete

    131223 00:47:34 mysqld_safe mysqld from pid file /var/lib/mysql/bestservers.gurushost.com.pid ended

  10. #10
    Join Date
    Nov 2002
    Location
    Portland, Oregon
    Posts
    2,948
    Still need some help with this? Would like to have a look at the outpt of the "show engines;" command.


    PHP Code:
    root@see-panel [~]# mysql

    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 4259
    Server version
    5.5.34-cll MySQL Community Server (GPL)

    Copyright (c20002013Oracle and/or its affiliatesAll rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates
    Other names may be trademarks of their respective
    owners
    .

    Type 'help;' or '\h' for helpType '\c' to clear the current input statement.

    mysqlshow engines;
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    Engine             Support Comment                                                        Transactions XA   Savepoints |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
    MyISAM             | DEFAULT | MyISAM storage engine                                          NO           NO   NO         |
    MRG_MYISAM         YES     Collection of identical MyISAM tables                          NO           NO   NO         |
    CSV                YES     CSV storage engine                                             NO           NO   NO         |
    BLACKHOLE          YES     | /dev/null storage engine (anything you write to it disappears) | NO           NO   NO         |
    MEMORY             YES     Hash basedstored in memoryuseful for temporary tables      NO           NO   NO         |
    PERFORMANCE_SCHEMA YES     Performance Schema                                             NO           NO   NO         |
    ARCHIVE            YES     Archive storage engine                                         NO           NO   NO         |
    FEDERATED          NO      Federated MySQL storage engine                                 NULL         NULL NULL       |
    InnoDB             YES     Supports transactionsrow-level locking, and foreign keys     YES          YES  YES        |
    +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ 
    ...can go from there depending on the output.

    Another option from a while ago is mysqlcheck.

    PHP Code:
    root@see-panel [~]# mysqlcheck -u root --auto-repair --optimize --all-databases 
    | John Edel Jetfire Networks L.L.C. Trusted Hosting Solutions
    | Consistent, Reliable, Stable OpenVZ & KVM Virtual Private Servers
    | SpamWall AV & Full SMTP Filtering
    Now an SSLStore Titanium Partner!

Similar Threads

  1. Restoring Backups WHM
    By kshazad86 in forum Hosting Security and Technology
    Replies: 5
    Last Post: 02-11-2011, 03:03 PM
  2. CPanel/WHM taking a VERY long time to install??
    By CymraegWalesHosting in forum Hosting Software and Control Panels
    Replies: 15
    Last Post: 07-20-2009, 12:14 AM
  3. WHM error when terminating accounts
    By zoogne in forum Hosting Security and Technology
    Replies: 5
    Last Post: 09-14-2006, 12:30 PM
  4. Restoring backups via WHM
    By Imago in forum Hosting Software and Control Panels
    Replies: 0
    Last Post: 08-12-2005, 06:11 AM
  5. WHM/Cpanel restoring backups
    By linuxperts in forum Hosting Security and Technology
    Replies: 0
    Last Post: 01-31-2005, 07:36 AM

Posting Permissions

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