Re: Can I store the .frm and .ibd files at a different location

[kanishka keshav]

Hi Rick,

sorry for the late response from my side.
I am using Linux centOS.

device details:
my device has got two 8 core processors(two hyperthraeds each core), 32GB of RAM, 56GB of nvRAM and then pci based SSDs(4TB).

in my earlier practices I used to keep the entire data togather on the SSDs but I have to test the performance improvement if I create a small filesystem (few GB) on the nvRAM which can be used store the relational details in the nvRAM and avoid the case where it needs to be loaded.

Assumption: the performance should increase (in terms of TPMC) if I store the relational data and index on a faster memory.

Please let me know if I should elaborate the complete scenario.

Thanks
kanishka



Edited 1 time(s). Last edit at 10/14/2013 02:23AM by kanishka keshav.