I run www.omlazeni.cz
The database size is 300MB, we have 650 000 posts, 12 500 topics and 17 000 registered users.
We have just moved to VPS and I think of dedicated server so the computing power is not or will not be problem, also we have plenty of disk space available.
Still, I realized it is high time we thought about some database performace optimizing.
I dont understand databases, but I have read something so these are my thoughts:
- Index over post_text might improve search
- Multiple indexes confuse me. I dont know why they are there. Let me quote phpMyAdmin:
"The following indexes appear to be equal and one of them should be removed: topic_last_post_id, topic_last_post_id_2"
I seek help in two forms:
1. Free tips of how layman might make some quick fixes. (Like "Yes, remove the multiple indexes, nothing bad can happen and it will improve performance a bit.")
2. Mayby paid help from team (Paul?)
, if there is some real room for database performance improvement.
I forgot to mention that the performance for normal users is quite OK, but for admin and mods it is sometimes painstakingly slow - when we move or delete topics or posts...