MySQL Cluster analysis for expman

This is an automated analysis of the DBI:mysql:database=expman;host=db3 database for migration into MySQL Cluster. No warranty is made to the accuracy of the information.

This information should be valid for MySQL 4.1 and 5.0. Since 5.1 is not a final release yet, the numbers should be used as a guide only.

5.1-dd is for tables stored on disk. The ndb_size.pl estimates are experimental and should not be trusted. Notably we don't take into account indexed columns being in DataMemory versus non-indexed on disk.

Parameter Settings

NOTE the configuration parameters below do not take into account system tables and other requirements.

Parameter	4.1	5.0	5.1
DataMemory (kb)	20095360	20095360	4742752
IndexMemory (kb)	17568960	973384	973384
MaxNoOfTables	37	37	37
MaxNoOfAttributes	315	315	315
MaxNoOfOrderedIndexes	109	109	109
MaxNoOfUniqueHashIndexes	109	109	109
MaxNoOfTriggers	436	436	436

Memory usage because of parameters

Usage is in kilobytes. Actual usage will vary as you should set the parameters larger than those listed in the table above.

Parameter	4.1	5.0	5.1
Attributes	62	62	62
Tables	740	740	740
OrderedIndexes	1090	1090	1090
UniqueHashIndexes	1635	1635	1635

Table List

address
adminmail
affiliation
batchjob$BLOB_progress
batchjob$BLOB_jobspec
batchjob
competitive_upgrade$BLOB_url
competitive_upgrade
competitor
contactmethod
country
creditcard
creditcardtransaction$BLOB_comment
creditcardtransaction
currency
gallery$BLOB_emailuploadpassphrase
gallery
gallery_login
gallerysubscription
imagejob$BLOB_errorlog
imagejob
imagejobrunner
login
newsitem
party
payment$BLOB_comment
payment
paymentinterval
paymentmeans
paymenttype
photographer
reseller
sbsubscriber
search_cache$BLOB_contents
search_cache
state
stats_bandwidth
stats_gallery
stats_photo
status
subscription
subscriptionprice
suspensionnote$BLOB_note
suspensionnote
token
type

address

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
country	int		10	MUL	4	4	4
create_ip	varchar	YES	16		20	20	16
status	int		10	MUL	4	4	4
create_date	datetime				8	8	8
party	int		10	MUL	4	4	4
state	int		10	MUL	4	4	4
address2	varchar	YES	255		256	256	4
address_id	int		10	PRI	4	4	4
zip	varchar	YES	50		52	52	8
city	varchar	YES	255		256	256	12
type	int		10	MUL	4	4	4
address1	varchar	YES	255		256	256	20
modify_ip	varchar	YES	16		20	20	16
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_type	BTREE	type	29	25	25	10	10	10
PRIMARY	BTREE	address_id	29	25	25	10	10	10
ix_status	BTREE	status	29	25	25	10	10	10
ix_party	BTREE	party	29	25	25	10	10	10
ix_state	BTREE	state	29	25	25	10	10	10
ix_country	BTREE	country	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	6
Row Overhead	16	16	16
Varsized Overhead	0	0	44
Column DataMemory/Row	900	900	116
Index DataMemory/Row	60	60	60
Total DataMemory/Row	976	976	236
Rows per 32kb page	33	33	138
Current number of rows	9749	9749	9749
Total DataMemory (kb)	9472	9472	2272

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	174	150	150
Rows per 8kb page	47	54	54
Current number of rows	9749	9749	9749
Total IndexMemory (kb)	1664	1448	1448

adminmail

Column	Type	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
sent_date	datetime			8	8	8
adminmail_id	int	10	PRI	4	4	4
type	int	10	MUL	4	4	4
party	int	10	MUL	4	4	4
next_send_date	datetime			8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_type	BTREE	type	29	25	25	10	10	10
PRIMARY	BTREE	adminmail_id	29	25	25	10	10	10
ix_party	BTREE	party	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	28	28	28
Index DataMemory/Row	30	30	30
Total DataMemory/Row	74	74	82
Rows per 32kb page	441	441	398
Current number of rows	9446	9446	9446
Total DataMemory (kb)	704	704	768

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	87	75	75
Rows per 8kb page	94	109	109
Current number of rows	9446	9446	9446
Total IndexMemory (kb)	808	696	696

affiliation

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
payments_made	tinyint		3		4	4	4
create_ip	varchar	YES	16		20	20	16
affiliate_id	int		10	PRI	4	4	4
create_date	datetime				8	8	8
referrer	int		10	MUL	4	4	4
referrer_gallery	int		10	MUL	4	4	4
next_payment_date	datetime				8	8	8
max_payments	tinyint		3		4	4	4
modify_ip	varchar	YES	16		20	20	12
affiliate_gallery	int		10	MUL	4	4	4
modify_date	datetime				8	8	8
payment_amount	decimal(15,4)				0	0	0

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	affiliate_id	29	25	25	10	10	10
ix_rg	BTREE	referrer_gallery	29	25	25	10	10	10
ix_ag	BTREE	affiliate_gallery	29	25	25	10	10	10
ix_ph	BTREE	referrer	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	88	88	76
Index DataMemory/Row	40	40	40
Total DataMemory/Row	144	144	152
Rows per 32kb page	226	226	214
Current number of rows	856	856	856
Total DataMemory (kb)	128	128	128

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	116	100	100
Rows per 8kb page	70	81	81
Current number of rows	856	856	856
Total IndexMemory (kb)	104	88	88

batchjob$BLOB_progress

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	206592	206592	206592
Total DataMemory (kb)	413184	413184	440736

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	206592	206592	206592
Total IndexMemory (kb)	7480	5056	5056

batchjob$BLOB_jobspec

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	262567	262567	262567
Total DataMemory (kb)	525152	525152	560160

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	262567	262567	262567
Total IndexMemory (kb)	9512	6424	6424

batchjob

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
target_gallery	varchar	YES	255		256	256	16
batchjob_id	int		11	PRI	4	4	4
account	varchar	YES	255		256	256	16
progress	text				264	264	264
status	varchar	YES	64	MUL	68	68	12
create_date	datetime				8	8	8
jobspec	mediumtext				264	264	264
starttime	datetime				8	8	8
gallery	varchar	YES	255		256	256	16
operation	varchar	YES	255		256	256	12
development_yn	tinyint		4		4	4	4
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	batchjob_id	29	25	25	10	10	10
ix_status	BTREE	status	93	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	5
Row Overhead	16	16	16
Varsized Overhead	0	0	40
Column DataMemory/Row	1652	1652	632
Index DataMemory/Row	20	20	20
Total DataMemory/Row	1688	1688	708
Rows per 32kb page	19	19	46
Current number of rows	216245	216245	216245
Total DataMemory (kb)	364224	364224	150432

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	122	50	50
Rows per 8kb page	67	163	163
Current number of rows	216245	216245	216245
Total IndexMemory (kb)	25824	10616	10616

competitive_upgrade$BLOB_url

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	318	318	318
Total DataMemory (kb)	640	640	704

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	318	318	318
Total IndexMemory (kb)	16	8	8

competitive_upgrade

Column	Type	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
competitor	int	10	MUL	4	4	4
competitive_upgrade_id	int	10	PRI	4	4	4
url	text			264	264	264
gallery	int	10	MUL	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_competitor	BTREE	competitor	29	25	25	10	10	10
PRIMARY	BTREE	competitive_upgrade_id	29	25	25	10	10	10
ix_gallery	BTREE	gallery	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	276	276	276
Index DataMemory/Row	30	30	30
Total DataMemory/Row	322	322	330
Rows per 32kb page	101	101	98
Current number of rows	327	327	327
Total DataMemory (kb)	128	128	128

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	87	75	75
Rows per 8kb page	94	109	109
Current number of rows	327	327	327
Total IndexMemory (kb)	32	24	24

competitor

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
url	varchar	YES	255		256	256	28
name	varchar	YES	255	UNI	256	256	12
competitor_id	int		10	PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	competitor_id	29	25	25	10	10	10
uk_name	BTREE	name	281	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	516	516	44
Index DataMemory/Row	20	20	20
Total DataMemory/Row	552	552	100
Rows per 32kb page	59	59	326
Current number of rows	8	8	8
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	310	50	50
Rows per 8kb page	26	163	163
Current number of rows	8	8	8
Total IndexMemory (kb)	8	8	8

contactmethod

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
create_ip	varchar	YES	255		256	256	0
contactmethod_id	int		10	PRI	4	4	4
create_date	datetime				8	8	8
name	varchar	YES	255		256	256	0
type	int		10	MUL	4	4	4
modify_ip	varchar	YES	255		256	256	0
party	int		10	MUL	4	4	4
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_type	BTREE	type	29	25	25	10	10	10
PRIMARY	BTREE	contactmethod_id	29	25	25	10	10	10
ix_party	BTREE	party	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	3
Row Overhead	16	16	16
Varsized Overhead	0	0	28
Column DataMemory/Row	796	796	28
Index DataMemory/Row	30	30	30
Total DataMemory/Row	842	842	102
Rows per 32kb page	38	38	320
Current number of rows	0	0	0
Total DataMemory (kb)	0	0	0

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	87	75	75
Rows per 8kb page	94	109	109
Current number of rows	0	0	0
Total IndexMemory (kb)	0	0	0

country

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
iso3	char		3		4	4	4
country_id	int		10	PRI	4	4	4
name	varchar	YES	255		256	256	12
iso2	char		2		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	country_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	1
Row Overhead	16	16	16
Varsized Overhead	0	0	16
Column DataMemory/Row	268	268	24
Index DataMemory/Row	10	10	10
Total DataMemory/Row	294	294	66
Rows per 32kb page	111	111	494
Current number of rows	241	241	241
Total DataMemory (kb)	96	96	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	241	241	241
Total IndexMemory (kb)	8	8	8

creditcard

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
create_ip	varchar	YES	16		20	20	16
status	int		10	MUL	4	4	4
creditcard_id	int		10	PRI	4	4	4
create_date	datetime				8	8	8
cc_cvc	varchar	YES	16		20	20	8
cc_exp	varchar	YES	16		20	20	8
party	int		10	MUL	4	4	4
cc_number	varchar	YES	64		68	68	20
address	int		10	MUL	4	4	4
type	int		10	MUL	4	4	4
cc_name	varchar	YES	255		256	256	16
modify_ip	varchar	YES	255		256	256	12
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_creditcardstatus_id	BTREE	status	29	25	25	10	10	10
ix_creditcardtype_id	BTREE	type	29	25	25	10	10	10
ix_party_id	BTREE	party	29	25	25	10	10	10
PRIMARY	BTREE	creditcard_id	29	25	25	10	10	10
ix_address_id	BTREE	address	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	6
Row Overhead	16	16	16
Varsized Overhead	0	0	44
Column DataMemory/Row	676	676	116
Index DataMemory/Row	50	50	50
Total DataMemory/Row	742	742	226
Rows per 32kb page	43	43	144
Current number of rows	8124	8124	8124
Total DataMemory (kb)	6048	6048	1824

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	145	125	125
Rows per 8kb page	56	65	65
Current number of rows	8124	8124	8124
Total IndexMemory (kb)	1168	1000	1000

creditcardtransaction$BLOB_comment

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	24518	24518	24518
Total DataMemory (kb)	49056	49056	52320

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	24518	24518	24518
Total IndexMemory (kb)	888	600	600

creditcardtransaction

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
create_ip	varchar	YES	16		20	20	12
test_yn	tinyint		4		4	4	4
status	int		10	MUL	4	4	4
create_date	datetime				8	8	8
avs_code	varchar	YES	255		256	256	4
payment_date	datetime				8	8	8
payment_reference	varchar	YES	255		256	256	0
creditcardtransaction_id	int		10	PRI	4	4	4
currency	int		10	MUL	4	4	4
amount	decimal(15,4)				0	0	0
comment	text				264	264	264
transaction_id	varchar	YES	255		256	256	12
creditcard	int		10	MUL	4	4	4
authorisation_code	varchar	YES	255		256	256	8
modify_ip	varchar	YES	16		20	20	0
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_cc	BTREE	creditcard	29	25	25	10	10	10
ix_cur	BTREE	currency	29	25	25	10	10	10
PRIMARY	BTREE	creditcardtransaction_id	29	25	25	10	10	10
ix_status	BTREE	status	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	6
Row Overhead	16	16	16
Varsized Overhead	0	0	44
Column DataMemory/Row	1372	1372	344
Index DataMemory/Row	40	40	40
Total DataMemory/Row	1428	1428	444
Rows per 32kb page	22	22	73
Current number of rows	24518	24518	24518
Total DataMemory (kb)	35680	35680	10752

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	116	100	100
Rows per 8kb page	70	81	81
Current number of rows	24518	24518	24518
Total IndexMemory (kb)	2808	2424	2424

currency

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
symbol	varchar	YES	255		256	256	4
currency_id	int		10	PRI	4	4	4
iso3	varchar	YES	255		256	256	4
name	varchar	YES	255		256	256	16

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	currency_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	3
Row Overhead	16	16	16
Varsized Overhead	0	0	28
Column DataMemory/Row	772	772	28
Index DataMemory/Row	10	10	10
Total DataMemory/Row	798	798	82
Rows per 32kb page	40	40	398
Current number of rows	5	5	5
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	5	5	5
Total IndexMemory (kb)	8	8	8

gallery$BLOB_emailuploadpassphrase

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	0	0	0
Total DataMemory (kb)	0	0	0

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	0	0	0
Total IndexMemory (kb)	0	0	0

gallery

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
upload_layout	int		11		4	4	4
date_format	varchar	YES	255		256	256	0
quota	int		11		4	4	4
create_ip	varchar	YES	16		20	20	16
status	int		10	MUL	4	4	4
deletion_date	datetime				8	8	8
mapped_domain	varchar	YES	255		256	256	0
ftpsetup_yn	tinyint		4		4	4	4
photographer	int		10	MUL	4	4	4
didsave	datetime				8	8	8
reseller	int		10		4	4	4
autorenew_yn	tinyint		4		4	4	4
create_date	datetime				8	8	8
gallery_id	int		10	PRI	4	4	4
emailuploadpassphrase	text				264	264	264
uploader	int		11		4	4	4
end_date	datetime				8	8	8
time_zone	varchar	YES	64		68	68	0
type	int		10	MUL	4	4	4
modify_ip	varchar	YES	16		20	20	12
modify_date	datetime				8	8	8
galleryname	varchar	YES	255	UNI	256	256	20

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_type	BTREE	type	29	25	25	10	10	10
uk_gallery	BTREE	galleryname	281	25	25	10	10	10
PRIMARY	BTREE	gallery_id	29	25	25	10	10	10
ix_gallery	BTREE	galleryname	281	25	25	10	10	10
ix_status	BTREE	status	29	25	25	10	10	10
ix_photographer	BTREE	photographer	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	6
Row Overhead	16	16	16
Varsized Overhead	0	0	44
Column DataMemory/Row	1220	1220	392
Index DataMemory/Row	60	60	60
Total DataMemory/Row	1296	1296	512
Rows per 32kb page	25	25	63
Current number of rows	9593	9593	9593
Total DataMemory (kb)	12288	12288	4896

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	678	150	150
Rows per 8kb page	12	54	54
Current number of rows	9593	9593	9593
Total IndexMemory (kb)	6400	1424	1424

gallery_login

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
gallery	int		11	PRI	4	4	4
login	int		11	PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	login,gallery	33	25	25	10	10	10
ix_gallery	BTREE	gallery	29	25	25	10	10	10
ix_login	BTREE	login	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	8	8	8
Index DataMemory/Row	30	30	30
Total DataMemory/Row	54	54	62
Rows per 32kb page	604	604	526
Current number of rows	1084	1084	1084
Total DataMemory (kb)	64	64	96

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	91	75	75
Rows per 8kb page	90	109	109
Current number of rows	1084	1084	1084
Total IndexMemory (kb)	104	80	80

gallerysubscription

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
cancel_date	datetime				8	8	8
create_ip	varchar	YES	16		20	20	16
status	int		10	MUL	4	4	4
create_date	datetime				8	8	8
trial_yn	tinyint		3		4	4	4
next_payment_date	datetime				8	8	8
gallery	int		10	MUL	4	4	4
creditcard	int		10	MUL	4	4	4
price	decimal(15,4)				0	0	0
modify_ip	varchar	YES	16		20	20	12
initial_discount	decimal(15,4)				0	0	0
gallerysubscription_id	int		10	PRI	4	4	4
subscription	int		10	MUL	4	4	4
paymentinterval	int		10	MUL	4	4	4
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_cc	BTREE	creditcard	29	25	25	10	10	10
ix_int	BTREE	paymentinterval	29	25	25	10	10	10
PRIMARY	BTREE	gallerysubscription_id	29	25	25	10	10	10
ix_gallery	BTREE	gallery	29	25	25	10	10	10
ix_status	BTREE	status	29	25	25	10	10	10
ix_subs	BTREE	subscription	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	100	100	88
Index DataMemory/Row	60	60	60
Total DataMemory/Row	176	176	184
Rows per 32kb page	185	185	177
Current number of rows	9600	9600	9600
Total DataMemory (kb)	1664	1664	1760

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	174	150	150
Rows per 8kb page	47	54	54
Current number of rows	9600	9600	9600
Total IndexMemory (kb)	1640	1424	1424

imagejob$BLOB_errorlog

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	0	0	0
Total DataMemory (kb)	0	0	0

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	0	0	0
Total IndexMemory (kb)	0	0	0

imagejob

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
status	varchar	YES	64	MUL	68	68	12
position	tinyint		4		4	4	4
total_items	int		11		4	4	4
errorlog	text				264	264	264
job_directory	varchar	YES	100		104	104	24
process_subgalleries_yn	tinyint		4		4	4	4
starttime	datetime				8	8	8
development_yn	tinyint		4		4	4	4
print_ready	tinyint		4		4	4	4
operation	varchar	YES	255		256	256	8
progress	float				4	4	4
account	varchar	YES	255		256	256	16
create_date	datetime				8	8	8
slow_yn	tinyint		3		4	4	4
email_account_yn	tinyint		4		4	4	4
eta	datetime				8	8	8
rotate	tinyint		4		4	4	4
done_items	int		11		4	4	4
gallery	varchar	YES	255		256	256	16
queue	tinyint		3		4	4	4
imagejob_id	int		11	PRI	4	4	4
orig_queue	tinyint		3		4	4	4
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	imagejob_id	29	25	25	10	10	10
ix_status	BTREE	status	93	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	5
Row Overhead	16	16	16
Varsized Overhead	0	0	40
Column DataMemory/Row	1288	1288	424
Index DataMemory/Row	20	20	20
Total DataMemory/Row	1324	1324	500
Rows per 32kb page	24	24	65
Current number of rows	636682	636682	636682
Total DataMemory (kb)	848928	848928	313472

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	122	50	50
Rows per 8kb page	67	163	163
Current number of rows	636682	636682	636682
Total IndexMemory (kb)	76024	31256	31256

imagejobrunner

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
status	varchar	YES	24		28	28	8
operation	varchar	YES	24		28	28	12
id	int		10	PRI	4	4	4
queues	tinyint		3		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	64	64	28
Index DataMemory/Row	10	10	10
Total DataMemory/Row	90	90	74
Rows per 32kb page	362	362	441
Current number of rows	2	2	2
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	2	2	2
Total IndexMemory (kb)	8	8	8

login

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
password	varchar	YES	255		256	256	12
create_ip	varchar	YES	16		20	20	12
status	int		10	MUL	4	4	4
create_date	datetime				8	8	8
login_id	int		10	PRI	4	4	4
modify_ip	varchar	YES	16		20	20	12
modify_date	datetime				8	8	8
login	varchar	YES	255	UNI	256	256	12

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
uk_login	BTREE	login	281	25	25	10	10	10
PRIMARY	BTREE	login_id	29	25	25	10	10	10
ix_status	BTREE	status	29	25	25	10	10	10
ix_login	BTREE	login	281	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	4
Row Overhead	16	16	16
Varsized Overhead	0	0	32
Column DataMemory/Row	576	576	72
Index DataMemory/Row	40	40	40
Total DataMemory/Row	632	632	160
Rows per 32kb page	51	51	204
Current number of rows	1084	1084	1084
Total DataMemory (kb)	704	704	192

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	620	100	100
Rows per 8kb page	13	81	81
Current number of rows	1084	1084	1084
Total IndexMemory (kb)	672	112	112

newsitem

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
link	varchar	YES	255		256	256	64
pubdate	datetime				8	8	8
title	varchar	YES	255		256	256	36
newsitem_id	int		10	PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	newsitem_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	524	524	112
Index DataMemory/Row	10	10	10
Total DataMemory/Row	550	550	158
Rows per 32kb page	59	59	206
Current number of rows	67	67	67
Total DataMemory (kb)	64	64	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	67	67	67
Total IndexMemory (kb)	8	8	8

party

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
firstname	varchar	YES	255		256	256	8
salutation	varchar	YES	255		256	256	4
create_ip	varchar	YES	16		20	20	16
status	int		10	MUL	4	4	4
lastname	varchar	YES	255		256	256	8
tax_identifier	varchar	YES	255		256	256	12
email	varchar	YES	255	UNI	256	256	24
middlename	varchar	YES	255		256	256	0
create_date	datetime				8	8	8
company_yn	tinyint		4		4	4	4
party_id	int		10	PRI	4	4	4
balance	decimal(15,4)				0	0	0
jobtitle	varchar	YES	255		256	256	0
type	int		10	MUL	4	4	4
companyname	varchar	YES	255		256	256	24
modify_ip	varchar	YES	16		20	20	12
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_type	BTREE	type	29	25	25	10	10	10
PRIMARY	BTREE	party_id	29	25	25	10	10	10
ix_status	BTREE	status	29	25	25	10	10	10
ix_email	BTREE	email	281	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	10
Row Overhead	16	16	16
Varsized Overhead	0	0	68
Column DataMemory/Row	2120	2120	140
Index DataMemory/Row	40	40	40
Total DataMemory/Row	2176	2176	264
Rows per 32kb page	15	15	123
Current number of rows	9108	9108	9108
Total DataMemory (kb)	19456	19456	2400

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	368	100	100
Rows per 8kb page	22	81	81
Current number of rows	9108	9108	9108
Total IndexMemory (kb)	3312	904	904

payment$BLOB_comment

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	1	1	1
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	1	1	1
Total IndexMemory (kb)	8	8	8

payment

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
fee_detail	varchar	YES	255		256	256	28
paymentmeans	int		10	MUL	4	4	4
create_ip	varchar	YES	16		20	20	12
payment_reference	varchar	YES	255		256	256	8
currency	int		10	MUL	4	4	4
orderitem	int		10	MUL	4	4	4
payment_id	int		10	PRI	4	4	4
gallerysubscription	int		10	MUL	4	4	4
payer	int		10	MUL	4	4	4
recipient	int		10	MUL	4	4	4
test_yn	tinyint		4		4	4	4
create_date	datetime				8	8	8
payment_date	datetime				8	8	8
amount	decimal(15,4)				0	0	0
comment	text				264	264	264
the_order	int		10	MUL	4	4	4
paymenttype	int		10	MUL	4	4	4
creditcardtransaction	int		10	MUL	4	4	4
modify_ip	varchar	YES	16		20	20	0
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_party_paymentplan_id	BTREE	gallerysubscription	29	25	25	10	10	10
ix_paymenttype_id	BTREE	paymenttype	29	25	25	10	10	10
ix_creditcard_id	BTREE	creditcardtransaction	29	25	25	10	10	10
ix_vendor_id	BTREE	payer	29	25	25	10	10	10
ix_orderitem_id	BTREE	orderitem	29	25	25	10	10	10
ix_order_id	BTREE	the_order	29	25	25	10	10	10
ix_paymentmeans_id	BTREE	paymentmeans	29	25	25	10	10	10
ix_currency_id	BTREE	currency	29	25	25	10	10	10
PRIMARY	BTREE	payment_id	29	25	25	10	10	10
ix_reseller_id	BTREE	recipient	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	4
Row Overhead	16	16	16
Varsized Overhead	0	0	32
Column DataMemory/Row	884	884	380
Index DataMemory/Row	100	100	100
Total DataMemory/Row	1000	1000	528
Rows per 32kb page	32	32	61
Current number of rows	69297	69297	69297
Total DataMemory (kb)	69312	69312	36384

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	290	250	250
Rows per 8kb page	28	32	32
Current number of rows	69297	69297	69297
Total IndexMemory (kb)	19800	17328	17328

paymentinterval

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
name	varchar	YES	255		256	256	8
interval_id	int		10	PRI	4	4	4
paymentinterval	varchar	YES	255		256	256	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	interval_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	516	516	16
Index DataMemory/Row	10	10	10
Total DataMemory/Row	542	542	62
Rows per 32kb page	60	60	526
Current number of rows	2	2	2
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	2	2	2
Total IndexMemory (kb)	8	8	8

paymentmeans

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
create_ip	varchar	YES	255		256	256	0
create_date	datetime				8	8	8
name	varchar	YES	255		256	256	0
party	int		10	MUL	4	4	4
value2	varchar	YES	255		256	256	0
value1	varchar	YES	255		256	256	0
paymentmeans_id	int		10	PRI	4	4	4
type	int		10	MUL	4	4	4
address	int		10	MUL	4	4	4
value3	varchar	YES	255		256	256	0
modify_ip	varchar	YES	255		256	256	0
modify_date	datetime				8	8	8

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_paymentmeanstype_id	BTREE	type	29	25	25	10	10	10
ix_address	BTREE	address	29	25	25	10	10	10
ix_party_id	BTREE	party	29	25	25	10	10	10
PRIMARY	BTREE	paymentmeans_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	6
Row Overhead	16	16	16
Varsized Overhead	0	0	44
Column DataMemory/Row	1568	1568	32
Index DataMemory/Row	40	40	40
Total DataMemory/Row	1624	1624	132
Rows per 32kb page	20	20	247
Current number of rows	0	0	0
Total DataMemory (kb)	0	0	0

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	116	100	100
Rows per 8kb page	70	81	81
Current number of rows	0	0	0
Total IndexMemory (kb)	0	0	0

paymenttype

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
side	varchar	YES	255		256	256	0
paymenttype_id	int		10	PRI	4	4	4
type	varchar	YES	255		256	256	0

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	paymenttype_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	516	516	4
Index DataMemory/Row	10	10	10
Total DataMemory/Row	542	542	50
Rows per 32kb page	60	60	652
Current number of rows	0	0	0
Total DataMemory (kb)	0	0	0

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	0	0	0
Total IndexMemory (kb)	0	0	0

photographer

Column	Type	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
currency	int	10		4	4	4
may_dropship_yn	tinyint	4		4	4	4
party	int	10	MUL	4	4	4
photographer_id	int	10	PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ixparty	BTREE	party	29	25	25	10	10	10
PRIMARY	BTREE	photographer_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	16	16	16
Index DataMemory/Row	20	20	20
Total DataMemory/Row	52	52	60
Rows per 32kb page	627	627	544
Current number of rows	9102	9102	9102
Total DataMemory (kb)	480	480	544

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	58	50	50
Rows per 8kb page	141	163	163
Current number of rows	9102	9102	9102
Total IndexMemory (kb)	520	448	448

reseller

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
parent_reseller	int		11	MUL	4	4	4
domainname	varchar	YES	255		256	256	20
party	int		11	MUL	4	4	4
reseller_id	int		10	PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ixparty	BTREE	party	29	25	25	10	10	10
PRIMARY	BTREE	reseller_id	29	25	25	10	10	10
ixparentreseller	BTREE	parent_reseller	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	1
Row Overhead	16	16	16
Varsized Overhead	0	0	16
Column DataMemory/Row	268	268	32
Index DataMemory/Row	30	30	30
Total DataMemory/Row	314	314	94
Rows per 32kb page	103	103	347
Current number of rows	4	4	4
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	87	75	75
Rows per 8kb page	94	109	109
Current number of rows	4	4	4
Total IndexMemory (kb)	8	8	8

sbsubscriber

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
middle	varchar	YES	255		256	256	4
firstname	varchar	YES	255		256	256	8
zip	varchar	YES	10		12	12	8
lastname	varchar	YES	255		256	256	8
id	int		10	PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	4
Row Overhead	16	16	16
Varsized Overhead	0	0	32
Column DataMemory/Row	784	784	32
Index DataMemory/Row	10	10	10
Total DataMemory/Row	810	810	90
Rows per 32kb page	40	40	362
Current number of rows	74851	74851	74851
Total DataMemory (kb)	59904	59904	6624

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	74851	74851	74851
Total IndexMemory (kb)	2128	1832	1832

search_cache$BLOB_contents

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	5762	5762	5762
Total DataMemory (kb)	11552	11552	12320

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	5762	5762	5762
Total IndexMemory (kb)	216	144	144

search_cache

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
create_date	datetime				8	8	8
contents	mediumtext				264	264	264
id	varchar	YES	32	PRI	36	36	36

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	id	61	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	1
Row Overhead	16	16	16
Varsized Overhead	0	0	16
Column DataMemory/Row	308	308	308
Index DataMemory/Row	10	10	10
Total DataMemory/Row	334	334	350
Rows per 32kb page	97	97	93
Current number of rows	737	737	737
Total DataMemory (kb)	256	256	256

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	61	25	25
Rows per 8kb page	134	327	327
Current number of rows	737	737	737
Total IndexMemory (kb)	48	24	24

state

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
country	int		10	MUL	4	4	4
state_id	int		10	PRI	4	4	4
name	varchar	YES	255		256	256	12
abbreviation	varchar	YES	255		256	256	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_country	BTREE	country	29	25	25	10	10	10
PRIMARY	BTREE	state_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	520	520	24
Index DataMemory/Row	20	20	20
Total DataMemory/Row	556	556	80
Rows per 32kb page	58	58	408
Current number of rows	85	85	85
Total DataMemory (kb)	64	64	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	58	50	50
Rows per 8kb page	141	163	163
Current number of rows	85	85	85
Total IndexMemory (kb)	8	8	8

stats_bandwidth

Column	Type	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
period	date		PRI	4	4	4
mb	double			8	8	8
gallery	int	10	PRI	4	4	4
span	enum('day','month','year','total')		PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	gallery,span,period	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	20	20	20
Index DataMemory/Row	10	10	10
Total DataMemory/Row	46	46	54
Rows per 32kb page	709	709	604
Current number of rows	276813	276813	276813
Total DataMemory (kb)	12512	12512	14688

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	276813	276813	276813
Total IndexMemory (kb)	10024	6776	6776

stats_gallery

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
visits	int		10		4	4	4
hits	int		10		4	4	4
period	date			PRI	4	4	4
gallery	int		10	PRI	4	4	4
span	enum('day','month','year','total')			PRI	4	4	4
dir	varchar	YES	255	PRI	256	256	20

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	gallery,dir,span,period	293	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	1
Row Overhead	16	16	16
Varsized Overhead	0	0	16
Column DataMemory/Row	276	276	40
Index DataMemory/Row	10	10	10
Total DataMemory/Row	302	302	82
Rows per 32kb page	108	108	398
Current number of rows	7823182	7823182	7823182
Total DataMemory (kb)	2317984	2317984	629024

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	293	25	25
Rows per 8kb page	27	327	327
Current number of rows	7823182	7823182	7823182
Total IndexMemory (kb)	2317984	191400	191400

stats_photo

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
hits	int		10		4	4	4
photo_id	varchar	YES	255	PRI	256	256	16
gallery	int		10	PRI	4	4	4
dir	varchar	YES	255	PRI	256	256	20

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	gallery,dir,photo_id	541	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	520	520	44
Index DataMemory/Row	10	10	10
Total DataMemory/Row	546	546	90
Rows per 32kb page	59	59	362
Current number of rows	28274385	28274385	28274385
Total DataMemory (kb)	15335264	15335264	2499424

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	541	25	25
Rows per 8kb page	15	327	327
Current number of rows	28274385	28274385	28274385
Total IndexMemory (kb)	15079672	691736	691736

status

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
name	varchar	YES	255		256	256	12
status_id	int		10	PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	status_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	1
Row Overhead	16	16	16
Varsized Overhead	0	0	16
Column DataMemory/Row	260	260	16
Index DataMemory/Row	10	10	10
Total DataMemory/Row	286	286	58
Rows per 32kb page	114	114	562
Current number of rows	13	13	13
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	13	13	13
Total IndexMemory (kb)	8	8	8

subscription

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
paymentplan	int		10	MUL	4	4	4
name	varchar	YES	255	UNI	256	256	8
subscription_id	int		10	PRI	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
paymentplan	BTREE	paymentplan	29	25	25	10	10	10
name	BTREE	name	281	25	25	10	10	10
PRIMARY	BTREE	subscription_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	1
Row Overhead	16	16	16
Varsized Overhead	0	0	16
Column DataMemory/Row	264	264	16
Index DataMemory/Row	30	30	30
Total DataMemory/Row	310	310	78
Rows per 32kb page	105	105	418
Current number of rows	5	5	5
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	339	75	75
Rows per 8kb page	24	109	109
Current number of rows	5	5	5
Total IndexMemory (kb)	8	8	8

subscriptionprice

Column	Type	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
price	decimal(15,4)			0	0	0
price_id	int	10	PRI	4	4	4
paymentinterval	int	10	MUL	4	4	4
subscription	int	10	MUL	4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
ix_int	BTREE	paymentinterval	29	25	25	10	10	10
ix_subs	BTREE	subscription	29	25	25	10	10	10
PRIMARY	BTREE	price_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	12	12	12
Index DataMemory/Row	30	30	30
Total DataMemory/Row	58	58	66
Rows per 32kb page	562	562	494
Current number of rows	10	10	10
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	87	75	75
Rows per 8kb page	94	109	109
Current number of rows	10	10	10
Total IndexMemory (kb)	8	8	8

suspensionnote$BLOB_note

Column	Type	Size	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
PK	int		4	4	4
PART	int		4	4	4
DATA	binary	2000	2000	2000	2000
DIST	int		4	4	4

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	HASH	PK,DIST,PART	37	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	2012	2012	2012
Index DataMemory/Row	10	10	10
Total DataMemory/Row	2038	2038	2046
Rows per 32kb page	16	16	15
Current number of rows	0	0	0
Total DataMemory (kb)	0	0	0

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	37	25	25
Rows per 8kb page	221	327	327
Current number of rows	0	0	0
Total IndexMemory (kb)	0	0	0

suspensionnote

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
id	int		10	PRI	4	4	4
note	text				264	264	264

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	0
Row Overhead	16	16	16
Varsized Overhead	0	0	8
Column DataMemory/Row	268	268	268
Index DataMemory/Row	10	10	10
Total DataMemory/Row	294	294	302
Rows per 32kb page	111	111	108
Current number of rows	0	0	0
Total DataMemory (kb)	0	0	0

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	0	0	0
Total IndexMemory (kb)	0	0	0

token

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
account	varchar	YES	255	MUL	256	256	20
create_date	datetime				8	8	8
id	int		10	PRI	4	4	4
token	varchar	YES	16		20	20	12

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
account	BTREE	account,create_date	289	25	25	10	10	10
PRIMARY	BTREE	id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	2
Row Overhead	16	16	16
Varsized Overhead	0	0	20
Column DataMemory/Row	288	288	44
Index DataMemory/Row	20	20	20
Total DataMemory/Row	324	324	100
Rows per 32kb page	100	100	326
Current number of rows	2	2	2
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	318	50	50
Rows per 8kb page	25	163	163
Current number of rows	2	2	2
Total IndexMemory (kb)	8	8	8

type

Column	Type	VARSIZE	Size	Key	4.1 NDB Size	5.0 NDB Size	5.1 NDB Size
type_id	int		10	PRI	4	4	4
name	varchar	YES	255		256	256	12

Indexes

We assume that indexes are ORDERED (not created USING HASH). If order is not required, 10 bytes of data memory can be saved per row if the index is created USING HASH

Index	Type	Columns	4.1 IdxMem	5.0 IdxMem	5.1 IdxMem	4.1 DatMem	5.0 DatMem	5.1 DatMem
PRIMARY	BTREE	type_id	29	25	25	10	10	10

DataMemory Usage

	4.1	5.0	5.1
Nr Varsized Attributes	0	0	1
Row Overhead	16	16	16
Varsized Overhead	0	0	16
Column DataMemory/Row	260	260	16
Index DataMemory/Row	10	10	10
Total DataMemory/Row	286	286	58
Rows per 32kb page	114	114	562
Current number of rows	37	37	37
Total DataMemory (kb)	32	32	32

IndexMemory Usage

	4.1	5.0	5.1
IndexMemory/Row	29	25	25
Rows per 8kb page	282	327	327
Current number of rows	37	37	37
Total IndexMemory (kb)	8	8	8

This is the output of ndb_size.pl.