Tech Guru, Author at Technology Forum

WCAG 2.0 checklist

May 24, 2018May 6, 2022 admin No Comments

Websites

WCAG 2.0 checklist Level A (Beginner) Guideline Summary 1.1.1 – Non-text Content Provide text alternatives for non-text content 1.2.1 – Audio-only and Video-only (Pre-recorded) Provide an alternative to video-only and audio-only content 1.2.2 – Captions (Pre-recorded) Provide captions for videos with audio 1.2.3 – Audio Description or Media Alternative (Pre-recorded) Video with audio has a … Read More “WCAG 2.0 checklist” »

Calculate Query Cache

May 6, 2018June 18, 2022 admin No Comments

MySQL, PHP

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” »

Resolving Public DNS Server List

January 23, 2018June 18, 2022 admin No Comments

PHP, Servers

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” »

Enable memcache in WAMP

November 26, 2017February 15, 2023 admin No Comments

PHP

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” »