Announcement

Collapse
No announcement yet.

Slow Centreon (Database)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Slow Centreon (Database)

    Hello Guys,

    we have a problem that our Centreon is very Slow(all over).
    The main Problem is if we want to configure a host, service etc. it takes about 5 mins to show the configuration site. The same Problem is when we want to save something after configuration.

    We think we have a database Problem.

    We have many slow_queries and select_full_join in our mysql database.

    The database is running on the localhost mysql version: 5.0.77
    Centreon Version: 2.3.6

    How can we fix the indexes for the select_full_joins?
    How can we reduce the slow queries?

    Do you need some more information?And thanks for any Help.

    Best Regards

    Heusini

    Edit: Removed Sql Logs
    Last edited by heusini; 25th July 2013, 13:45.

  • #2
    So we solved the issue.

    We made a update from 2.3.6 to 2.4.4. Solved nothing...

    So we searched after mysql better performance and found something by chance


    Solution:

    We deleted the mysql files /var/lib/mysql/ib_logfile0
    and /var/lib/mysql/ib_logfile1


    Hope this will help others.

    Best Regards

    Heusini

    Comment

    Working...
    X