For example, if your tables are all MyISAM, disable InnoDB in your my.cnf file to save further memory. To identify which server parameters need tuning, and incrementally make changes to your server’s cache and buffers to improve performance. You may use the MariaDB Optimization and Tuning guides, If your application is database-heavy, you’ll gain performance by giving the MariaDB server more memory. You can use tools like mysqldumpslow or mysql-slow-query-log-visualizer to parse and analyze the slow query logs generated. 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.

Xampp installation on linux