I recently helped someone who could not figure out why their server was locking up and freezing on them. They had a power server that would make any tech geek sing with joy
12 Core CPU @ 3Ghz
64 GB or Ram
2 TB on SSD Hard Drives
So what was the problem? Well how about 250,000 ( 1/4 of a Million) database queries?
There is an old add on which adds 1 database query per tag word. So if you have 5 tags, you have 5 queries. Or if you have 250,000+ tags you have 250,000+ queries.
With all the people browsing their site... Well into the thousands... This became an issue. The grand total of queries running with everyone online is unknown (kept locking up).
For those of you who may have the following add-on installed
It maybe a good idea, as a suggestion, to un-install it.
Upon removal you should also be able to drop the following tables from your database
I would suggest this (the following) as the alternative to replace it with the following