Skip to content

Instantly share code, notes, and snippets.

View phanngoc's full-sized avatar

Phan Ngoc phanngoc

3 followers · 1 following
View GitHub Profile
@phanngoc
phanngoc / variable mysql STG
Created August 30, 2018 02:33
mysql> mysql> SHOW VARIABLES;
+----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+----------------------------------------------------------+-----
@phanngoc
phanngoc / gist:db658116481a50190742f49464a967f5
Created August 30, 2018 02:05
mysql> SELECT * FROM performance_schema.setup_instruments
-> WHERE NAME LIKE '%memory%';
+--------------------------------------------------------------------------------+---------+-------+
| NAME | ENABLED | TIMED |
+--------------------------------------------------------------------------------+---------+-------+
| memory/performance_schema/mutex_instances | YES | NO |
| memory/performance_schema/rwlock_instances | YES | NO |
| memory/performance_schema/cond_instances | YES | NO |
| memory/performance_schema/file_instances | YES | NO |
| memory/performance_schema/socket_instances | YES | NO |
@phanngoc
phanngoc / test-case-3.txt
Last active August 27, 2018 11:04
32 user concurrent
Process Id, time start send message, time reply of bot
1,2018:08:27:10:33:41,2018:08:27:10:33:45
0,2018:08:27:10:33:42,2018:08:27:10:33:47
4,2018:08:27:10:33:43,2018:08:27:10:33:50
6,2018:08:27:10:33:47,2018:08:27:10:33:59
2,2018:08:27:10:33:48,2018:08:27:10:33:59
3,2018:08:27:10:33:48,2018:08:27:10:34:00
@phanngoc
phanngoc / time-search-mysql
Created August 27, 2018 02:07
[
{
"_id": {
"$oid": "5b7fbb70628ff970557c3f25"
},
"name": "test time search",
"time": "368ms",
"memory": "11.50Mb",
"created_at": {
"$date": {
@phanngoc
phanngoc / ChatService.php
Created August 27, 2018 01:22
public function search($text, $referralUrl = '', $isPdca = false, $reChangeText = '', $threadId = null)
{
ubenchStart('test time addMessage');
$text = str_replace("\n", "\r\n", trim($text));
if ($isPdca) {
$this->messageService->addMessageBot($reChangeText, 'text', config('js.owner.user'), Message::RO_CLIENT);
} else {
$this->messageService->addMessageBot($text, 'text', config('js.owner.user'), Message::RO_CLIENT);
}
@phanngoc
phanngoc / số lượng message theo giờ phút
Last active August 9, 2018 03:36
mysql> select count(id), TIME_FORMAT(created_at, "%H %i") from messages where created_at > '2018-08-08 20:10:00' and created_at <= '2018-08-08 20:35:00' group by TIME_FORMAT(created_at, "%H %i");
+-----------+----------------------------------+
| count(id) | TIME_FORMAT(created_at, "%H %i") |
+-----------+----------------------------------+
| 35 | 20 10 |
| 20 | 20 11 |
| 22 | 20 12 |
| 35 | 20 13 |
| 50 | 20 14 |
| 18 | 20 15 |
@phanngoc
phanngoc / Các operator cần biết trong Rxjs
Created July 24, 2018 10:56
1. mapTo
Điều này lờ đi giá trị nguồn và chỉ emit giá trị hằng số được set
```javascript
import { mapTo } from 'rxjs/operators';
const up$ = fromEvent(upButton, 'click');
const down$ = fromEvent(downButton, 'click');
up$.pipe(mapTo(1));
@phanngoc
phanngoc / gist:0a06ba0f286336e64c3b67bb099793de
Last active July 24, 2018 02:41
mysql> select membId from memb where membLoid = "[email protected]";
+---------+
| membId |
+---------+
| 1272314 |
+---------+
1 row in set (0.00 sec)
mysql> select * from MYP.poi_hist where histUsid in (1272314);
@phanngoc
phanngoc / gist:72065e9f0954c5b8ca9dcf2567c3ef1b
Created June 27, 2018 14:52
H/W path Device Class Description
====================================================
system Aspire E5-571 (Aspire E5-571_0866_V1.09
/0 bus EA50_HB
/0/0 memory 128KiB BIOS
/0/4 processor Intel(R) Core(TM) i5-4210U CPU @ 1.70GH
/0/4/6 memory 32KiB L1 cache
/0/4/7 memory 256KiB L2 cache
/0/4/8 memory 3MiB L3 cache
/0/5 memory 32KiB L1 cache
@phanngoc
phanngoc / nginx for macos
Created June 26, 2018 05:24
upstream websocket {
server 0.0.0.0:3000;
keepalive 8;
}
server {
listen 8080 default_server;
listen [::]:8080 default_server ipv6only=on;