Getting Started Stable Diffusion with LoRA models
1. About Stable Diffusion
Go MySQL client
MySQL connections
See also this article for further details.
MySQL Driver configurations
The repository for MySQL driver is https://github.com/go-sql-driver/mysql
DSN parameters
The DSN parameters for timeout is either application layer and TCP layer and they’re on client sides.
- timeout: a dial timeout.
- readTimeout: Used to set timeout for reading data from I/O. This is used for
net.Conn.SetReadDeadline - writeTimeout: Used to set timeout for writing data from I/O. This is used for
net.Conn.SetWriteDeadline- Usages
MySQL server configurations
Even if the client connection is disconnected, queries on MySQL servers can keep running.
On MySQL server side, some configurations like wait_timeout is used to close a non-interactive “idle” connection.
See this answer, for example.
In order to stop running queries for longer time, max_execution_time can be used, though it’s only applied to read-only SELECT statements.
See this article for more details.
2024
Linux command cheetsheet
Basic commands
2023
Getting Started with Golang text/template
Template package
Follow Kubernetes the Hard way
This article was written by just following Kelsey Hightower’s Kubernetes Hardway document to understand Kubernetes internal architecture.
Gcp Billing Analyze
There are a few documents to manage billing data in BigQuery Attribution of committed use discount fees and credits How to export to BigQuery Structur...
Manage kubernetes StatefulSet
Operations
Basics of Elasticsearch
Architecture
The Basics of Elasticsearch
Following videos are helpful to understand the overview of Elasticsearch more.
Prometheus Metrics Overview on Grafana
In this post, some variables defined in Grafana are used for Prometheus metrics, including $__rate_interval: This article describes the benefit of this va...
Set up a Grafana operator
Follow this document mainly.
Use Google Secret Manager in a GKE cluster
There are an awesome article about the options to use the Google Secret Manager and their pros and cons. In this article, use Secrets Store CSI Driver by fol...
Set up a vertical pod autoscaler in a GKE cluster
To figure out which kubernetes objects are how much resource, a vertical pod autoscaler might be useful. It has a feature to either automatically update valu...
Set up a prometheus by a prometheus operator in a kubernetes cluster
This document is written by following this document.
Set up a config sync in a GKE cluster
Basically, follow this document
Online Schema Change on TiDB
There is a good video to describe a algorithms of TiDB:
Manage TiKV regions on TiDB
TiDB data is split into multiple nodes and they’re called the name as a region.
Getting Started with cue
Install go install cuelang.org/go/cmd/cue@latest
Getting Started with Kubernetes API by Kubebuilder
This document just follows a quick tutorial for kubebuilder and learn its behavior.
Working around MySQL lock metadata
There are multiple documents about innodb locks on MySQL 5.7: InnoDB locking Locks Set by Different SQL Statements in InnoDB Using InnoDB Transaction ...
Upgrade Windows 10 to Windows 11
I used to use Windows 11, but for some reasons, the OS stopped working and I needed to clean-install it from Windows 10 from windows recovery environment.
Getting Started TiDB on GKE
See another post also to set up a TiDB on minikube.
2022
Getting Started Containerd
Overview
Set up a self-managed kubernetes cluster by kubeadm
Follow an official article for this document when the version of Kubernetes was 1.26 and set up VMs on GCP.
SSH client
SSH configuration
SSH client
SSH configuration
ProxySQL Getting Started
The official document: Docker image and initial configuration
Getting Started with Vitess by Kubernetes Operator
There are fewer lock contentions to worry about, replication is a lot happier, production impact of outages become smaller, backups and restores run faster, ...
Getting Started with TiDB by Kubernetes Operator
Getting Started Use minikube by following this document
MySQL backup and restore
In this article, explain how to backup MySQL database using Percona Xtrabackup. There are two binaries, innobackupex and xtrabackup. innobackupex is a wrappe...
Getting Started with Next.js
Set up TypeScript Next.js with Material UI
tmux
Basic configuration
2021
Getting Started with MySQL Orchestrator
Orchestrator is a tool for MySQL HA and replication management.
Getting started to Consul
Consul is developed by Hashicorp to provide a few features like a service discovery.
MySQL Replication
This configuration is for the version 5.7 and it’s minimum configuration in the official document.
gh-ost
gh-ost
setup a ubuntu desktop computer
I set up Ubuntu for the 1st time since several years ago.
Overviews for Apache cassandra
Apache Cassandra
IntelliJ plugin development
Getting started
jq cheetsheet
jq is used to parse JSON result, format and output on the cli.
Go MySQL client
MySQL connections
Setup a windows desktop computer
This is written on March 2021.
Notes when I updated a WSL version from 1 to 2
I mostly followed this article to update a WSL version, except that I didn’t enable Hyper-V until then and got an error Please enable the Virtual Machine Pla...
Compare static site generator
There are many web sites to compare static site generator, but they miss some explanations that require to me. For some people, these features are important ...
2020
PHP Benchmarks
PHPBench framework
Helm Client
Command list
Getting Started with Kubernetes Deployment
The deployment is many use cases and in this page, they’re not described. For the details for those use cases or the concept of deployment, see official page.
Getting Started with Kubernetes Cronjob
Configurations
Overview about MySQL Lock
This document is written for MySQL 5.7, so these contents may be not correct for other versions.
MySQL Performance
This document is written for MySQL 5.7, so these contents may be not correct for other versions. In this page, performance_schema is mainly discussed.
Git hooks
Configurations
Compare performances of gRPC server streaming and pagination of unary RPC
There are some cases that we wanna fetch all records that are matching with a certain condition from an other gRPC server. In these cases, there are at least...
Overview of gRPC
Written in March, 2020.
bigquery usages
Functions
Enable comments on minimal mistake theme of GitHub pages
The configuration to enable comments is described in the official page.
gitHub pages
Getting Started See Official tutorial for detail steps.
Gitconfig
Configuration The detail for gitconfig is written in official page.
git cli
Written in March 2020.
Enable lunr search for non-posts on minimal mistake theme of GitHub pages
This page explains how to enable searching non-posts pages for Minimal mistakes by Lunr.js for someone who does not know jekyll at all. Lunr.js is the defaul...
Getting Started with MySQL DDL
This document is described based on MySQL 5.6.
Nginx server configurations
Performance
MySQL Tuner
MySQL Tuner tool This is a tool to review a configuration for MySQL server.
kubectl cheetsheet
Collect recent error logs If the logs are outputted by zap, error messages are aggregated by checking level = error. This log does not work very well if the ...
Introduction to GCP Cloud endpoints
The Cloud endpoint is actually the NGINX proxy which offers the following features on GCP. Authentication and validation Logging and monitoring in GCP
HTTP/2 for Go
http package in golang supports HTTP/2 protocols. It’s automatically configured.
2019
Terraform overview
Basic concepts There are some basic components for terraform.
Terraform for GCP
Troubleshootings
Protocol Buffers for Go with Gadgets
gogo/protobuf is the library to store some extensions from golang/protobuf in this repository. There are some useful packages that golang/protobuf does not p...
Introduction to GCP Cloud CDN
Target upstream services Cloud CDN can have only GCP load balancer as the upstream services. And GCP load balancer can configure one of followings for backen...
Getting Started with Google closure library
Some JavaScript library depends on Google Closure. If you need to understand the behavior of such a library, you have to know closure. The official document ...