"MaFai" <[EMAIL PROTECTED]> wrote: > Hello, mysql, > > The replication running smoothly between the master and slave,except that the heap > table can not be synchronized. > > While the master insert the record into the heap table,the slave would do the same > job. > While the master delete the record in the heap table,the slave wouldn't do so. > After serval days passed,the heap table would overloading in the slave,because it > never delete the record in heap table. > > The mysql seems doesn't support heap table in replication,right? > If yes,i should change the table type to innodb,although it would lose the > performance. > > The manaul doesn't mention this. > > Any idea apprecated. > > Env:Mysql 4.0,Linux Red Hat7,256mb ram. >
What exactly version of MySQL do you use? I tested replication with HEAP tables and all worked like a charm. Could you provide a test case? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
