MaxClients setting, consider raising the MaxClients settingのerrorlogの続き
再度MaxClientsのでサーバーダウンしたので
GIGAZINEのLoadAverageを「27」から「2」へ下げた方法 - GIGAZINE
を参照して設定変更
httpd.conf
「KeepAliveTimeout」を「1」
mysqlのエラーログの場所
my.cnfで設定
log-err=/path/to/log
mysqlのチューニングも必要なのか？
slowlogを仕掛けておく
MySQLお勉強メモ(SQLチューニング編) | きぬろぐ
log_output=FILE
log-slow-queries=/tmp/mysql_slow.log
log_query_time=1
log-queries-not-using-indexes
mysql.logにエラーがでていたので解消するためmysqlをアップグレードする
MySQL5.5の起動時【Native table 'performance_schema'.'????' has the wrong structure】について - nemunemu10の日記
[code]
111221 21:52:10 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
111221 21:52:10 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
111221 21:52:10 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
111221 21:52:10 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
111221 21:52:10 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
111221 21:52:10 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
111221 21:52:10 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50077, now running 50514. Please use mysql_upgrade to fix this error.
[/code]
mysql_upgrade -u ユーザ名 -p Enter password:パスワード
様子見