https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8.0.33.html
docker run --name mysql-8.0.33 -v mysql-8.0.33:/val/lib/mysql -e MYSQL_ROOT_PASSWORD=password -d mysql:8.0.33
Yusuke Shimizu karahiyo
karahiyo
/ mysql8_instant_ddl_failure.md
Last active
June 19, 2023 09:08
[MySQL 8] INSTANT DDL failure with Error 4092:Maximum row versions reached
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "fmt" | |
| "math/rand" | |
| "time" | |
| ) | |
| func decideAd(config map[string]int) string { | |
| var ads []string |
karahiyo
/ ssm-login.fish
Last active
March 13, 2021 09:51
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/local/bin/fish | |
| set aws_profile ( | |
| grep -E '\[profile .*\]' ~/.aws/config \ | |
| | gsed -e "s/\[profile \(.*\)\]/\1/g" \ | |
| | fzf | |
| ) | |
| if test -z "$aws_profile" | |
| exit 1 |
karahiyo
/ assume_role.py
Created
October 24, 2019 11:36
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import boto3 | |
| def assume_role(role_arn, session_name): | |
| assumed = client.assume_role(RoleArn=role_arn, RoleSessionName=session_name) | |
| session = boto3.session.Session(aws_access_key_id=assumed['Credentials']['AccessKeyId'], | |
| aws_secret_access_key=assumed['Credentials']['SecretAccessKey'], | |
| aws_session_token=assumed['Credentials']['SessionToken']) | |
| return session |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env gosh | |
| (use control.thread-pool) | |
| (define (log msg) | |
| (print (sys-time) ": " msg)) | |
| (log "start") | |
| (define (run ls) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env gosh | |
| (use gauche.threads) | |
| (define (log msg) | |
| (print (sys-time) ": " msg)) | |
| (log "start") | |
| (define (run ls) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <details> | |
| <summary>さまりー</summary> | |
| details...details...details...details...details... | |
| details...details...details...details...details... | |
| details...details...details...details...details... | |
| details...details...details...details...details... | |
| details...details...details...details...details... | |
| details...details...details...details...details... | |
| details...details...details...details...details... | |
| details...details...details...details...details... |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| gom "github.com/buger/gor" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| @@GLOBAL.KEY_BUFFER_SIZE + @@GLOBAL.INNODB_BUFFER_POOL_SIZE + @@GLOBAL.INNODB_LOG_BUFFER_SIZE + @@GLOBAL.INNODB_ADDITIONAL_MEM_POOL_SIZE + @@GLOBAL.NET_BUFFER_LENGTH as GLOBAL_BUFFER_SIZE, | |
| @@GLOBAL.SORT_BUFFER_SIZE + @@GLOBAL.MYISAM_SORT_BUFFER_SIZE + @@GLOBAL.READ_BUFFER_SIZE + @@GLOBAL.JOIN_BUFFER_SIZE + @@GLOBAL.READ_RND_BUFFER_SIZE as THREAD_BUFFER_SIZE, | |
| @@GLOBAL.KEY_BUFFER_SIZE + @@GLOBAL.INNODB_BUFFER_POOL_SIZE + @@GLOBAL.INNODB_LOG_BUFFER_SIZE + @@GLOBAL.INNODB_ADDITIONAL_MEM_POOL_SIZE + @@GLOBAL.NET_BUFFER_LENGTH | |
| + (@@GLOBAL.SORT_BUFFER_SIZE + @@GLOBAL.MYISAM_SORT_BUFFER_SIZE + @@GLOBAL.READ_BUFFER_SIZE + @@GLOBAL.JOIN_BUFFER_SIZE + @@GLOBAL.READ_RND_BUFFER_SIZE) * @@GLOBAL.MAX_CONNECTIONS AS TOTAL_MEMORY_SIZE, | |
| (@@GLOBAL.KEY_BUFFER_SIZE + @@GLOBAL.INNODB_BUFFER_POOL_SIZE + @@GLOBAL.INNODB_LOG_BUFFER_SIZE + @@GLOBAL.INNODB_ADDITIONAL_MEM_POOL_SIZE + @@GLOBAL.NET_BUFFER_LENGTH | |
| + (@@GLOBAL.SORT_BUFFER_SIZE + @@GLOBAL.MYISAM_SORT_BUFFER_SIZE + @@GLOBAL.READ_BUFFER_SIZE + @@GLOBAL.JOIN_BUFFER_SIZE + |
karahiyo
/ FizzBuzz.hs
Created
March 22, 2015 14:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| module FizzBuzz where | |
| -- | FizzBuzz test | |
| -- >>> fizzbuzz 1 | |
| -- "1" | |
| -- | |
| -- >>> fizzbuzz 3 | |
| -- "Fizz" | |
| -- | |
| -- >>> fizzbuzz 5 |
NewerOlder