These options are used to specify the location of the respective files. If you do not set them they go to your datadir e.g. /var/lib/mysql http://www.mysql.com/doc/en/Replication_Options.html
relay-log=filename To specify the location and name that should be used for relay logs. You can use this to have hostname-independant relay log names, or if your relay logs tend to be big (and you don't want to decrease max_relay_log_size) and you need to put them on some area different from the data directory, or if you want to increase speed by balancing load between disks. relay-log-index=filename To specify the location and name that should be used for the relay logs index file - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED] -->Sent: Thursday, September 25, 2003 11:28 AM -->To: [EMAIL PROTECTED] -->Subject: replication setting --> -->Hi, --> -->I have question on replication setting in my.cnf --> -->what is the difference between relay-log and relay-log-index? If I do not -->set them, what will happen? --> -->thanks --> -->Hsiu-Hui --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED]