capture log on specific time in linux servers
Dear Experts
We are having CRM application which is web-based runs on LAMP stack. the operation team reports between specific time period user get time out when they save the records or convert the records or retrieve the records, can you please suggest on how to capture log files which occurs during that time for example 5pm to 6pm, only during this time I would like to capture a following log files.
1) /var/log/mysql.log
2)/var/www/html/crmapp/crm
3) /var/log/slowquerylog
4)/var/log/httpd/error.log
please help with steps on above 1 to 4 log capture during specific time period , this will be helpful to investigate , thank you very much.
We are having CRM application which is web-based runs on LAMP stack. the operation team reports between specific time period user get time out when they save the records or convert the records or retrieve the records, can you please suggest on how to capture log files which occurs during that time for example 5pm to 6pm, only during this time I would like to capture a following log files.
1) /var/log/mysql.log
2)/var/www/html/crmapp/crm
3) /var/log/slowquerylog
4)/var/log/httpd/error.log
please help with steps on above 1 to 4 log capture during specific time period , this will be helpful to investigate , thank you very much.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
through epel installed mysqltuner-1.6.0-1.el6.noa
ASKER
did run the mysql tuner , please find the log report can you please help me with very much critical thing to do as a priority as users are not able to work at all. please find the attached
mysql-tunerlog.txt
mysql-tunerlog.txt
ASKER
with reference to the previous attached have added the following in /etc/my.cnf
query_cache_size (=0) earlier 1024M
query_cache_type (=0)
join_buffer_size (> 2.0G, or always use indexes with JOINs)
innodb_file_per_table=ON
innodb_buffer_pool_size (>= 55.2G) if possible.
innodb_log_file_size should be (=4G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
innodb_buffer_pool_instanc
I can see in the mysqltuner report following 2 lines should I have to increase the physical ram please suggest
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_size (=0) earlier 1024M
query_cache_type (=0)
join_buffer_size (> 2.0G, or always use indexes with JOINs)
innodb_file_per_table=ON
innodb_buffer_pool_size (>= 55.2G) if possible.
innodb_log_file_size should be (=4G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
innodb_buffer_pool_instanc
I can see in the mysqltuner report following 2 lines should I have to increase the physical ram please suggest
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
ASKER