Show status of table question

[Bart Pietercil]

On 24-sep-07, at 20:11, Ruslan Zasukhin wrote:

> On 24/9/07 9:00 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
> Hi Bart,
>
>> Hi List,
>>
>> Is it expected behaviour that a table with 5 records in it has in the
>> show status for table tblx and ADD Record  = 0.
>
>> I am aware that I did not use add record but inserted records through
>> SQL. Shouldn't an insert record augment the ADD record counter
>> If this is expected that what use has ADD Record (as a counter)?
>
> SHOW STATUS show runtime counters !
>     they are NOT saved into db.
>
> So each new start they go from ZERO.

AHA

I believe this is nowhere to be found in the WIKI. I must say I only  
read the page show status for table.
Please add this to WIKI


>
>
> Or you mean that you have
>     START
>     INSERT 5 records
>     SHOW STATUS => ZERO


nope I restarted
>
> ?
>
Regards

Bart