IndianWebPortal.com

Something Different In Linux

Home » mysql » enable mysql Query cache

enable mysql Query cache

Posted by Rishikesh Vispute Categories: mysql

How to enable mysql Query cache on linux server?

Ans: You need to login to mysql by using root accesss.

==========================
root@server[~]#mysql -u root –pPASSWORD

mysql> SET GLOBAL query_cache_size = 16777216;              (If you want to set query_cache_size=16 MB)
==========================

Then open the my.cnf file and add the following directives.

# vi /etc/my.cnf

query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576

Then restart the mysql service

Done


Popular Posts

remove index.php fro

How to remove index.php from url in magento Ans : If you ...

PHP-Java bridge on p

  What is php-java bridge? The php-java bridge is the php ...

Set expiration for y

If you want to set the expiration to your site ...

Warning: Parameter 1

Error: Warning: Parameter 1 to modMainMenuHelper::buildXML() expected to be a ...

domain pointing to e

If you domain uses external MX record and it is ...