Calculate the Query cache using MySQL command: SELECT FORMAT(((QCACHE_HITS / (Qcache_hits + Qcache_inserts + Qcache_not_cached))*100),2) AS query_cache_hit_rate_percentage, QCACHE_FREE_BLOCKS, QCACHE_FREE_MEMORY, QCACHE_HITS, QCACHE_INSERTS, QCACHE_LOWMEM_PRUNES, QCACHE_NOT_CACHED, QCACHE_QUERIES_IN_CACHE, QCACHE_TOTAL_BLOCKS FROM ( SELECT MAX(IF(VARIABLE_NAME = ‘QCACHE_FREE_BLOCKS’, VARIABLE_VALUE, NULL)) QCACHE_FREE_BLOCKS, MAX(IF(`VARIABLE_NAME` = ‘QCACHE_FREE_MEMORY’, VARIABLE_VALUE, NULL)) QCACHE_FREE_MEMORY, MAX(IF(`VARIABLE_NAME` = ‘QCACHE_HITS’, VARIABLE_VALUE, NULL)) QCACHE_HITS, MAX(IF(`VARIABLE_NAME` = ‘QCACHE_INSERTS’, VARIABLE_VALUE, NULL)) QCACHE_INSERTS, MAX(IF(`VARIABLE_NAME` = ‘QCACHE_LOWMEM_PRUNES’, … Read More “Calculate Query Cache” »
Category: Optimization
Optimization is necessary to use the standard practises to develop the technology. In websites, we optimize from server to small bit of code. All is try to covered under this category.
This information is largely available online; however, I’ve taken the time to compile a list of the common DNS servers here for your own reference. These servers do not belong to internet service providers but other companies ranging from Google, OpenDNS, DNS.Watch and several others. You can use a command such as Dig to query … Read More “Resolving Public DNS Server List” »
Download memcache for windows (DLL) from https://pecl.php.net/package/memcache Extract the files (php_memcache.dll & php_memcache.pdb) and put in <drive>\wamp\bin\php\phpx.x.xx\ext Update php.ini file with extension=php_memcache.dll (run test page with phpinfo and check “Loaded Configuration File” for php.ini configuration file ) Run following script to test memcache $memcache = new Memcache; $memcache->connect(‘localhost’, 11211) or die (“Could not connect”); $version … Read More “Enable memcache in WAMP” »
What is an SSL certificate? SSL stands for Secure Sockets Layer, a global standard security technology that enables encrypted communication between a web browser and a web server. It is utilized by millions1 of online businesses and individuals to decrease the risk of sensitive information (e.g., credit card numbers, usernames, passwords, emails, etc.) from being … Read More “SSL Certificate” »
Hello all Yesterday, my website faced a SYN flood attack, which is a proper pain in the backside and you know how much of a pain it is only after it happens to you. So, the kiddie hackers (hope I am not tempting fate) managed to make the site unstable for about 6 hours. Here … Read More “Goodbye to DDOS” »