Can you send us the exact zabbix error? On Sun, Apr 27, 2008 at 6:18 PM, Sergio Belkin <[EMAIL PROTECTED]> wrote: > So anyone had ever had any problem with database cache? :) > > 2008/4/25 Sergio Belkin <[EMAIL PROTECTED]>: > > > > Hi, I am using zabbix (monitoring software) with mysql. zabbix goes > > zombie and complains with messages suggesting that Database cache > > perhaps is corrupted. How can I check and fix it? I am using Centos > > 5.1, cpu Intel(R) Xeon(R) CPU and 1 Gb of RAM. > > > > > > my.cnf is as follows: > > > > [client] > > port = 3306 > > socket = /var/lib/mysql/mysql.sock > > [mysqld] > > port = 3306 > > socket = /var/lib/mysql/mysql.sock > > back_log = 50 > > max_connections = 100 > > max_connect_errors = 10 > > table_cache = 1024 > > max_allowed_packet = 16M > > binlog_cache_size = 1M > > max_heap_table_size = 128M > > sort_buffer_size = 8M > > join_buffer_size = 3M > > thread_cache_size = 8 > > thread_concurrency = 8 > > query_cache_size = 64M > > query_cache_limit = 2M > > ft_min_word_len = 4 > > default_table_type = InnoDB > > thread_stack = 192K > > transaction_isolation = REPEATABLE-READ > > tmp_table_size = 64M > > log_slow_queries = /var/log/mysqld/slow-query-log > > long_query_time = 5 > > log_long_format > > tmpdir = /tmp > > log_queries_not_using_indexes = /var/log/mysqld/not-indexes.log > > expire_logs_days = 2 > > server-id = 1 > > key_buffer_size = 8M > > read_buffer_size = 2M > > read_rnd_buffer_size = 16M > > bulk_insert_buffer_size = 64M > > myisam_sort_buffer_size = 128M > > myisam_max_sort_file_size = 10G > > myisam_max_extra_sort_file_size = 10G > > myisam_repair_threads = 1 > > myisam_recover > > skip-bdb > > innodb_additional_mem_pool_size = 16M > > innodb_buffer_pool_size = 600M > > innodb_data_file_path = ibdata1:128M;ibdata2:50M:autoextend:max:12800M > > innodb_file_io_threads = 4 > > innodb_thread_concurrency = 16 > > innodb_flush_log_at_trx_commit = 1 > > innodb_log_buffer_size = 8M > > innodb_log_file_size = 256M > > innodb_log_files_in_group = 3 > > innodb_max_dirty_pages_pct = 90 > > innodb_lock_wait_timeout = 120 > > [mysqldump] > > quick > > max_allowed_packet = 16M > > [mysql] > > no-auto-rehash > > [isamchk] > > key_buffer = 512M > > sort_buffer_size = 512M > > read_buffer = 8M > > write_buffer = 8M > > [myisamchk] > > key_buffer = 512M > > sort_buffer_size = 512M > > read_buffer = 8M > > write_buffer = 8M > > [mysqlhotcopy] > > interactive-timeout > > [mysqld_safe] > > open-files-limit = 8192 > > > > EOF > > > > Thanks in advance! > > > > -- > > -- > > Open Kairos http://www.openkairos.com > > Watch More TV http://sebelk.blogspot.com > > Sergio Belkin - > > > > > > -- > -- > Open Kairos http://www.openkairos.com > Watch More TV http://sebelk.blogspot.com > Sergio Belkin - > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
-- high performance mysql consulting. http://provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
