Re: help with locate() function and index

cution takes more than 30 seconds and I would like to improve this. I tried fulltext index on this field hoping that locate() will be faster, but it dint make any difference. It would be great help if you could help solve this problem. thanks On 6/24/06, John Hicks <[EMAIL PROTECTED]> wro

help with locate() function and index

Hi, I am trying to use locate() function to get position of a substring in a text field which on average has 2000 characters and the search substring is 30 -50 characters long. The table has around 2 million records and looking for a efficient way to do the search. I tried fulltext index but dint

Key Buffer Size

Hi, huge-my.cnf specifies that total memory usage be less than 2 G. What is meant by total memory usage ? Is it some of key_buffer + innodb_buffer_pool_size + record_buffer or does the total memory usage not include innodb_bbufer_size. How are these buffers used ? Are they obtained using malloc in

RE: changing a slave to a master in mysql replication

Bhavin Vyas wrote Tuesday, September 03, 2002 9:02 PM in response to: >>To: Vicky Gonzalez; [EMAIL PROTECTED] >>Subject: Re: changing a slave to a master in mysql replication >>bin-log in 'needed' for a server to act as a master. This will make the server log all i

changing a slave to a master in mysql replication

tion that I missed? Thanks in advance for any help. ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

mysql replication protocol

Hi, Does anyone know what protocol is used for the mysql replication process? Is it TCP or something proprietary? Thanks! ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

High Availability and MySql Replication

(getting ready to become a master) and the RESET MASTER and CHANGE MASTER TO done on the old master? Any help is great appreciated. Thanks!! ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual

RE: Replication Question

From: Paul DuBois on August 13, 2002 11:13 AM wrote in response: At 11:10 -0700 8/13/02, Vicky Gonzalez wrote: >Hi all, > >I am a newbie here. I was hoping someone would be able to tell me if >hostnames for the Linux OS is required for MySql Replication, and if >so why? I have b

Replication Question

!!! ~Vicky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail &