Skip to content

Instantly share code, notes, and snippets.

View yfuruyama's full-sized avatar

Yuki Furuyama yfuruyama

88 followers · 6 following
View GitHub Profile
@yfuruyama
yfuruyama / spanner_write_skew.txt
Created December 2, 2018 08:42
+----------------------------------------------------------------------+----------------------------------------------------------------------+
| tx1 | tx2 |
+----------------------------------------------------------------------+----------------------------------------------------------------------+
| spanner> BEGIN; | |
| Query OK, 0 rows affected (0.05 sec) | |
| | |
| | spanner> BEGIN; |
|
@yfuruyama
yfuruyama / spanner_read_skew.txt
Last active December 2, 2018 08:41
+---------------------------------------------------+---------------------------------------------------------------+
| tx1 | tx2 |
+---------------------------------------------------+---------------------------------------------------------------+
| spanner> BEGIN RO; | |
| Query OK, 0 rows affected (0.00 sec) | |
| | |
| | spanner> BEGIN; |
| | Query OK, 0 rows affected (0.26 sec) |
| |
@yfuruyama
yfuruyama / spanner_phantom_read_ro.txt
Created December 2, 2018 08:38
+---------------------------------------------------------------------+-------------------------------------------------------------------------------------+
| tx1 | tx2 |
+---------------------------------------------------------------------+-------------------------------------------------------------------------------------+
| spanner> BEGIN RO; | |
| Query OK, 0 rows affected (0.00 sec) | |
| | |
| | span
@yfuruyama
yfuruyama / spanner_phantom_read.txt
Created December 2, 2018 08:36
+---------------------------------------------------------------------+-------------------------------------------------------------------------------------+
| tx1 | tx2 |
+---------------------------------------------------------------------+-------------------------------------------------------------------------------------+
| spanner> BEGIN; | |
| Query OK, 0 rows affected (0.03 sec) | |
| | |
| | span
@yfuruyama
yfuruyama / spanner_non_repeatable_read_ro.txt
Created December 2, 2018 08:34
+---------------------------------------------------+---------------------------------------------------------------+
| tx1 | tx2 |
+---------------------------------------------------+---------------------------------------------------------------+
| spanner> BEGIN RO; | |
| Query OK, 0 rows affected (0.00 sec) | |
| | |
| | spanner> BEGIN; |
| | Query OK, 0 rows affected (0.02 sec) |
| |
@yfuruyama
yfuruyama / spanner_non_repeatable_read.txt
Last active February 19, 2019 03:44
+---------------------------------------------------+---------------------------------------------------------------+
| tx1 | tx2 |
+---------------------------------------------------+---------------------------------------------------------------+
| spanner> BEGIN; | |
| Query OK, 0 rows affected (0.02 sec) | |
| | |
| | spanner> BEGIN; |
| | Query OK, 0 rows affected (0.91 sec) |
| |
@yfuruyama
yfuruyama / spanner_lost_update.txt
Created December 2, 2018 08:24
+------------------------------------------------------+------------------------------------------------------+
| tx1 | tx2 |
+------------------------------------------------------+------------------------------------------------------+
| spanner> BEGIN; | |
| Query OK, 0 rows affected (0.01 sec) | |
| | |
| | spanner> BEGIN; |
| | Query OK, 0 rows affected (0.05 sec) |
| | |
| spanner> SELEC
@yfuruyama
yfuruyama / spanner_dirty_read.txt
Created December 2, 2018 08:22
+---------------------------------------------------------------+---------------------------------------------------+
| tx1 | tx2 |
+---------------------------------------------------------------+---------------------------------------------------+
| spanner> BEGIN; | |
| Query OK, 0 rows affected (1.17 sec) | |
| | |
| | spanner> BEGIN; |
| | Query OK, 0 rows affected (0.06 sec) |
| |
@yfuruyama
yfuruyama / token_info.go
Created October 27, 2018 14:26
Show token info
package main
import (
"fmt"
"io/ioutil"
"log"
"net/http"
"os"
"strings"
)
@yfuruyama
yfuruyama / get_adc_token_info.go
Created October 27, 2018 13:27
Get information about current Application Default Credentials
package main
import (
"context"
"fmt"
"io/ioutil"
"log"
"net/http"
"golang.org/x/oauth2/google"