Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

PhpMyAdmin and Website stalls

Discussion in 'Database Discussion' started by loccom, May 20, 2015.

  1. loccom

    loccom Member

    Joined:
    Aug 3, 2006
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    151
    HI

    I have moved to a new server and I am getting issues with it. The server is pretty meaty so it's not a performance issue.

    Basically in phpMyAdmin i will be trying to select another database and it will take 30 seconds or sometimes will not load and I have to refresh phpmyadmin.

    On the website forum when i go to start a new topic it stalls and takes 20 secs to load, also 20 secs to post the topic, but replying to a topic works fine. The rest of the site loads fine too, pretty snappy.

    I have had another hanging issues and I think its when something is requested from the database. Cached pages work fine.

    I have not however optimized my.cnf yet. Could this be the issue?

    Only have the following

    default-storage-engine=MyISAM
    innodb_file_per_table=1
    max_allowed_packet=268435456
    open_files_limit=10000

    I have added
    log=/var/lib/mysql/general.log

    to see what the logs report.

    Anyone can give me any ideas what could be causing this?
     
  2. loccom

    loccom Member

    Joined:
    Aug 3, 2006
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    151
    been trying to figure ths out for hours.

    Seems that when a script inserts it hangs and is very slow. Updated mysql, still the same.

    Server is empty so not under any load either.
     
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Do you notice any entries in the MySQL error log? Is your load average or disk I/O high when this happens?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. loccom

    loccom Member

    Joined:
    Aug 3, 2006
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    151
    I dont think my general.log file working. I will look at this again.

    My slow log file is filling up but I dont know what I am looking for in this.

    The server is new, no traffic to it yet. So no load or high I/O

    I have tailed error logs for missing files but nothing relevant shows when I am trying to post. So cannot be missing files.

    I updated Mysql just in case it was that.

    I previously imported the databases in from a non cpanel server.

    They seem to run fine and quick, just inserting data seems to be the issue.
     
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    The MySQL error log is stored in the following location by default:

    /var/lib/mysql/$hostname.err

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. loccom

    loccom Member

    Joined:
    Aug 3, 2006
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    151
    I checked this and I tried to post and then view the logs but nothing relevant showed. They show me restarting mysql but I dont think there are any errors reported.


    Code:
    2015-05-20 19:32:01 16537 [Warning] /usr/sbin/mysqld: Forcing close of thread 2756  user: 'eximstats'
    
    
    2015-05-20 19:32:01 16537 [Note] Binlog end
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'partition'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'ARCHIVE'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_METRICS'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_CMPMEM'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_CMP'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_LOCKS'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'INNODB_TRX'
    
    2015-05-20 19:32:01 16537 [Note] Shutting down plugin 'InnoDB'
    
    2015-05-20 19:32:01 16537 [Note] InnoDB: FTS optimize thread exiting.
    
    2015-05-20 19:32:01 16537 [Note] InnoDB: Starting shutdown...
    
    2015-05-20 19:32:03 16537 [Note] InnoDB: Shutdown completed; log sequence number 237457171
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'BLACKHOLE'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'MRG_MYISAM'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'CSV'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'MEMORY'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'MyISAM'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'sha256_password'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'mysql_old_password'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'mysql_native_password'
    
    2015-05-20 19:32:03 16537 [Note] Shutting down plugin 'binlog'
    
    2015-05-20 19:32:03 16537 [Note] /usr/sbin/mysqld: Shutdown complete
    
    
    150520 19:32:03 mysqld_safe mysqld from pid file /var/lib/mysql/XXXXXXXXX.com.pid ended
    
    150520 19:32:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    
    2015-05-20 19:32:04 0 [ERROR] /usr/sbin/mysqld: ambiguous option '--log=/var/lib/mysql/general.log' (log-bin, log_slave_updates)
    
    2015-05-20 19:32:04 0 [ERROR] Aborting
    
    
    2015-05-20 19:32:04 0 [Note] Binlog end
    
    150520 19:32:04 mysqld_safe mysqld from pid file /var/lib/mysql/XXXXXXXXXX.com.pid ended
    
    150520 19:32:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
     
    #6 loccom, May 20, 2015
    Last edited by a moderator: May 20, 2015
  7. loccom

    loccom Member

    Joined:
    Aug 3, 2006
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    151
    IOStat Information:
    avg-cpu: %user %nice %system %iowait %steal %idle
    0.37 0.00 0.09 0.01 0.00 99.53
    Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
    sdb 0.27 0.32 84.08 258954 67459320
    sda 4.15 34.76 178.55 27890678 143248408
     
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice