I am dealing with several gigabytes of WAF logs.
What I mainly do is searching for some pattern using
"select * from tbl where condition1 and condition 2 and so on"
The problem is the columns are not indexed.
It takes 5~10 minutes to just one simple select query with some conditions.
I am thinking about adopting mysql cluster for better performance and stability.
Would it help my situation? or is there any better way to do it?
Thanks in advance :-)
Aucun commentaire:
Enregistrer un commentaire