Re: table partitioning AWS MySQL - InnoDB

[Ra Nala]

Hi Grøvlen ,

My DB - MySQL - InnoDB version is 5.7.11, please check the results when i ran it. at this point of time count(*) is taken less time but generally it will take 10 mins.

i should use nearly 40 columns in my reports, report generation is taking long time with 20 columns of

size for my table is (fact_02 = 4025.69 )Size in MB


SELECT n_rows FROM mysql.innodb_table_stats WHERE table_name='fact_02'
go
select count(*) from fact_02

n_rows
---------
828825

1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]

[Executed: 9/11/17 1:51:01 PM GMT ] [Execution: 234/ms]

count(*)
-----------
1050000

1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]

[Executed: 9/11/17 1:51:02 PM GMT ] [Execution: 67576/ms]


Thanks,
Ra na la