myTop – mySQL – Database – Performance Monitoring Tool

mysql-tutorials

myTop is one of free open source code to monitor mySQL Database in CUI mode. The terminal window show the statistics information about threads queries, uptime and more etc.., The tool helps to optimize and improve performance of mySQL to handle large request and response in the database server. How to install myTOP in Ubuntu ? sudo apt install mytop Configuring myTOP sudo nano /root/.mytop Copy and paste the default settings. host=localhost db=mysql delay=3 port=3306 socket= batchmode=0 color=1 idle=0 Connecting to myTOP :- sudo mytop -u <<USERNAME> –prompt Sample myTOP…

Read More

Google hangout emoji shortcut

WordPress permalink

Google hangout – EMOJI Shortcut keys. Simple keys to show and share in EMOJI   :C frowning/sad face 🙂 or 🙂 smiley (U+263A) <3 heart (U+2764) -<@% honeybee :(|) monkey face :(:) pig face (Y) or (y) thumb up (N) or (n) thumb down (]:{ man with turban </3 or <\\3 broken heart ~@~ pile of poo 😀 or 😀 grinning face ^_^ grinning face with closed eyes :”D laughing face with tears =D laughing face open mouth with happy eyes ^_^;; laughing face open mouth with tear O:) or O=) O:-)…

Read More

strpos in php: PHP strpos(), substr(),

Find the first position for the string inside the string :- strpos() echo strpos(“I love apple, I love apple too!”,”apple”);   Return word from the string substr() substr(“Hello world”,6); echo substr(“Hello world”,0,-1)   – Result : Hello worl echo substr(“Hello world”,-10,-2) – Result : ello wor echo substr(“Hello world”,0,-6) – Result : Hello  

Read More

WordPress: How to move from http to https in wordpress ? SSL Certification

wordpress setup

Are you looking to move the website from https to https. Once you have install the SSL in hosting server, do the below steps to complete and configure the SECURED WORDPRESS SITE. Step : 1 Add the below line in config.php file define(‘FORCE_SSL_ADMIN’, true); Step : 2 Add the below code or ensure the in .htaccess file <IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{HTTPS} off RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] </IfModule>

Read More

WordPress: Submit site to Google Console.

wordpress setup

In this article we guide how to submit the website to Google Console, Sitemap submission and crawl website. Google Console :- We have to submit the website to Google console and need to get meta tag from Google to ensure our website are crawling by Google search engine. Open Google Web Master Add Property Enter Website URL Google provide meta tag information Open WordPress Site Install Plugin thru Add new Plugin “Install Header and Footer” Paste the copied text from Google in header input box. Save the page and back…

Read More

WordPress Memory Exhausted Error ? – Increase PHP Memory

wordpress setup

One of the most common wordpress error is memory size exhausted. This could be occur for different scenario. Commonly the scenario occur while posting or updating the content. In this article, we will guide you how to fix the wordpress memory exhausted error and how to increase php memory to resolve the issues. Error :  Fatal error: Allowed memory size of 23354432 bytes exhausted (tried to allocate 8388616 bytes) in /home4/xxx/public_html/wp-includes/plugin.php How to resolve the issue ?   Open wp-config.php Modify below code define(‘WP_MEMORY_LIMIT’, ’64M’); If the error still persists, enable…

Read More