[eluser]Amir Bukhari[/eluser]
I think I have found the problem:
the problem in the configuration of mysql server on:
########
binlog_cache_size 32768
have_query_cache YES
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
max_binlog_cache_size 4294967295
ndb_cache_check_time 0
query_cache_limit 131072
query_cache_min_res_unit 128
query_cache_size 268435456
query_cache_type ON
query_cache_wlock_invalidate OFF
table_cache 40000
thread_cache_size 384
###############
for some reason I got always the old query result from the cache although the table is changed.
when I update a value in a table I always get the old value (weather I click on refresh button or not) after a few min (1..3) I got the correct value.