Description:
Hello!
I see these messages in error log of MySQL about every 5 minutes:
061023 9:31:03 InnoDB: Warning: purge reached the head of the history list,
InnoDB: but its length is still reported as 9459212! Make a detailed bug
InnoDB: report, and post it to bugs.mysql.com
So, I post it as it was suggested. ;-)
Here is my.cnf:
------------------------------------------------------------------------------
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
#cache
query_cache_limit=256M
query_cache_type=1
default-character-set=cp1251
low_priority_updates=1
set-variable = long_query_time=15
log-long-format
log-slow-queries = /usr/local/mysql/data/mysqld.slow.log
#innodb
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
set-variable = innodb_buffer_pool_size=768M
set-variable = innodb_additional_mem_pool_size=100M
# Set .._log_file_size to 25 % of buffer pool size
set-variable = innodb_log_file_size=10M
#set-variable = innodb_log_buffer_size=10M
#for transactions
innodb_flush_log_at_trx_commit = 1
set-variable = innodb_lock_wait_timeout=50
#for recovery
#set-variable = innodb_force_recovery=5
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqldump]
quick
max_allowed_packet = 16M
------------------------------------------------------------------------------
If you need Any additional info, just ask. I'm programmer a bit ;-), so I can even debug MySQL or install custom version from source.
Thanks.
How to repeat:
Don't know. Messages appears every 5 minutes.
