Adding an index without rebuilding all others

Hello list, I have a big table, 25M records and a lot of indexes on it. Sometimes, it happens that we need to create an new index on the table, and I was wondering if there is a solution to do an ALTER TABLE... ADD INDEX without having mySQL to rebuild all indexes ? Thanks, CheHax -- MySQL

Getting error 136 during an update

Hello there, I am receiving "Got error 136 from storage engine" and I need some light on this matter. I have a table with 23,000,000 records and I want to update it with datas from another one with the exact same amount of rows. The 2 tables can be linked by a primary key. Both tables are myISAM,

Fulltext in boolean mode and ordering. Is there a way to avoid filesorting ?

Hello there, Another Fulltext question :) Yeah, I've been working a lot on this stuff now :) I have a request to search companies in a huge database: SELECT CID FROM tblCompany WHERE MATCH (CompanyName) AGAINST ('Toyota Robert' IN BOOLEAN MODE) In boolean mode, my results are not sorted by rele

Re: FULLTEXT Exact phrase search including quotes

nd between double quotes in my fulltext search, just as in example 2. But what if they want to find "plastique ou carton" ? â If the value of my field is : Fabrication de "Plastique ou carton" and I want to search for this exact phrase, including double quotes, what should my req

Re: LOAD INDEX INTO CACHE problem

Hi! The change of key_buffer_size worked like a charm. Thank you ! CheHax -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]