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.
>
Hi Ruslan,

could I make a FR for a RESET STATUSVARIABLES (object, specific  
variable)

This would augment the value of having these variables. The only way  
now to reset the variables is restart the server. That seems to be a  
bad idea (in the long run).
Wouldn't it be nice if you could have an event (scheduled) that  
resets certain counters for certain tables. It would be very usefull  
info on the load of the server when one starts collecting the  
variables values for fixed slices of time. This way we could generate  
usefull statistics over time.

just an idea


Bart