Re: SUM function is too slowly
With 16GB RAM, innodb_buffer_pool_size should be about 11G. You've not defined "slow", but an indexed sum across 200K rows ought to complete in a very few secs on a modest machine.
If that doesn't work, please re-post the Show Create Table results in human-readable form (eg run the cmds in the mysql client program using \G as the command delimiter instead of a semicolon, copy & paste the result).
Subject
Written By
Posted
Re: SUM function is too slowly
March 11, 2020 10:08AM
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.