I want to throw out the line as to what folks are doing with Security and Optimization on MySQL and TKL sites in general. I have had a few sites get really hammered by spiders and bots and I'm not really sure the path on how to button the system up.
Some of the details I have found to be setting "log file expirations".. If you take a year of Logs and keep them in your SQL setup it can be very very large.
At the same time, there are also "repetitive" inputs. I have seen 1100 searches on the same arcane term in one of our systems. How to block things like this?
I have also had a difficult time running TKLBAM restores because the max_allowed_packet gets too large. I think there have been other problems in that arena as well.
Do folks have general thoughts on what can be buttoned up in the systems? I have a my.cnf file that made Magento run quite abit better, but that is a small element.
Ping Pong time. Thanks for any thoughts here..