Install OCI8 on CentOS/Redhat/Fedora The post will describe how to Install OCI8 on CentOS/Redhat/Fedora in step by step. The easiest way to configure PHP to access…
Optimize MySQL innodb_buffer_pool_size InnoDB buffer pool is the size in bytes of the buffer pool, the memory area where InnoDB caches table and index data.…
Optimize MySQL tmp_table_size MySQL tmp_table_size is the maximum size of internal in-memory temporary tables. (The actual limit is determined as the minimum of tmp_table_size and max_heap_table_size.) If…
Change MySQL Data Directory In Redhat/CentOS/Fedora MySQL default data directory remains in /var/lib/mysql. Sometimes you need to change MySQL data directory to a new location…
Optimize MySQL table_open_cache The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. You can…
Optimize MySQL query_cache_size The MySQL query_cache_size is an in memory caches that stores the complete result sets of frequent SELECT queries. Instead of issuing the…
Important MySQL System Variables MySQL is mostly used open source database which is very fast and effective when you perfectly configure it. In this article…
Installation of Varnish caching server in Redhat/CentOS/Fedora Varnish will significantly improve your website performance as it responses static pages from cache. After installation of Varnish,…
