MySQL™: The World’s Most Popular Open Source Database 162 4.0: Faster ... • SELECT COUNT(DISTINCT ...) ... • Bulk loading of data • Bulk updates of full text indexes • Removing all the rows in a table – TRUNCATE TABLE table_name; • SELECT * FROM table WHERE blob_col like "%keyword%" – Uses a fast turbo BoyerMore stringsearch • CREATE TABLE foo DATA DIRECTORY="/path/to/dir" INDEX DIRECTORY="/path/to/dir" – Support for spreading MyISAM files over many disks • Multithreaded index rebuilding in myisamchk Copyright 2003 MySQL AB