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]
