MySQL Cache

Source : http://www.techiecorner.com/45/turn-on-mysql-query-cache-to-speed-up-mysql-query-performance/

It's a very simple.
Simply add to my.ini and restart MySQL service.
query-cache-type = 1          [0 (disable / off), 1 (enable / on) and 2 (on demand)]
query-cache-size = 20M     [the cache size)]

It will boost the performance. For me almost 5x faster.

:)

0 comments:

 
Copyright © peyotest