Fulltext search

2002-01-09 Thread Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC
Hello Recently we have installed mysql ver 4.0.1(from binaries).We loaded about 1.6 million records in a table. One of the fields 'ti' is text field. We created fulltext index on this field. on giving following :- 1. select ti from p8387 where match ti against ('computer'); 1701 rows were

Indexing is slow

2001-07-05 Thread Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC
We are using mysql 3.23.39 . We have the table p6882 with following structure : +---+-+--+-+-+-- --+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+-- --+ | id| int(10)

how to split database and index

2001-05-10 Thread Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC
Hello We have a database of size 10GB and its index is also almost of the same size. Now we want this database in MYSQL. Please let me know how we can slpit it across 3-4 hard disks.We are using Linux 6.2 Kind Regards Pawan ---