merge tables

[Shamim Shaik]

I read the manual and i am still confused as to how the merge tables use 
indexes. 
 
Can someone help me with this ? 
 
 
 


-
Do you Yahoo!?
 Yahoo! Mail - Easier than ever with enhanced search. Learn more.

Re: load data from master

[Shamim Shaik]

I cannot stop or lock tables on the master webapps write data to it constantly.
 
I am copying over the binlogs and applying them to the slave. 
 
It is taking a long time so I just want to know if load data or copying tables 
over would bring replication back to where it is. 
 
I

Renato Golin <[EMAIL PROTECTED]> wrote:
On Tuesday 29 March 2005 11:26, Shamim Shaik wrote:
> Can I run load data from master on myisam tables where my table size is
> approx 30G?

- stop slave
- on master do:
- lock tables
- tar cpf - /var/lib/mysql/tbl | ssh -C slave tar xpf - -C /var/lib/mysql/tbl
- start slave
- on master again:
- unlock tables

It's faster, but will keep you out of order untill all data is copied.

--rengolin



-
Do you Yahoo!?
 Yahoo! Small Business - Try our new resources site! 

load data from master

[Shamim Shaik]

Can I run load data from master on myisam tables where my table size is approx 
30G?
 
Is there a better way to do this ? 


-
Do you Yahoo!?
 Yahoo! Small Business - Try our new resources site! 

my.cnf setup

[Shamim Shaik]

I have lot of update/insert queries as well as select queries with a lot of 
sorts. Please let me know what settings should I use for optimal performance. I 
am using MyISAM tables. 
The db size is 30 G. 
 
Thanks 
 
 


-
Do you Yahoo!?
 Yahoo! Small Business - Try our new resources site!