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” »
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” »
Using schema.org metadata, it’s easy to associate all of your online profiles – both social and local – with your website in just a few lines of code. There is a simple code to put all your social profies on the website, which enable bots to help detecting the social profiles associated with a website … Read More “How to Force detecting the Social Profiles associated with a Website” »
Trying to connect TATA Photon+ and getting an error – Error 638: The remote server is not responding in a timely fashion OR TATA Photon+ is just showing freeze at connecting device Solve this problem by performing this: On the computer go to Windows XP – Start > Control Panel > Network Connections Windows Vista … Read More “TATA Photon+: Error 638” »