vendredi 22 juillet 2016

would mysql cluster help my situation?

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