Re: Database cache corrupted

["Sergio Belkin" <sebelk@xxxxxxxxx>]

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=royale@xxxxxxxxxx