MySQL Forums
Forum List  »  Performance

Re: 30M rows - is dynamic sorting and selecting even possible?
Posted by: Rick James
Date: April 16, 2009 09:43PM

Strange; never heard innodb_buffer_pool_size of being undefined. Try
SHOW VARIABLES LIKE 'innodb%';

"(11 vs. 3 seconds)" -- did you run it twice? The first time may have had to reach for disk.

2-key leftoff is messy, but possible:
WHERE level >= $level_leftoff
   AND ( (level = $level_leftoff AND uploaded > $uploaded_leftoff)
      OR (level > $level_leftoff) )

Options: ReplyQuote




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.