Hi, Alexandre! On Jun 07, Alexandre hadjinlian guerra wrote: > Hi > > Im currently doing a reload process to an empty myisam table with 4 indexes > on Maria db 10 1 13 on win64 and noted that on the last step that the > status reports that its using repair to rebuild the table. > Myisam-repair-threads remain the default but noted that many threads were > running .im not sure if all of them were for repair. Is there any > recommendation which i should take using the referred setting with a > greater value?would setting it to zero make maridb decide which is there > best value? Would the indexes get too much fragmented ? Thanks!
No, you cannot set it to zero. Also, current implementation does not support an arbitrary number of myisam repair threads. Either you have it set to 1 (meaning, one thread will repair all indexes, one after another), or you set it to anything larger than 1 (that will always run one thread per index). See https://mariadb.com/kb/en/mariadb/myisam-system-variables/#myisam_repair_threads Regards, Sergei Chief Architect MariaDB and [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
