query_cache Archives - Sysadmins of the North

10 June 20163 June 2020

MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

Are you running into MySQL load problems? Learn how to tune MySQL servers for a heavy InnoDB workload, by configuring innodb_buffer_pool_instances. Dividing the InnoDB buffer pool into multiple instances improves Disk I/O. By doing so, you run your database and website more efficiently and faster. Here is a little help for you. Did this post…

Continue reading MySQL InnoDB performance improvement: InnoDB buffer pool instances – Updated!

15 June 201412 June 2020

How to flush MySQL query cache from time to time

How to flush MySQL query_cache to prevent fragmentation of free query cache memory space? Here is a how to for unattended and automatically clearing MySQL’s query cache using a Linux cronjob. And I’ll show you how to on the mysql shell. Did this post helped you solve a problem? Or dit you find it interesting?…

Continue reading How to flush MySQL query cache from time to time

14 February 20134 February 2020

Cache MySQL query results with PHP WinCache

In November 2011, I wrote a post about MySQL query caching with PHP/Zend_Cache, and I recently stumbled upon a blog post caching MySQL query results in memcached by “KutuKupret”. This made me wonder if the same would be easily done with the Windows Cache Extension for PHP. Did this post helped you solve a problem? Or dit…

Continue reading Cache MySQL query results with PHP WinCache

14 November 201115 January 2020

MySQL query caching using PHP/Zend_Cache

By using the Cache.php PHP class of the Zend Framework, you can relatively easy cache MySQL query results to disk. This ensures faster consecutive results and speeds up execution. In this context, caching means: execute a MySQL query once and save the result in a temporary file. For every time that same query is executed,…

Continue reading MySQL query caching using PHP/Zend_Cache