Re: A very slow query on InnoDb 5.1.67

[Willem van Schevikhoven]

Hi!

Thanks again, i'll give the buffer pool a try. Now that i read about the buffer pool, there is something i actually dont understand. My whole database is 92,84mb in size, so how comes i did see an actual improvement in increasing the innodb_buffer_pool_size from 192M=>380M=>512M=>768M? Perhaps this is beyond the scope of this thread, just my observation of lots of duplicate data in the pool or something else going on.



Ill see what the effects of added memory are tomorrow, and ill get back on topic then =)