Place of all tech articles

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 query again to the database engine, MySQL retrieves the result set from the cache and returns that to the client. The bigger query_cache_size can cache more result set. Query has

Read More…

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 I will discuss with some important MySQL system variables which mostly affect MySQL performance.  Properly tuned important MySQL system variables will give you a great database experience.  We know that

Read More…