Re: How to determine index size ?

[Rolando Edwards]

According to Chapter 6 of the MySQL Reference Manual,
ISBN 0-596-00265-3, Page 453
Year values 00-69 are the years 2000-2069
Year values 70-99 are the years 1970-1999

A date value would have to be based on the size
of a UNIX date long integer, the number of seconds
since 12:00AM, January 1, 1970

Try create a test table with just one column, a DATETIME,
populate it with a year's worth of seconds. Then two years,
then four years. Just examine the size of the .MYI file of the 
test table with each iteration.

----- Original Message -----
From: Alec Matusis <alecm@stripped>
To: mysql@stripped
Sent: Thursday, November 9, 2006 4:17:43 PM GMT-0500 US/Eastern
Subject: How to determine index size ?

What is the byte size of an index for datetime type column?
How can I compute disk space required if I want to add an index on a
DATETIME column?
 
Thanks



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1