Hello, Victoria Reznichenko, The p_showing table,the following is the create table sql statement.
| p_showing | CREATE TABLE `p_showing` ( `showing_timestamp` timestamp(14) NOT NULL, `showing_channel_name` varchar(50) NOT NULL default '', `showing_asset_name` varchar(50) NOT NULL default '', `showing_start_time` datetime default NULL, `showing_keywords` varchar(100) default NULL, `showing_ip` varchar(15) NOT NULL default '', `showing_port` varchar(10) NOT NULL default '', `showing_end_time` datetime default NULL, `showing_resource` varchar(20) NOT NULL default '', `showing_status` varchar(20) NOT NULL default '', `showing_AutoDelte` varchar(5) NOT NULL default '', `showing_Feed` varchar(20) NOT NULL default '', `showing_Interactive_Control` varchar(5) NOT NULL default '', `showing_start_time_ctime` datetime default NULL, `showing_end_time_ctime` datetime default NULL, `showing_URL` varchar(100) NOT NULL default '', `source_ip` varchar(15) default NULL ) TYPE=HEAP | Mysql Version mysqladmin Ver 8.40 Distrib 4.0.12, for pc-linux on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.12-standard-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 day 5 hours 9 min 2 sec Threads: 4 Questions: 1005973 Slow queries: 22 Opens: 102 Flush tables: 1 Open tables: 78 Queries per second avg: 9.586 Thank u in advance ======= At 2003-11-03, 14:51:00 you wrote: ======= >"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] = = = = = = = = = = = = = = = = = = = = Best regards. MaFai [EMAIL PROTECTED] 2003-11-04 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
