Re: Database cache corrupted
- Date: Sun, 27 Apr 2008 21:56:45 -0700
- From: "Eric Bergen" <eric@xxxxxxxxxxxxxxxxx>
- Subject: Re: Database cache corrupted
Can you send us the exact zabbix error?
On Sun, Apr 27, 2008 at 6:18 PM, Sergio Belkin <sebelk@xxxxxxxxx> wrote:
> So anyone had ever had any problem with database cache? :)
>
> 2008/4/25 Sergio Belkin <sebelk@xxxxxxxxx>:
>
>
> > 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/mysql?unsub=eric@xxxxxxxxxxxxxxxxx
>
>
--
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/mysql?unsub=royale@xxxxxxxxxx