OT large mysql

[yeti na seznam.cz]

> Co je to za verzi? Neni to zpusobeno tim, ze se vysledek toho dotazu
> nejak cachuje a spatne invaliduje? Kazdopadne byste z toho asi mel
> udelat normalni mysqlbug a reportovat to.

Ano, je dost pravdepodobne, ze je to z cache, ale to si server musi ohlidat.
Jako my.cnf pouzivam my-huge.cnf (This is for large system with memory of 
1G-2G where the system runs mainly). Nektere hodnoty jsem jeste zvysil:

[mysqld]
skip-locking
set-variable    = key_buffer=384M
set-variable    = max_allowed_packet=64M
set-variable    = table_cache=512
set-variable    = sort_buffer=2M
set-variable    = record_buffer=2M
set-variable    = myisam_sort_buffer_size=64M
set-variable    = thread_cache=8
server-id       = 1
set-variable    = net_buffer_length=128M
set-variable    = net_read_timeout=36000
set-variable    = net_write_timeout=36000



Verze 3.23.54

Zkompilovano s parametry
./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data 
--with-charset=czech

Uz jsem na stejny problem narazil kdysi (1/2 roku zpet) u jine databaze  
MySQL.
MySQL pri milionech radku nebo velikosti DB radove ve stovkach MB se chova 
nejak _divne_ :)


martin