MySQL Forums
Forum List  »  Data Warehouse

Re: big data question
Posted by: Rick James
Date: March 31, 2013 01:25AM

> AVG_ROW_LENGTH=7
The rows are far more than 7 bytes!
> TYPE=MyISAM MAX_ROWS=4294967295 AVG_ROW_LENGTH=7
So, the table may fill up too soon!

DESCRIBE TABLE does not provide all the information that SHOW CREATE TABLE does.

> In fact we use this to left-join two tables and report incomming call data to the user.
May we see them, plus the EXPLAIN.

> A select query which contains a join and group-by by date would be take a lot of time and the user is not happy.
Summary tables.

> Would it be a help by partitioning both tables base on time
Unlikely.

> contains normalized joint data product of both tables
I think you are misusing the term "normalized".

> date1 integer not null,
> time1 integer not null,
Probably better to use a single DATETIME field.

> protocol integer,
How many different protocols do you have? INTEGER can hold numbers up to 2 billion. TINYINT UNSIGNED holes 0..255 and takes only 1 byte (instead of 4).
Similarly, consider shrinking other fields.

Options: ReplyQuote


Subject
Views
Written By
Posted
2983
March 27, 2013 01:26AM
1533
March 28, 2013 07:52PM
1619
March 30, 2013 06:11AM
Re: big data question
1455
March 31, 2013 01:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.