MySQL

Timeseries database using MySQL

JDBC Driver TimeZone issue

SET GLOBAL time_zone = '+3:00';

server-error-reference

How max prepare stmt count bring down the production mysql system Who’s leaking prepared statements

Logs

Log Type

Cheatsheet

In bash/terminal

# run the client
mysql -u root -p

# execute sqlscript
mysql < yourfile.sql
mysql db_name < yourfile.sql

In mysql interactive client

-- show database
show databases

-- switch database
connect [dbname]

-- execute ssql script
source yourfile.sql