This is the output from check table ArpMon; mysql> check table ArpMon; +--------------+-------+----------+---------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+-------+----------+---------------------------------------------------------+ | arpdb.ArpMon | check | warning | 0 clients is using or hasn't closed the table properly | | arpdb.ArpMon | check | warning | Size of datafile is: 1796436 Should be: 1796176 | | arpdb.ArpMon | check | error | Keypointers and record positions doesn't match | | arpdb.ArpMon | check | warning | Found 27507 parts Should be: 27498 parts | | arpdb.ArpMon | check | error | Corrupt | +--------------+-------+----------+---------------------------------------------------------+ 5 rows in set (0.85 sec)
-James On Wed, 2003-09-03 at 18:41, Paul DuBois wrote: > At 16:49 -0700 9/3/03, James Kelty wrote: > >So, we have this table: ArpMon that looks like this: > > > >-- mysql> describe ArpMon; > >+--------+---------------+------+-----+---------+-------+ > >| Field | Type | Null | Key | Default | Extra | > >+--------+---------------+------+-----+---------+-------+ > >| am_mac | varchar(20) | | PRI | | | > >| am_ip | varchar(255) | | PRI | | | > >| am_rtr | varchar(255) | YES | | NULL | | > >| am_if | int(10) | YES | | NULL | | > >| am_ts | timestamp(14) | YES | | NULL | | > >+--------+---------------+------+-----+---------+-------+ > > > >When I do a count(*) on this table, we get this result: > > > >mysql> select count(*) from ArpMon; > >+----------+ > >| count(*) | > >+----------+ > >| 27498 | > >+----------+ > >1 row in set (0.01 sec) > > > >Ok, that's good. But! If I run select * from ArpMon, I only get 111 entries > > That's odd. > > >and if I run select count(am_rtr) from ArpMon, I get 111 entries as well as > > That could, if you have only 111 non-NULL am_rtr values. > > >select am_rtr from ArpMon. > > > >But! It I run select am_mac from ArpMon, I get the 27498 entries. > > > >What's up with that? Can someone help me to figure this one out? > > What does CHECK TABLE ArpMon tell you? > > > > >-James > > > >James Kelty > >E-Commerce / Financial Systems Administrator > >Portland State University > >503.725.9152 > >[EMAIL PROTECTED] -- James Kelty E-Commerce / Financial Systems Administrator Portland State University 503.725.9152 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
