The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

PhpMyAdmin and Website stalls

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

  1. loccom

    loccom Member

    Joined:
    Aug 3, 2006
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,745
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. loccom

    loccom Member

    Joined:
    Aug 3, 2006
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,745
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  6. loccom

    loccom Member

    Joined:
    Aug 3, 2006
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,745
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page