Skip to content

Technology Forum

SEO, Speed Up website, Server Optimization, Linux, Open Source Softwares

  • Home
  • General
    • Web Server
    • Website Formatting
  • IT Companies
  • Optimization
    • PHP
  • Linux
Linux
Linux Commands
HTML
HTML: Link rel – Preload
PHP
Goodbye to DDOS
MySQL
Script to convert InnoDB tables to MyISAM
PHP
SSL Certificate
PHP
TIPS

Calculate Query Cache

Posted on May 6, 2018June 18, 2022 By admin No Comments on Calculate Query Cache
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

Posted on January 23, 2018June 18, 2022 By admin No Comments on Resolving Public DNS Server List
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

Posted on November 26, 2017February 15, 2023 By admin No Comments on Enable memcache in WAMP
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” »

How to Force detecting the Social Profiles associated with a Website

Posted on September 11, 2016February 15, 2023 By admin No Comments on How to Force detecting the Social Profiles associated with a Website
Websites

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

TATA Photon+: Error 638

Posted on September 2, 2016February 15, 2023 By admin No Comments on TATA Photon+: Error 638
Troubleshooting

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

Posts navigation

Previous 1 2 3 … 10 Next

View Posts

  • HTML: Link rel – Preload
  • HTML: Attributes of rel
  • Linux Commands
  • Security HTTP Headers
  • WCAG 2.0 checklist

Categories

  • Domain Name
  • General
    • Servers
    • Web Server
    • Website Formatting
  • IT Companies
  • Linux
  • MySQL
  • Optimization
    • PHP
  • Troubleshooting
  • Web Hosting Control Panel
    • Plesk Panel
  • Websites
    • CSS
    • HTML
    • Optimization
  • Windows
    • Windows 10

Recent Posts

  • HTML: Link rel – Preload
  • HTML: Attributes of rel
  • Linux Commands
  • Security HTTP Headers
  • WCAG 2.0 checklist

Copyright © 2023 Technology Forum.