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
1819
January 22, 2012 01:08PM
1165
January 24, 2012 01:17AM
1275
January 24, 2012 04:36PM
1394
January 25, 2012 07:24PM
1169
January 26, 2012 04:57AM
1175
January 25, 2012 08:26PM
Re: avoid filesort
1162
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.