MySQL – SRE笔记

Tag : MySQL

python mysql 多行查询

2021-02-26 开发

class from dbutils.pooled_db import PooledDB import imp ..

python mysql操作

2021-02-26 开发

# 打开数据库连接 db=MySQLdb.connect(host=”127.0.01″,port=3306, ..

MySQL事务的基本要素（ACID）

原子性（Atomicity）：事务开始后所有操作，要么全部做完，要么全部不做，不可能停滞在中间环节。事务执 ..

调整MySQL数据库参数 innodb_flush_log_at_trx_commit

事务提交设置参数可选值如下： 0: 日志缓冲每秒一次地被写到日志文件，并且对日志文件做到磁盘操作的刷新，但是在 ..

Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

警告 Establishing SSL connection without server’s identit ..

Loading class `com.mysql.jdbc.Driver’. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

Loading class `com.mysql.jdbc.Driver’. This is deprecat ..

mysql主从调参数

MYSQL_ROOTPWD=’2222222222222222222222222′ mysql -N -h m ..

快速查看mysql锁

show processlist; show full processlist; show status li ..

1075 – Incorrect table definition; there can be only one auto column and it must be defined as a key

create table student(id INT AUTO_INCREMENT, name VARCHA ..

mysql.bat查看mysql状态

@echo off ::net start mysql set NAME=%1 set PWD=%2 set ..