Re: avoid filesort
Thanks again for your time.
I got 36GB dedicated for MYSQL and 2GB for key_buffer_size. Is that too much?
Correct this is a forum.
It never came to my mind of that "solution" to the problem but it will be a perfect way to go.
I will create a new INT(11) with UNIX_TIMESTAMP in f_thread. On post/thread create i will just UPDATE that value.
Big thanks! Will implement it right away.
Subject
Views
Written By
Posted
1893
January 22, 2012 01:08PM
1209
January 24, 2012 01:17AM
1316
January 24, 2012 04:36PM
1455
January 25, 2012 07:24PM
1220
January 26, 2012 04:57AM
1212
January 25, 2012 08:26PM
Re: avoid filesort
1195
January 26, 2012 04:56AM
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.