Specializing in big data deployments using MySQL / NoSQL Solutions. Topics: [mysql tutorial] [database design] [mysql data types]
[database development] [mysql training] [mysql scalability] [mysql sharding] [mysql performance tuning]
I am facing some issue in setting innodb_log_file_size parameter in MySQL server even after following the steps mentioned above.When i tried increasing the innodb_log_file_size to 128M (1/4th of innodb_buffer_pool_size), it throws errors like incorrect imformation in file dbname.tablenane.frm files.The current values of innodb variables in my.cnf are shown below:innodb_log_buffer_size = 8Minnodb_log_file_size = 5Minnodb_buffer_pool_size = 512MI came to know from some forums that innodb_log_buffer_size should never be greater than innodb_log_file_size which is currently true in case.Can you please help me out on this?Should i reset the value of innodb_log_buffer_size to its default 1MB and then change the innodb_log_file_size?Please let us know your thoughts.Thanks.
I dont understand why MySQL documentation doesnt say this, i thought the system made the change by itself. Thanks a lot!. ubuntu 10.10 64bit mysql 5.1.49
Post a Comment