MySQL Bugs: #9028: Full text search hangs mysql with 100% CPU

Bug #9028	Full text search hangs mysql with 100% CPU
Submitted:	7 Mar 2005 20:09	Modified:	2 May 2005 10:55
Reporter:	JJWR WR	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: FULLTEXT search	Severity:	S1 (Critical)
Version:	4.1.10	OS:	Any
Assigned to:		CPU Architecture:	Any

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Execute this sql script on any database to create the table to reproduce the bug

Attachment: createtable.txt (text/plain), 279 bytes.

After creating the table, execute this php script to crash the server. You must edit it and set your mysql connection parameters

Attachment: crash.php (application/octet-stream, text), 1.17 KiB.