Re: Need help in understanding the diffrence in responce times by mysql for two diffent use cases.

[Aftab Khan]

Scenario 'B'

>But if I create 25k more records in table1 and start inserting the data in table2 and table3 for these new 25k records in table1 the responce times are much lower than above -

You load 50% less data (i.e. 25k x 1k) into table2 and table3 that's why response times are different from Scenario 'A' where you load 50k x 1k rows in table2 and table3.


you should select right data type to help reduce storage required by data/index:

-- Table 1
>`field1` bigint(20) NOT NULL

INT UNSIGNED might be suitable here as it requires 4 bytes and it's range is 0- 4 billion

Similarly, you have many BIGINT columns.

`field10` bigint(20) DEFAULT NULL,
`field11` bigint(20) DEFAULT NULL,
`field12` bigint(20) DEFAULT NULL,
`field13` bigint(20) DEFAULT NULL


>/*!50100 PARTITION BY HASH (field1)

So you perform SELECTs against table1-3 using PK (field1)?