You are here

ndb_size.pl report for database foodmart (21 tables)

Connected to: DBI:mysql:database=foodmart;host=localhost

Including information for versions: 4.1, 5.0, 5.1

Table List

account

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
account_parent smallint(6) MUL 4 4 4
account_description varchar(30) Y 32 32 16*
account_rollup varchar(30) Y 32 32 4*
HIDDEN_NDB_PKEY bigint PRI 8 8 8
account_type varchar(30) Y 32 32 8*
account_id smallint(6) UNI 4 4 4
custom_members varchar(255) Y 256 256 120*
Fixed Size Columns DM/Row 368 368 16
Varsize Columns DM/Row 0 0 148

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_account_parent BTREE 16 16 16
i_account_id BTREE N/A N/A N/A
PRIMARY BTREE 16 16 16
Total Index DM/Row 32 32 32

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
account_account_id$unique 24 24 32
This DataMemory/Row 416 416 68
Total DM/Row (inludes DM in other tables) 440 440 100

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_account_parent N/A N/A N/A
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

account_account_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 416 416 68

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 160

Memory Calculations

No. Rows 11 11 11
Rows/32kb DM Page 78 78 480
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 204
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


account_account_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
HIDDEN_NDB_PKEY bigint PRI 8 8 8
account_id smallint(6) UNI 4 4 4
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 11 11 11
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 8 8 8


category

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
category_id varchar(30) PRI 32 32 32
category_parent varchar(30) MUL 32 32 32
HIDDEN_NDB_PKEY bigint PRI 8 8 8
category_description varchar(30) Y 32 32 24*
category_rollup varchar(255) Y 256 256 4*
Fixed Size Columns DM/Row 360 360 72
Varsize Columns DM/Row 0 0 28

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_category_parent BTREE 16 16 16
i_category_id BTREE N/A N/A N/A
PRIMARY BTREE 16 16 16
Total Index DM/Row 32 32 32

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
category_category_id$unique 52 52 60
This DataMemory/Row 408 408 124
Total DM/Row (inludes DM in other tables) 460 460 184

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_category_parent N/A N/A N/A
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

category_category_id$unique 57 16 16
Total Suppt IM/Row 57 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 408 408 124

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 40

Memory Calculations

No. Rows 4 4 4
Rows/32kb DM Page 80 80 263
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 816
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


category_category_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
category_id varchar(30) PRI 32 32 32
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 40 40 40
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 57 16 16
Indexes IM/Row 57 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 52 52 60

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 4 4 4
Rows/32kb DM Page 627 627 544
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 143 512 512
IndexMemory (KB) 8 8 8


currency

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
currency varchar(30) Y 32 32 12*
currency_id smallint(6) MUL 4 4 4
date date 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
conversion_ratio decimal(10,2) N/A N/A N/A
Fixed Size Columns DM/Row 48 48 16
Varsize Columns DM/Row 0 0 12

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_currency BTREE N/A N/A N/A
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
currency_currency_id_date$unique 28 28 36
This DataMemory/Row 80 80 52
Total DM/Row (inludes DM in other tables) 108 108 88

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

currency_currency_id_date$unique 33 16 16
Total Suppt IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 80 80 52

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 20

Memory Calculations

No. Rows 72 72 72
Rows/32kb DM Page 408 408 627
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 1632
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


currency_currency_id_date$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
currency_id smallint(6) MUL 4 4 4
date date 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 16 16 16
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 28 28 36

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 72 72 72
Rows/32kb DM Page 1165 1165 906
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


customer

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
customer_region_id int(11) MUL 4 4 4
address3 varchar(30) Y 32 32 4*
marital_status varchar(30) Y 32 32 4*
date_accnt_opened date 4 4 4
num_cars_owned int(11) 4 4 4
fname varchar(30) MUL 32 32 32
total_children smallint(6) 4 4 4
ordinal int(11) 4 4 4
city varchar(30) Y 32 32 12*
customer_id int(11) PRI 4 4 4
postal_code varchar(30) MUL 32 32 32
num_children_at_home smallint(6) MUL 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
mi varchar(30) Y 32 32 4*
gender varchar(30) Y 32 32 4*
houseowner varchar(30) Y 32 32 4*
country varchar(30) Y 32 32 8*
address4 varchar(30) Y 32 32 4*
education varchar(30) Y 32 32 20*
birthdate date 4 4 4
member_card varchar(30) Y 32 32 8*
occupation varchar(30) Y 32 32 12*
address2 varchar(30) Y 32 32 8*
account_num bigint(20) MUL 8 8 8
yearly_income varchar(30) Y 32 32 16*
phone1 varchar(30) Y 32 32 16*
lname varchar(30) MUL 32 32 32
state_province varchar(30) Y 32 32 4*
address1 varchar(30) Y 32 32 20*
phone2 varchar(30) Y 32 32 16*
Fixed Size Columns DM/Row 688 688 144
Varsize Columns DM/Row 0 0 164

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_customer_children_at_home BTREE 16 16 16
i_customer_id BTREE N/A N/A N/A
i_customer_region_id BTREE 16 16 16
i_customer_postal_code BTREE 16 16 16
i_account_num BTREE 16 16 16
PRIMARY BTREE 16 16 16
i_customer_lname BTREE 16 16 16
i_customer_fname BTREE 16 16 16
Total Index DM/Row 112 112 112

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
customer_customer_id$unique 24 24 32
This DataMemory/Row 816 816 276
Total DM/Row (inludes DM in other tables) 840 840 308

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_customer_children_at_home N/A N/A N/A
i_customer_region_id N/A N/A N/A
i_customer_postal_code N/A N/A N/A
i_account_num N/A N/A N/A
PRIMARY 33 16 16
i_customer_lname N/A N/A N/A
i_customer_fname N/A N/A N/A
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

customer_customer_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 816 816 276

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 176

Memory Calculations

No. Rows 10281 10281 10281
Rows/32kb DM Page 40 40 118
Fixedsize DataMemory (KB) 8256 8256 2816
Rows/32kb Varsize DM Page 0 0 185
Varsize DataMemory (KB) 0 0 1792
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 336 168 168


customer_customer_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
customer_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 10281 10281 10281
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 256 256 352
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 296 168 168


days

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
week_day varchar(30) Y 32 32 12*
day int(11) 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 44 44 12
Varsize Columns DM/Row 0 0 12

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 72 72 44

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 20

Memory Calculations

No. Rows 7 7 7
Rows/32kb DM Page 453 453 741
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 1632
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


department

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
HIDDEN_NDB_PKEY bigint PRI 8 8 8
department_id int(11) PRI 4 4 4
department_description varchar(30) Y 32 32 24*
Fixed Size Columns DM/Row 44 44 12
Varsize Columns DM/Row 0 0 24

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_department_id BTREE N/A N/A N/A
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
department_department_id$unique 24 24 32
This DataMemory/Row 72 72 44
Total DM/Row (inludes DM in other tables) 96 96 76

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

department_department_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 72 72 44

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 32

Memory Calculations

No. Rows 12 12 12
Rows/32kb DM Page 453 453 741
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 1020
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


department_department_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
department_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 12 12 12
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 8 8 8


employee

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
store_id int(11) MUL 4 4 4
marital_status varchar(30) Y 32 32 4*
position_id int(11) 4 4 4
last_name varchar(30) Y 32 32 8*
education_level varchar(30) Y 32 32 20*
supervisor_id int(11) MUL 4 4 4
hire_date timestamp 4 4 4
employee_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
department_id int(11) MUL 4 4 4
gender varchar(30) Y 32 32 4*
management_role varchar(255) Y 256 256 20*
full_name varchar(30) Y 32 32 16*
birth_date date 4 4 4
salary decimal(10,2) N/A N/A N/A
position_title varchar(30) Y 32 32 24*
end_date timestamp 4 4 4
first_name varchar(30) Y 32 32 8*
Fixed Size Columns DM/Row 520 520 40
Varsize Columns DM/Row 0 0 104

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_employee_store_id BTREE 16 16 16
PRIMARY BTREE 16 16 16
i_employee_id BTREE N/A N/A N/A
i_employee_department_id BTREE 16 16 16
i_employee_supervisor_id BTREE 16 16 16
Total Index DM/Row 64 64 64

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
employee_employee_id$unique 24 24 32
This DataMemory/Row 600 600 124
Total DM/Row (inludes DM in other tables) 624 624 156

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_employee_store_id N/A N/A N/A
PRIMARY 33 16 16
i_employee_department_id N/A N/A N/A
i_employee_supervisor_id N/A N/A N/A
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

employee_employee_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 600 600 124

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 116

Memory Calculations

No. Rows 1155 1155 1155
Rows/32kb DM Page 54 54 263
Fixedsize DataMemory (KB) 704 704 160
Rows/32kb Varsize DM Page 0 0 281
Varsize DataMemory (KB) 0 0 160
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 40 24 24


employee_employee_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
employee_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 1155 1155 1155
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 32 32 64
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 40 24 24


expense_fact

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
time_id int(11) MUL 4 4 4
store_id int(11) MUL 4 4 4
category_id varchar(30) Y 32 32 8*
currency_id int(11) 4 4 4
amount decimal(10,2) N/A N/A N/A
exp_date date 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
account_id int(11) MUL 4 4 4
Fixed Size Columns DM/Row 60 60 28
Varsize Columns DM/Row 0 0 8

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_expense_time_id BTREE 16 16 16
i_expense_account_id BTREE 16 16 16
i_expense_store_id BTREE 16 16 16
PRIMARY BTREE 16 16 16
Total Index DM/Row 64 64 64

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_expense_time_id N/A N/A N/A
i_expense_account_id N/A N/A N/A
i_expense_store_id N/A N/A N/A
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 136 136 108

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 16

Memory Calculations

No. Rows 2400 2400 2400
Rows/32kb DM Page 240 240 302
Fixedsize DataMemory (KB) 320 320 256
Rows/32kb Varsize DM Page 0 0 2040
Varsize DataMemory (KB) 0 0 64
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 80 40 40


inventory_fact

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
store_id int(11) MUL 4 4 4
units_shipped int(11) 4 4 4
supply_time smallint(6) 4 4 4
store_invoice decimal(10,4) N/A N/A N/A
time_id int(11) MUL 4 4 4
warehouse_cost decimal(10,4) N/A N/A N/A
warehouse_id int(11) MUL 4 4 4
units_ordered int(11) 4 4 4
product_id int(11) MUL 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
warehouse_sales decimal(10,4) N/A N/A N/A
Fixed Size Columns DM/Row 36 36 36
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_inv_1997_warehouse_id BTREE 16 16 16
i_inv_1997_store_id BTREE 16 16 16
i_inv_1997_product_id BTREE 16 16 16
i_inv_1997_time_id BTREE 16 16 16
PRIMARY BTREE 16 16 16
Total Index DM/Row 80 80 80

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_inv_1997_warehouse_id N/A N/A N/A
i_inv_1997_store_id N/A N/A N/A
i_inv_1997_product_id N/A N/A N/A
i_inv_1997_time_id N/A N/A N/A
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 132 132 136

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 11352 11352 11352
Rows/32kb DM Page 247 247 240
Fixedsize DataMemory (KB) 1472 1472 1536
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 368 184 184


position

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
position_title varchar(30) Y 32 32 24*
max_scale decimal(10,2) N/A N/A N/A
pay_type varchar(30) Y 32 32 8*
min_scale decimal(10,2) N/A N/A N/A
position_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
management_role varchar(30) Y 32 32 20*
Fixed Size Columns DM/Row 108 108 12
Varsize Columns DM/Row 0 0 52

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_position_id BTREE N/A N/A N/A
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
position_position_id$unique 24 24 32
This DataMemory/Row 136 136 44
Total DM/Row (inludes DM in other tables) 160 160 76

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

position_position_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 136 136 44

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 60

Memory Calculations

No. Rows 18 18 18
Rows/32kb DM Page 240 240 741
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 544
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


position_position_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
position_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 18 18 18
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 8 8 8


product

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
SRP decimal(10,2) N/A N/A N/A
product_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
low_fat char(1) 4 4 4
shelf_depth double 8 8 8
recyclable_package char(1) 4 4 4
cases_per_pallet smallint(6) 4 4 4
gross_weight double 8 8 8
product_class_id int(11) MUL 4 4 4
brand_name varchar(60) MUL 64 64 64
shelf_width double 8 8 8
units_per_case smallint(6) 4 4 4
shelf_height double 8 8 8
net_weight double 8 8 8
product_name varchar(60) MUL 64 64 64
SKU bigint(20) MUL 8 8 8
Fixed Size Columns DM/Row 208 208 208
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_inv_1998_brand_name BTREE 16 16 16
PRIMARY BTREE 16 16 16
i_product_SKU BTREE 16 16 16
i_product_name BTREE 16 16 16
i_product_class_id BTREE 16 16 16
i_product_id BTREE N/A N/A N/A
Total Index DM/Row 80 80 80

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
product_product_id$unique 24 24 32
This DataMemory/Row 304 304 308
Total DM/Row (inludes DM in other tables) 328 328 340

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_inv_1998_brand_name N/A N/A N/A
PRIMARY 33 16 16
i_product_SKU N/A N/A N/A
i_product_name N/A N/A N/A
i_product_class_id N/A N/A N/A
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

product_product_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 304 304 308

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 1560 1560 1560
Rows/32kb DM Page 107 107 105
Fixedsize DataMemory (KB) 480 480 480
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 56 32 32


product_class

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
product_class_id int(11) 4 4 4
product_department varchar(30) Y 32 32 12*
product_family varchar(30) Y 32 32 12*
product_category varchar(30) Y 32 32 16*
HIDDEN_NDB_PKEY bigint PRI 8 8 8
product_subcategory varchar(30) Y 32 32 12*
Fixed Size Columns DM/Row 140 140 12
Varsize Columns DM/Row 0 0 52

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 0
DataMemory/Row (incl overhead, bitmap, indexes) 172 172 44

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 64

Memory Calculations

No. Rows 110 110 110
Rows/32kb DM Page 189 189 741
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 510
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


product_product_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
product_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 1560 1560 1560
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 64 64 64
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 48 32 32


promotion

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
cost double 8 8 8
promotion_district_id int(11) MUL 4 4 4
end_date date 4 4 4
promotion_name varchar(30) Y 32 32 16*
media_type varchar(30) Y 32 32 16*
start_date date 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
promotion_id int(11) PRI 4 4 4
Fixed Size Columns DM/Row 96 96 32
Varsize Columns DM/Row 0 0 32

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_promotion_id BTREE N/A N/A N/A
i_promotion_district_id BTREE 16 16 16
PRIMARY BTREE 16 16 16
Total Index DM/Row 32 32 32

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
promotion_promotion_id$unique 24 24 32
This DataMemory/Row 144 144 84
Total DM/Row (inludes DM in other tables) 168 168 116

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_promotion_district_id N/A N/A N/A
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

promotion_promotion_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 144 144 84

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 44

Memory Calculations

No. Rows 1864 1864 1864
Rows/32kb DM Page 226 226 388
Fixedsize DataMemory (KB) 288 288 160
Rows/32kb Varsize DM Page 0 0 741
Varsize DataMemory (KB) 0 0 96
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 64 32 32


promotion_promotion_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
HIDDEN_NDB_PKEY bigint PRI 8 8 8
promotion_id int(11) PRI 4 4 4
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 1864 1864 1864
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 64 64 64
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 56 32 32


region

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
sales_district_id int(11) 4 4 4
sales_state_province varchar(30) Y 32 32 4*
sales_region varchar(30) Y 32 32 12*
region_id int(11) 4 4 4
sales_country varchar(30) Y 32 32 8*
sales_district varchar(30) Y 32 32 12*
HIDDEN_NDB_PKEY bigint PRI 8 8 8
sales_city varchar(30) Y 32 32 12*
Fixed Size Columns DM/Row 176 176 16
Varsize Columns DM/Row 0 0 48

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 208 208 52

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 60

Memory Calculations

No. Rows 110 110 110
Rows/32kb DM Page 156 156 627
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 544
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


reserve_employee

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
store_id int(11) MUL 4 4 4
marital_status varchar(30) Y 32 32 4*
position_id int(11) 4 4 4
last_name varchar(30) Y 32 32 8*
education_level varchar(30) Y 32 32 20*
supervisor_id int(11) MUL 4 4 4
hire_date timestamp 4 4 4
employee_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
department_id int(11) MUL 4 4 4
gender varchar(30) Y 32 32 4*
full_name varchar(30) Y 32 32 16*
birth_date date 4 4 4
salary decimal(10,2) N/A N/A N/A
position_title varchar(30) Y 32 32 4*
end_date timestamp 4 4 4
first_name varchar(30) Y 32 32 8*
Fixed Size Columns DM/Row 264 264 40
Varsize Columns DM/Row 0 0 64

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_reserve_employee_id BTREE N/A N/A N/A
i_reserve_employee_super_id BTREE 16 16 16
i_reserve_employee_dept_id BTREE 16 16 16
PRIMARY BTREE 16 16 16
i_reserve_employee_store_id BTREE 16 16 16
Total Index DM/Row 64 64 64

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
reserve_employee_employee_id$unique 24 24 32
This DataMemory/Row 344 344 124
Total DM/Row (inludes DM in other tables) 368 368 156

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_reserve_employee_super_id N/A N/A N/A
i_reserve_employee_dept_id N/A N/A N/A
PRIMARY 33 16 16
i_reserve_employee_store_id N/A N/A N/A
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

reserve_employee_employee_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 344 344 124

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 76

Memory Calculations

No. Rows 143 143 143
Rows/32kb DM Page 94 94 263
Fixedsize DataMemory (KB) 64 64 32
Rows/32kb Varsize DM Page 0 0 429
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


reserve_employee_employee_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
employee_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 143 143 143
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 8 8 8


salary

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
vacation_used int(11) 4 4 4
currency_id int(11) 4 4 4
employee_id int(11) 4 4 4
pay_date date 4 4 4
vacation_accrued int(11) 4 4 4
salary_paid decimal(10,4) N/A N/A N/A
HIDDEN_NDB_PKEY bigint PRI 8 8 8
overtime_paid decimal(10,4) N/A N/A N/A
department_id int(11) 4 4 4
Fixed Size Columns DM/Row 32 32 32
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 60 60 64

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 21252 21252 21252
Rows/32kb DM Page 544 544 510
Fixedsize DataMemory (KB) 1280 1280 1344
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 688 336 336


sales_fact

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
time_id int(11) MUL 4 4 4
store_id int(11) MUL 4 4 4
unit_sales int(11) 4 4 4
customer_id int(11) MUL 4 4 4
product_id int(11) MUL 4 4 4
store_cost decimal(10,4) N/A N/A N/A
HIDDEN_NDB_PKEY bigint PRI 8 8 8
store_sales decimal(10,2) N/A N/A N/A
promotion_id int(11) MUL 4 4 4
Fixed Size Columns DM/Row 32 32 32
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_sales_1997_product_id BTREE 16 16 16
i_sales_1997_time_id BTREE 16 16 16
i_sales_1997_store_id BTREE 16 16 16
i_sales_1997_promotion_id BTREE 16 16 16
PRIMARY BTREE 16 16 16
i_sales_1997_customer_id BTREE 16 16 16
Total Index DM/Row 96 96 96

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_sales_1997_product_id N/A N/A N/A
i_sales_1997_time_id N/A N/A N/A
i_sales_1997_store_id N/A N/A N/A
i_sales_1997_promotion_id N/A N/A N/A
PRIMARY 33 16 16
i_sales_1997_customer_id N/A N/A N/A
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 140 140 144

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 269720 269720 269720
Rows/32kb DM Page 233 233 226
Fixedsize DataMemory (KB) 37056 37056 38208
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8704 4216 4216


store

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
meat_sqft double 8 8 8
store_id int(11) PRI 4 4 4
store_fax varchar(30) Y 32 32 16*
last_remodel_date date 4 4 4
coffee_bar char(1) 4 4 4
store_type varchar(30) Y 32 32 16*
florist char(1) 4 4 4
region_id int(11) MUL 4 4 4
store_name varchar(30) Y 32 32 12*
store_phone varchar(30) Y 32 32 16*
HIDDEN_NDB_PKEY bigint PRI 8 8 8
store_city varchar(30) Y 32 32 12*
store_street_address varchar(30) Y 32 32 20*
store_postal_code varchar(30) Y 32 32 8*
store_sqft double 8 8 8
grocery_sqft double 8 8 8
store_manager varchar(30) Y 32 32 8*
store_state varchar(30) Y 32 32 8*
frozen_sqft double 8 8 8
store_number int(11) 4 4 4
video_store char(1) 4 4 4
salad_bar char(1) 4 4 4
first_opened_date date 4 4 4
prepared_food char(1) 4 4 4
store_country varchar(30) Y 32 32 8*
Fixed Size Columns DM/Row 400 400 80
Varsize Columns DM/Row 0 0 124

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
i_store_region_id BTREE 16 16 16
i_store_id BTREE N/A N/A N/A
PRIMARY BTREE 16 16 16
Total Index DM/Row 32 32 32

Supporting Tables DataMemory/Row

Table 4.1 5.0 5.1
store_store_id$unique 24 24 32
This DataMemory/Row 448 448 132
Total DM/Row (inludes DM in other tables) 472 472 164

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
i_store_region_id N/A N/A N/A
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Supporting Tables IndexMemory/Row

store_store_id$unique 29 16 16
Total Suppt IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 448 448 132

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 136

Memory Calculations

No. Rows 25 25 25
Rows/32kb DM Page 72 72 247
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 240
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


store_store_id$unique

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
store_id int(11) PRI 4 4 4
HIDDEN_NDB_PKEY bigint PRI 8 8 8
Fixed Size Columns DM/Row 12 12 12
Varsize Columns DM/Row 0 0 0

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE N/A N/A N/A
Total Index DM/Row 0 0 0

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 29 16 16
Indexes IM/Row 29 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 20
NULL Bytes/Row 0 0 0
DataMemory/Row (incl overhead, bitmap, indexes) 24 24 32

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 0
Avg Varside DM/Row 0 0 0

Memory Calculations

No. Rows 25 25 25
Rows/32kb DM Page 1360 1360 1020
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 0
Varsize DataMemory (KB) 0 0 0
Rows/8kb IM Page 282 512 512
IndexMemory (KB) 8 8 8


time_by_day

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
the_day varchar(30) Y 32 32 12*
month_of_year smallint(6) 4 4 4
the_month varchar(30) Y 32 32 8*
the_date date 4 4 4
week_of_year int(11) 4 4 4
quarter varchar(30) Y 32 32 4*
the_year smallint(6) 4 4 4
time_id int(11) 4 4 4
fiscal_period varchar(30) Y 32 32 4*
HIDDEN_NDB_PKEY bigint PRI 8 8 8
day_of_month smallint(6) 4 4 4
Fixed Size Columns DM/Row 160 160 32
Varsize Columns DM/Row 0 0 28

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 192 192 68

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 40

Memory Calculations

No. Rows 730 730 730
Rows/32kb DM Page 170 170 480
Fixedsize DataMemory (KB) 160 160 64
Rows/32kb Varsize DM Page 0 0 816
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 24 16 16


warehouse

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
wa_address3 varchar(30) Y 32 32 4*
warehouse_phone varchar(30) Y 32 32 16*
warehouse_id int(11) 4 4 4
warehouse_postal_code varchar(30) Y 32 32 8*
warehouse_owner_name varchar(30) Y 32 32 4*
HIDDEN_NDB_PKEY bigint PRI 8 8 8
warehouse_city varchar(30) Y 32 32 12*
wa_address4 varchar(30) Y 32 32 4*
wa_address1 varchar(30) Y 32 32 20*
warehouse_name varchar(60) Y 64 64 24*
warehouse_state_province varchar(30) Y 32 32 8*
warehouse_class_id int(11) 4 4 4
stores_id int(11) 4 4 4
warehouse_fax varchar(30) Y 32 32 16*
warehouse_country varchar(30) Y 32 32 8*
wa_address2 varchar(30) Y 32 32 4*
Fixed Size Columns DM/Row 436 436 20
Varsize Columns DM/Row 0 0 128

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 4
DataMemory/Row (incl overhead, bitmap, indexes) 468 468 56

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 140

Memory Calculations

No. Rows 24 24 24
Rows/32kb DM Page 69 69 582
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 233
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


warehouse_class

DataMemory for Columns

* means varsized DataMemory

Column Name Type Varsized Key 4.1 5.0 5.1
HIDDEN_NDB_PKEY bigint PRI 8 8 8
description varchar(30) Y 32 32 16*
warehouse_class_id int(11) 4 4 4
Fixed Size Columns DM/Row 44 44 12
Varsize Columns DM/Row 0 0 16

DataMemory for Indexes

Index Name Type 4.1 5.0 5.1
PRIMARY BTREE 16 16 16
Total Index DM/Row 16 16 16

IndexMemory for Indexes

Index Name 4.1 5.0 5.1
PRIMARY 33 16 16
Indexes IM/Row 33 16 16

Summary (for THIS table)

Fixed Sized Part

4.1 5.0 5.1
Fixed Overhead DM/Row 12 12 16
NULL Bytes/Row 4 4 0
DataMemory/Row (incl overhead, bitmap, indexes) 76 76 44

Variable Sized Part

Varsize Overhead DM/Row 0 0 8
Varsize NULL Bytes/Row 0 0 4
Avg Varside DM/Row 0 0 28

Memory Calculations

No. Rows 6 6 6
Rows/32kb DM Page 429 429 741
Fixedsize DataMemory (KB) 32 32 32
Rows/32kb Varsize DM Page 0 0 1165
Varsize DataMemory (KB) 0 0 32
Rows/8kb IM Page 248 512 512
IndexMemory (KB) 8 8 8


Parameter Minimum Requirements

* indicates greater than default

Parameter Default 4.1 5.0 5.1
DataMemory (KB) 81920 51072 51072 48704
NoOfOrderedIndexes 128 64 64 64
NoOfTables 128 32 32 32
IndexMemory (KB) 18432 10952 5456 5456
NoOfUniqueHashIndexes 64 11 11 11
NoOfAttributes 1000 248 248 248
NoOfTriggers 768 225 225 225