Database cache corrupted

Database cache corrupted

am 25.04.2008 15:47:46 von Sergio Belkin

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 -

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Database cache corrupted

am 28.04.2008 03:18:28 von Sergio Belkin

So anyone had ever had any problem with database cache? :)

2008/4/25 Sergio Belkin :
> 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=gcdmg-mysql-2@m.gmane.org

Re: Database cache corrupted

am 28.04.2008 06:56:45 von Eric Bergen

Can you send us the exact zabbix error?

On Sun, Apr 27, 2008 at 6:18 PM, Sergio Belkin wrote:
> So anyone had ever had any problem with database cache? :)
>
> 2008/4/25 Sergio Belkin :
>
>
> > 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@provenscaling.com
>
>



--
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=gcdmg-mysql-2@m.gmane.org