MySQL performance and (Wordpress) database size
Basically I think it should not affect performance for visitors of my site whether the comment table (actually the commentmeta table) is 1 MB or 20 MB
Letting it accumulate does affect time to empty the spam comments, to the point of time-outs ( I let scripts run up to 60s). It does affect the size of the daily and weekly backups (especially when I had them emailed to me).
When does size begins to affect performance? Wordpress uses MyISAM.
2 Replies
how well it is indexed
whether row scans are involved
hot data fits in memory
no text type columns so any temp tables involved (eg. for sorting) do not spill to disc
tps