Skip to main content

PhpMyAdmin and Website stalls

loccom
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?

Comments

7 comments

Date Votes
  • loccom
    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.
    0
  • cPanelMichael
    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.
    0
  • loccom
    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.
    0
  • cPanelMichael
    Hello, The MySQL error log is stored in the following location by default: /var/lib/mysql/$hostname.err Thank you.
    0
  • loccom
    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.
    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
    0
  • loccom
    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
    0
  • cPanelMichael
    I don't see anything abnormal. You could try running a MySQL tuner (after letting MySQL run for 24 hours) and then make changes to your /etc/my.cnf based on the results:
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post