Hello,
i tried to change mysql (5.5) tmpdir to tmpfs and i want to try opening my website, log query (i already setup ymsql slow log) and see how much time it needed. Then i remove mysql tmpdir at tmpfs and want to open my website again and in slow log find its query and compare with older query.
Please how can i do it?
my aim is to see if using tmpfs really helps if the query is too big for being cached in memory and mysql have to create tmp tables
thank you