Re: slave crash
Posted by:
Jacky Shu
Date: August 01, 2012 08:43AM
> A "temporary table" and the "tmp directory" are unrelated animals.
Agreed. they came together the appl use temporary table (I know its bad, easy to break replication, trying to educate developers stop temporary completely) and load data file, which is in tmp directory. In this case, because it is a slave, so slave_load_tmpdir is same as tmpdir to avoid the default /tmp dir. So the interesting part is I can see slave_load_tmpdir has the value I set, but the tmp file to load is still in /tmp dir. Looks like a bug to me.
>key_buffer_size=4294967296
The box has 30GB RAM, with some big myisam tables over 10GB.
Subject
Views
Written By
Posted
2223
July 31, 2012 12:48PM
926
August 01, 2012 06:13AM
1590
August 01, 2012 06:30AM
982
August 01, 2012 06:32AM
1134
August 01, 2012 06:48AM
1153
August 01, 2012 06:40AM
1145
August 01, 2012 07:31AM
1137
August 01, 2012 08:30AM
1217
August 01, 2012 08:41AM
Re: slave crash
983
August 01, 2012 08:43AM
993
August 02, 2012 09:08AM
1144
August 01, 2012 08:34AM
1117
August 02, 2012 12:54PM
921
August 03, 2012 08:44AM
974
August 03, 2012 08:51AM
1743
August 03, 2012 01:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.