mysql memory leak - not the database, ME!

problem: keep forgetting this for some reason

what im not doing: googling it and rattling through 4-5 site before i find 'the one'

so, here it is... find auto-increment value of database

SHOW TABLE STATUS LIKE 'table_name';

and, reset the value

ALTER TABLE tablename AUTO_INCREMENT = value;

and if i have to insert somewhere in the middle

SET insert_id = value;

then run insert query

meaning to log this for ages!