MySQL Forums
Forum List  »  Performance

Re: MySQL Performance Tuning on my server
Posted by: Rick James
Date: November 16, 2008 11:00PM

es1 -- InnoDB is much slower at doing COUNT(*). MyISAM does COUNT(*) instantly.

es2 -- you have an index on (id) ?

es3 -- you have an index on (vote, avg_voti)?

Options: ReplyQuote


Subject
Views
Written By
Posted
4950
November 14, 2008 10:01AM
2287
November 14, 2008 09:10PM
2298
November 16, 2008 01:04PM
Re: MySQL Performance Tuning on my server
2426
November 16, 2008 11:00PM
1900
November 17, 2008 04:10AM


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.