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(a)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-----