[Phpmyadmin-devel] Bugs #461192 & 463683 and 2.2.1 release and bug

[Robin Johnson]

> > question about translating: someone explain how/ where overhead is
> > used? i cannot produce it.
> It's used in the "Space usage" part of the table properties and print view. I
> guess it only exists for certain table types though; I don't seem to be able
> to make it show either, and I can't tell where it would come from by looking
> at the code.

follow the simple set of instructions below to make it show up (and go
away again)

# use the test database, create a table, and put some data in
USE test;
CREATE TABLE a ( a varchar(255) default NULL ) TYPE=MyISAM;
INSERT INTO `a` (`a`) VALUES ('fooooooofooooooofooooooo');
INSERT INTO `a` (`a`) VALUES ('fooooooofoooooooWHAM');
INSERT INTO `a` (`a`) VALUES ('fooooooofoooooooBAR');
# now look at the properties of the table, no overhead yet
DELETE FROM a WHERE a='fooooooofoooooooWHAM';
# now look at the properties of the table again, there is an overhead now
OPTIMIZE TABLE a;
# now look at the properties of the table yet again, overhead gone

-- 
Robin Hugh Johnson
"Robbat2"
QTOD: "I used to be an idealist, but I got mugged by reality."
E-Mail     : robbat2 at orbis-terrarum.net
ICQ#       : 30269588 or 41961639
Home Page  : http://www.orbis-terrarum.net
Time Zone  : Pacific Daylight (GMT - 8)
-----BEGIN GEEK CODE-----
geekcode.com ebb.org/ungeek
GCS/M/IT d-(+) s+:- a--- C++++ 
U++++ L++++ P--(+) W++ K++ PS+ 
N++ w--- O E---- M-(+) V-- Y++ 
PE++ PGP++ t-- 5 X+ R tv- b+++ 
D++ G++ e(*) h! r-- !y+
------END GEEK CODE------
-----PGP INFO-{---
Key ID:0x7E20DFA1
FingerPrint:
5447C73A 30FB144C 89521B69 2D6A615E 7E20DFA1
---}-PGP INFO-----