Programming problem's Solution's

Search This Blog

How to know which query is taking long time? (Sloved)

May 22, 2018

Get link
Facebook
X
Pinterest
Email
Other Apps

It will tell you the query which is slowing down you system

SET GLOBAL slow_query_log = 'ON';
SELECT * FROM mysql.slow_log ORDER BY start_time DESC

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

This is a simple PHP script to lookup for blacklisted IP against multiple DNSBLs at once.

<html> <head> <title>DNSBL Lookup Tool - IP Blacklist Check Script</title> </head> <body> <form action="" method="POST"> <input type="text" value="" name="ip" /> <input type="submit" value="LOOKUP" /> </form> <?php if (isset($_POST['ip']) && $_POST['ip'] != null) { $ip = $_POST['ip']; if (filter_var($ip, FILTER_VALIDATE_IP)) { echo dnsbllookup($ip); } else { echo "<h2>Please enter a valid IP</h2>"; } } function dnsbllookup($ip){ $listed; $dnsbl_lookup=array("dnsbl-1.uceprotect.net","dnsbl-2.uceprotect.net","dnsbl-3.uceprotect.net","dnsbl.dronebl.org","dnsbl.sorbs.net","zen.spamhaus.org","cbl.abuseat.org","access.redhawk.org","b.barracudac...

Difference between Const and Define in PHP

you can create constant with " define" keyword at run time. for example: $a = 10; if( $a == 10 ) { define('key','value'); // you can create constant at run time witg " define " keywrord . } $a = 10; if( $a == 10 ) { Const Key = 'value'; // it will genrate an error warning because you can't create contant with " Const " Keyword at run time. } for "Const" you need to intialize it first like Const Key = 'Value'; /* rest code here */

Asynchronous PHP

PHP code is blocking, meaning that one block of code will not run until the block prior to it has finished. It wasn't built with asynchronous execution in mind like Go, NodeJs, and other languages. That's a very simple implementation but I wanted to show you how easily it can be done. For more advanced use cases, Spatie has built a package called spatie/async which runs and manages several PHP processes to run your code in an asynchronous fashion. Follow this article details

Powered by Blogger

How to know which query is taking long time? (Sloved)

It will tell you the query which is slowing down you system

Comments

Post a Comment