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)?
Subject
Views
Written By
Posted
4971
November 14, 2008 10:01AM
2291
November 14, 2008 09:10PM
2307
November 16, 2008 01:04PM
Re: MySQL Performance Tuning on my server
2433
November 16, 2008 11:00PM
1902
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.