my.cnf settings specifically for myisamchk

2011-02-05 Thread Hank
Hello All, I have a new install of CentOS 5.5. 64bit running MySQL 5.5. This box has 8GB of memory and is running nothing else other than mysql. Shortly, I will be copying over a 80GB database from a Mysql 4.1.x server, and need to repair/upgrade most of the tables. I'm using myisamchk to d

Re: writing to disk at a configurable time

2011-02-05 Thread Cui Yuming
hi,all, I belive this is a very interesting problem。 For some very unimportant data, could we can set any hidden option or variables to cause the innodb redo log file to be flushed to disk once 5,10 or 60 seconds for better performance? robincui -- Original --