1008questions
0 votes
asked Jul 20 in Web Server by prasanna (1,060 points)

1 Answer

0 votes

I faced slow fetch issue too (MySQL, InnoDB). Finally I found that innodb_buffer_pool_size is set to 8MB by default for my system which is not enough to handle the query. After increasing it to 1GB performance seems fine

To change innodb_buffer_pool_size add this to your my.cnf

innodb_buffer_pool_size=1G

restart your mysql to make it effect

answered Jul 20 by prasanna (1,060 points)
Welcome to 1008questions Q&A, where you can ask questions and receive answers from other members of the community.
15 questions
12 answers
0 comments
575 users