MySQL Forums
Forum List  »  Merge Storage Engine

Re: Tables not merged properly.
Posted by: Nadine Song
Date: February 16, 2007 09:38AM

Hi, Ingo

Thanks a lot for your help. MySql version is 4.0.15. The following is all information you aksed for about my question. I copied it to you as below. Please advise. Thanks.

mysql> SHOW TABLE STATUS;

+-----------------------+--------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+----------------------------------------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment |
+-----------------------+--------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+----------------------------------------------------+
| barlog_2005 | MyISAM | Dynamic | 408435 | 38 | 15723364 | 4294967295 | 3678208 | 0 | NULL | 2007-02-13 18:16:55 | 2007-02-13 18:16:57 | NULL | | |
| barlog_2006 | MyISAM | Dynamic | 436450 | 38 | 16595340 | 4294967295 | 4613120 | 0 | NULL | 2007-02-13 18:17:15 | 2007-02-13 18:17:18 | 2007-02-15 13:25:46 | |
| barlog_merged | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Can't open file: 'barlog_merged.MRG'. (errno: 143) |


mysql> show create table barlog_2005;
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| barlog_2005 | CREATE TABLE `barlog_2005` (
`prefix` varchar(6) default NULL,
`dbase` varchar(35) default NULL,
`access_time` datetime default NULL,
`log_id` int(10) NOT NULL default '0',
PRIMARY KEY (`log_id`)
) TYPE=MyISAM |
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table barlog_2006;
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| barlog_2006 | CREATE TABLE `barlog_2006` (
`prefix` varchar(6) default NULL,
`dbase` varchar(35) default NULL,
`access_time` datetime default NULL,
`log_id` int(10) NOT NULL default '0',
PRIMARY KEY (`log_id`)
) TYPE=MyISAM |
+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table barlog_merged;
ERROR 1016: Can't open file: 'barlog_merged.MRG'. (errno: 143)

Options: ReplyQuote


Subject
Views
Written By
Posted
6847
February 15, 2007 03:04PM
5004
February 16, 2007 03:05AM
Re: Tables not merged properly.
4809
February 16, 2007 09:38AM
4732
February 27, 2007 11:23AM


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.