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.
<[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
-
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!
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
