Mysql performance tweaks

[stephenmeier]

stephenmeier [http://community.zenoss.org/people/stephenmeier] created the discussion

"Mysql performance tweaks"

To view the discussion, visit: http://community.zenoss.org/message/65049#65049

--------------------------------------------------------------
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,
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65049#65049]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[dpetzel]

dpetzel [http://community.zenoss.org/people/dpetzel] created the discussion

"Re: Mysql performance tweaks"

To view the discussion, visit: http://community.zenoss.org/message/65056#65056

--------------------------------------------------------------
I can't recall much documented about this outside of http://community.zenoss.org/message/50843#50843 http://community.zenoss.org/message/50843#50843
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65056#65056]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]

[stephenmeier]

stephenmeier [http://community.zenoss.org/people/stephenmeier] created the discussion

"Re: Mysql performance tweaks"

To view the discussion, visit: http://community.zenoss.org/message/65050#65050

--------------------------------------------------------------
Thanks for the link.  That seems to help with the performance issue.  The queries against that history table are still taking longer than I hoped.  Might need to look into another solution.
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/65050#65050]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]