
This lets you track which of your queries are performing inefficiently and adjust them, either structurally or by applying table indexes as needed, to improve performance. Turn on MariaDB’s slow query log and set MariaDB’s 'long_query_time' variable to a low number. Consider using memcache to store frequently-accessed fragments of data in memory as arrays, thereby reducing the load on your MariaDB database server. Memcache is a high-performance, distributed memory object caching system. LAMP packaged by Bitnami also includes the PHP memcache extension.

Read more about APCu and how to use APC with PHP and Bitnami. Make sure your APC cache has enough memory and a long TTL. APC provides a framework for opcode caching, thereby speeding up PHP applications without needing any code changes. Usually, when a PHP script is executed, the PHP compiler converts the script to opcodes and then executes the opcodes.

LAMP packaged by Bitnami includes APCu, a popular PHP bytecode cache.
