Skip to content

Instantly share code, notes, and snippets.

View sumon-sarker's full-sized avatar
🏠
Working from home

Sumon Sarker sumon-sarker

🏠
Working from home
3 followers · 0 following
View GitHub Profile
@sumon-sarker
sumon-sarker / MySQL-Slow-Query-Configuration-from-MySQL.md
Last active July 22, 2020 05:18

Check the Configuration for Slow Query:

show variables like '%slow%';
show variables like '%long%';

Version 5.1.6 and above:

  1. Enter the MySQL shell and run the following command:
@sumon-sarker
sumon-sarker / MySQL-Slow-Query-Configuration-for-Docker.md
Last active July 22, 2020 04:22
MySQL Slow Query Configuration for Docker

Check running mysql container:

$ sudo docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                    NAMES
26137efa979f        mysql               "docker-entrypoint..."   8 months ago        Up 10 minutes       0.0.0.0:3306->3306/tcp   container-mysql

Check docker container mysql version:

$ sudo docker exec <container-name> mysqld --version`
mysqld  Ver 5.7.15 for Linux on x86_64 (MySQL Community Server (GPL))
@sumon-sarker
sumon-sarker / docker-mysql-slow-query-log.md
Created July 22, 2020 03:16 — forked from akirattii/docker-mysql-slow-query-log.md
memo: MySQL docker container settings for slow query log

Check running mysql container:

$ sudo docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                    NAMES
26137efa979f        mysql               "docker-entrypoint..."   8 months ago        Up 10 minutes       0.0.0.0:3306->3306/tcp   container-mysql

Check docker container mysql version:

$ sudo docker exec container-mysql mysqld --version`
mysqld  Ver 5.7.15 for Linux on x86_64 (MySQL Community Server (GPL))
@sumon-sarker
sumon-sarker / progressive-lazyload.html
Created December 18, 2019 04:30
Progressive JavaScript Image Lazy Load
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Progressive Image lazy Loading</title>
<style>
ul{list-style: none;text-align: center;}
ul li{display: inline-block;}
@sumon-sarker
sumon-sarker / gist:1651d467489ce1b75a0b2963890ac4fb
Created March 21, 2018 04:39 — forked from prime31/gist:5675017
Simple PHP script showing how to send an Android push notification. Be sure to replace the API_ACCESS_KEY with a proper one from the Google API's Console page. To use the script, just call scriptName.php?id=THE_DEVICE_REGISTRATION_ID
<?php
// API access key from Google API's Console
define( 'API_ACCESS_KEY', 'YOUR-API-ACCESS-KEY-GOES-HERE' );
$registrationIds = array( $_GET['id'] );
// prep the bundle
$msg = array
@sumon-sarker
sumon-sarker / mysql_search_by_lat_lang
Created March 12, 2018 07:26
SELECT *, (3959 * acos(cos(radians('40.7142')) * cos(radians(latitudeColName)) * cos( radians(longitudeColName) - radians('-74.0064')) + sin(radians('40.7142')) * sin(radians(latitudeColName)))) AS distance FROM myTable HAVING distance < 15 ORDER BY distance LIMIT 0 , 10
@sumon-sarker
sumon-sarker / HtmlPhpMySql.java
Created January 29, 2018 11:59
How JAVA constructor works
/*File : Html.java*/
import packages.*;
public class Html extends Php{
public Html(){
super(); /*Parent Constructor Initialization*/
}
public static void main(String args[]){
System.out.println("Welcome to HTML 5");
Html html= new Html(); /*Self Constructor Initialization*/
}
@sumon-sarker
sumon-sarker / test-php-basic-auth.php
Created December 29, 2017 20:11 — forked from rchrd2/test-php-basic-auth.php
PHP basic auth example
<?php
function require_auth() {
$AUTH_USER = 'admin';
$AUTH_PASS = 'admin';
header('Cache-Control: no-cache, must-revalidate, max-age=0');
$has_supplied_credentials = !(empty($_SERVER['PHP_AUTH_USER']) && empty($_SERVER['PHP_AUTH_PW']));
$is_not_authenticated = (
!$has_supplied_credentials ||
$_SERVER['PHP_AUTH_USER'] != $AUTH_USER ||
$_SERVER['PHP_AUTH_PW'] != $AUTH_PASS