Is it mysql or apache problem?

Discussion in 'Server Operation' started by newbie14, Jan 26, 2011.

  1. newbie14

    newbie14 New Member

    Dear All,
    I have a system with the web server(apache) and db(mysql) server install on separate machines. So at times when the traffic is high I can not access my system. So first I would like to know where is the error and where is the error log file will be stored ? Secondly below I have copied some snippet from the db server /var/lib/mysql/mysql-bin.err

    Code:
    10124 11:52:12 [ERROR] /usr/libexec/mysqld: Sort aborted
    110124 11:52:12 [ERROR] /usr/libexec/mysqld: Sort aborted
    110124 11:52:12 [ERROR] /usr/libexec/mysqld: Sort aborted
    110124 11:52:14 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110124 11:52:19 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110124 12:30:27 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110124 12:30:30 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110124 12:30:31 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110124 15:17:16 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110124 15:17:19 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110124 15:17:19 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110125 14:21:53 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110125 14:21:58 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110125 14:24:20 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110125 21:46:56 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110125 21:46:58 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110125 21:46:59 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110126 12:18:53 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110126 12:18:55 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110126 12:18:56 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110126 12:43:08 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110126 12:43:11 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110126 12:43:12 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110126 14:24:26 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110126 14:24:29 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110126 14:24:32 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110126 14:33:43 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110126 14:33:45 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110126 14:33:46 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    110126 17:27:54 [Note] /usr/libexec/mysqld: Normal shutdown
    
    110126 17:27:56 [Note] /usr/libexec/mysqld: Shutdown complete
    
    110126 17:30:17 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
    Below is the snippet from /var/log/mysqld.log
    Code:
    110124 11:52:15  mysqld started
    110124 12:30:30  mysqld ended
    
    110124 12:30:31  mysqld started
    110124 15:17:19  mysqld ended
    
    110124 15:17:19  mysqld started
    110125 14:21:58  mysqld ended
    
    110125 14:24:19  mysqld started
    110125 21:46:58  mysqld ended
    
    110125 21:46:59  mysqld started
    110126 12:18:55  mysqld ended
    
    110126 12:18:56  mysqld started
    110126 12:43:11  mysqld ended
    
    110126 12:43:12  mysqld started
    110126 14:24:29  mysqld ended
    
    110126 14:24:30  mysqld started
    110126 14:33:45  mysqld ended
    
    110126 14:33:46  mysqld started
    110126 17:27:56  mysqld ended
    
    110126 17:30:16  mysqld started
    So what else must I do to find out where is the error? Is there any general log file which store the error on fedora? Can it be the error due to apache it self? What must I tune further because so far the max connection for the db is set to 900? Thank you.
     
  2. falko

    falko Super Moderator ISPConfig Developer

  3. newbie14

    newbie14 New Member

    Dear Falko,
    The servers are install on remote location and I have read the documentation it should be able to work right.
     

Share This Page