hrm.. no DBA around? ;)
On Thu, 30 Apr 2009 14:46:54 +0200, j0ey <[email protected]> wrote: > hej there, > > any hints for tuning the mysql-database for best performance? > > Hardware: > CPU: 2x QuadCore Xeon 2.5GHz > RAM: 8GB > > Software: > Debian 4 / 64bit > OpsView 3.0.3 > > Monitoring: > Host: ~450 > Checks: ~2500 > ODW: enabled > > Sizes (currently): > odw: 5.0G > opsview: 8M > runtime: 4.2G > > > my.cnf: > # InnoDB > innodb_file_per_table = 1 > innodb_flush_log_at_trx_commit = 2 > innodb_flush_method=O_DIRECT > innodb_buffer_pool_size = ??? > innodb_additional_mem_pool_size = ??? > innodb_log_buffer_size =??? > innodb_max_dirty_pages_pct = ??? > > # Binary Logs > binlog_ignore_db = odw > binlog_ignore_db = runtime > > # MyISAM > key_buffer_size = ??? > > # Misc > table_cache = ??? > query_cache_size = ??? > thread_cache = ??? > thread_concurrency = 16 > tmp_table_size = ??? > > [mysqld_safe] > open-files-limit = 8192 > _______________________________________________ > Opsview-users mailing list > [email protected] > http://lists.opsview.org/listinfo/opsview-users _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/listinfo/opsview-users
