Archived community.zenoss.org | full text search
Skip navigation
1203 Views 2 Replies Latest reply: Mar 7, 2012 7:12 PM by stephenmeier RSS
stephenmeier Rank: White Belt 23 posts since
Nov 13, 2008
Currently Being Moderated

Mar 7, 2012 3:33 PM

Mysql performance tweaks

Good Afternoon.

 

I am running zenoss core on a 2x 2Ghz Dual core intel with 8GB of ram.  The history table is realitivly big (4gb with a 1.5gb index)

I want to keep about 6 months worth of history.  Is there some performance modifications that I can do to the my.cnf or move the data base to another server so that my queries against the history table will be faster?

 

Regards,

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points