maria-discuss team mailing list archive

[Michael Widenius <monty@xxxxxxxxxxxx>]

Hi!

>>>>> "Paul" == Paul McCullagh <paul.mccullagh@xxxxxxxxxxxxx> writes:

<cut>

Paul> PBXT can help you out with this. Do the following:

Paul> (1) Load the telpbxt table with a few 1000 rows (or use telpbxt2,  
Paul> since telpbxt already has too many rows in it).
Paul> (2) In mysql client enter: CHECK TABLE telpbxt2; (note: do not do this  
Paul> on a table with millions of rows. It will take very long to complete).
Paul> (3) Check the MySQL error log, you should see something like the  
Paul> output below.

Paul> CHECK TABLE: ./test/telpbxt
Paul> Record buffer size      = 1024
Paul> Fixed length rec. len.  = 1020
Paul> Handle data record size = 638
Paul> Min/max header size     = 14/26
Paul> Min/avg/max record size = 19/624/1019
Paul> Avg row len set for tab = not specified
Paul> Rows fixed length       = NO
Paul> Maximum fixed size      = 16384
Paul> ...

Paul> Paste the output in an e-mail, and I will show you what to use for the  
Paul> AVG_ROW_LENGTH.

Would it be hard for PBXT to as part of the CHECK TABLE add:

Optimial create AVG_ROW_LENGTH: ?

Regards,
Monty