Hi! On Jul 06, Vincent Bouret wrote: > Hi, > > I got the following values: > key_buffer_size = 256M > myisam max extra sort file size = 8000M > myisam max sort file size = 8000M > myisam sort buffer size = 128M > > But that big table (MYD = 2397 MB), rows = 5 355 866 still won't index > in full text. > > Disk space is enough (25GB of free space), no error reported in the log. > > Using MySQL 4.0.14, doesn't work better with 4.0.20 (running under Win32). > > Where should I look at?
probably myisam_max_sort_file_size is too small for 2GB table. read the manual about this variable, and increase accordingly. check show processlist during indexing Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]