Welcome, Guest. Please login or register.

Author Topic: Optimization  (Read 3037 times)

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2619
    • View Profile
    • NeDi
Optimization
« on: May 01, 2009, 01:39:02 PM »
Getting annoyed with the ever becoming slower messages table, while collecting tons of useless events I looked at optimization strategies. An interesting one is:

ALTER TABLE messages ADD INDEX(time);

Just look at Monitoring-Timeline past line above via mysql then do it again...

This one could be helpful too, but the statistics on Monitoring-Health are still way too slow:

ALTER TABLE messages ADD INDEX(level);

I've been using this for analyzing BTW:
explain SELECT level,count(level) FROM messages GROUP BY level ORDER BY level;

I only don't understand why ORDER BY level desc is much slower than ORDER BY level  ???
Hmm, Rauchi if you still have that book I probably should look into it  ;)
« Last Edit: May 01, 2009, 03:37:48 PM by rickli »
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

rauchi

  • Guest
Re: Optimization
« Reply #1 on: May 11, 2009, 09:19:47 PM »
I will gladly donate it  ;D

Just mail me your address I will send it to you.

regards
Marco