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.
The logs are usually in the /var/log/ directory. I suggest you install munin on both systems to find out why exactly you are having problems. http://www.howtoforge.com/server_monitoring_with_munin_monit_fedora_7
Dear Falko, The servers are install on remote location and I have read the documentation it should be able to work right.