Hi again.
PROCESS LIST is:
Creating tmp file Repair by sorting
The problem occurs while repair by sorting.
myisam parameters have been increased accordingly: myisam max extra sort file size = 15000M myisam max sort file size = 15000M
There must be a bug somewhere? What do you suggest?
Vincent
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
