I would like to know where will my error logged for mysql server. As of now I just see one log that is in /var/log/mysqld.log. I saw some have .err files too am I missing something here? What would the ib_logfile contain will they contain those errors too? But we cant view them right?
Add a comment
|
1 Answer
The log buffer writes redo log information to ib_logfile0 and ib_logfile1 for transactional purposes only. There is nothing text readable within those files.
The file /var/log/mysqld.log is the main error-logging mechanism built in mysql. Anything additional would probably be in /var/log/messages.
answered May 24, 2012 at 11:24
-
I read your answer here dba.stackexchange.com/questions/1261/…. So in my case I got 8Gb ram what is the best I should set for my log file size? What would the additional log file be named as if any?– newbie14Commented May 24, 2012 at 13:15
-
That depends on the amount of InnoDB Data and Index Pages. innodb_log_file_size are supposed to be 25% of the innodb_buffer_pool_size. Please see dba.stackexchange.com/a/2194/877 for how to compute the proper size for your innodb_buffer_pool_size for your system Commented May 24, 2012 at 14:15
-
as I am just starting a new server so what is recommended setting for my case then since I dont have any huge data yet? Should I leave it and adjust later?– newbie14Commented May 24, 2012 at 17:38
-
Since you do not have sizeble data yet, you can leave InnoDB in its default state for now. When that time comes, please refer to my post on setting up caching for your storage engines : dba.stackexchange.com/a/2194/877 Commented May 25, 2012 at 23:51
-
I dont see anything about caching for innodb just the innodb_buffer_pool_size is that what you meant by caching here? So the recommended size now is 563M. So my innodb_log_size should be then 140M. But on a daily basis my data will be growing so how to maintain the both this values innodb_buffer_pool and innodb_log_file. So anytime in between I can stop the mysql server remove the log file and re-size it wont have any impact is it?– newbie14Commented May 26, 2012 at 2:49