Skip to content

Instantly share code, notes, and snippets.

View tom--bo's full-sized avatar

tom--bo tom--bo

30 followers · 39 following
View GitHub Profile
@tom--bo
tom--bo / Antijoin optimization sample with nullable table.sql
Created March 7, 2020 06:42
Antijoin optimization sample with nullable table.sql
--------------------------------------------
-- Definition
--------------------------------------------
mysql> show create table nulltest\G
*************************** 1. row ***************************
Table: nulltest
Create Table: CREATE TABLE `nulltest` (
`c1` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1 row in set (0.01 sec)
@tom--bo
tom--bo / Antijoin optimization sample with NOT NULL table.sql
Last active March 7, 2020 06:40
Antijoin optimization sample with NOT NULL table.sql
--------------------------------------------
-- Definition
--------------------------------------------
mysql> create table not_nulltest (c1 int not null);
Query OK, 0 rows affected (0.02 sec)
mysql> insert into not_nulltest(c1) values(1),(2),(3);
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0
@tom--bo
tom--bo / 007.md
Created September 13, 2019 00:11
mybinlog_samples
@tom--bo
tom--bo / 007.md
Created September 13, 2019 00:11
mybinlog_samples
@tom--bo
tom--bo / conferences.md
Last active March 4, 2017 10:44
Infrastructure_papers

ABOUT

This is the list of popular international conferences and its link to showing full proceedings files in Computer Science, especially for Infrastructure engineer.

OS

  • OSDI
    • Operationg Systems Design and Implementation
    • 13, 14, 15, 16, 17
  • SOSP