-
Notifications
You must be signed in to change notification settings - Fork 5
MySQL
Lowy Shin edited this page Jul 6, 2020
·
24 revisions
-
Connect from shell
-
mysql -u root -h giipdb.mysql.com -p -P 3306
-
-u
: user -
-p
: ask password -
-h
: host -
-P
: Port
-
-
-
show running SQL
show processlist;
show full processlist \G
-
Cursor
-
Binlog(Binary Log)
-
https://www.ritolab.com/entry/98
- managing binary log
-
https://www.percona.com/blog/2015/07/30/why-base64-outputdecode-rows-does-not-print-row-events-in-mysql-binary-logs/
- Decode binary log
-
https://www.ritolab.com/entry/98
-
Start option
-
Run from sql file
- Check tuning point using mysqltuner
- You can tune easy by suggestion on mysqltuner
$ wget https://github.com/major/MySQLTuner-perl/zipball/master
$ unzip master
$ cd master
$ ./mysqltuner.pl
-
innodb storage engine
-
SQL relative innodb buffer pool size
-
show innodb engine information
SHOW ENGINE INNODB STATUS\G
-
Query Cache Tuning
-- Configuration
SHOW VARIABLES LIKE '%query_cache%';
-- Usages
SHOW STATUS LIKE 'Qcache%';
- Characterset vs collation
- collation_connection, collation_server
- character_server, character_database
- https://atsuizo.hatenadiary.jp/entry/2016/08/22/090000
- extend timeout from MySQL Workbench client
-
InnoDB: Doing recovery: scanned up to log sequence number 2938498040110
- If you forgot root password...
- https://liginc.co.jp/web/programming/mysql/87393
-
mysqld_safe --skip-grant-tables &
as Run with no pass
- Can not connect userid
- recreate user : https://talklowy-jp.blogspot.com/2020/06/mysql-grant.html
- Update join
UPDATE users a
LEFT JOIN userlog b
ON a.userid = b.userid
SET a.point = a.point + 100
WHERE b.loginstatus = 1;
-
CAST() - converting various datetime format using CAST
-
DATE_FORMAT()
- do not ask password when running cron job or shell batch
- KB wiki is multi-lingual writing. If you want translate to your language, use google translate!
- Go to giip service Page : http://giipweb.littleworld.net
- Documentation : https://github.com/LowyShin/giip/wiki
- Sample automation scripts : https://github.com/LowyShin/giip/tree/gh-pages/giipscripts
See more : https://github.com/LowyShin/giip/wiki
- Token exchanges : https://tokenjar.io/GIIP
- Token exchanges manual : https://www.slideshare.net/LowyShin/giipentokenjario-giip-token-trade-manual-20190416-141149519
- GIIP Token Etherscan : https://etherscan.io/token/0x33be026eff080859eb9dfff6029232b094732c52
If you want get GIIP, contact us any time!
- LowyWorkEnv : https://github.com/LowyShin/Lowyworkenv/wiki
- CLoud RDBMS比較
- MachineLearning
- SQL Server
- ORACLE
- MySQL
- mariadh
- Redis with MySQL
- Mongodb
- Apache-Drill
- A5MK2-MultiDBMSTool
- BI
- Referrals
- Juliaの自動微分パッケージ Zygote の紹介
- color code table
- Canva - free Online Design tool
- vscode
- git(github)
- GoogleSheet
- UiPath(RPA)
- WinAutomation(official)
- Excel
- VNC
- VPN
- Note Tool
- Blog
- google news alert
- Online PDF to JPG
- LoadTest " putty
- Shell/bash
- crontab
- PowerShell
- Windows(DOS) batch
- Wscript/wsf
- AWS
- Azure
- File Sync(rsync, scp...)
- KnownPort(wikipedia)
- CentOS(Linux)
- Windows10
- Android