MySQL Forums
Forum List  »  Optimizer & Parser

Re: avoid filesort
Posted by: Magnus Larsson
Date: January 26, 2012 04:56AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
1620
January 22, 2012 01:08PM
1000
January 24, 2012 01:17AM
1092
January 24, 2012 04:36PM
1186
January 25, 2012 07:24PM
1026
January 26, 2012 04:57AM
1025
January 25, 2012 08:26PM
Re: avoid filesort
997
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.