u012922485的博客

每次用的时候都查，索性记录下3种方法select "123"+0select CAST("123" as SIGNED)select CONVERT("123",SIGNED)

1.QPS(每秒Query量)每秒查询量，多次查询diffQPS = Questions(or Queries) / secondsmysql > show global status like 'Question%';2.TPS(每秒事务量)TPS = (Com_commit + Com_rollback) / secondsmysql > show global status like 'Com_commit';mysql > show global...

mysql装好后root@localhost的密码在安装信息里，登陆后1.修改root密码的两种方式UPDATE mysql.user SET password = PASSWORD('newpass')WHERE user = 'root' AND host = 'localhost';alter user 'root'@'localhost' identified by 'newpass';2.创建库，创建用户，授权create database test;CREA

mysql自带只有清理binlog文件配置，没有清理查询日志的配置，因此自己写了个定时清理general_log_file的脚本general_log_file可以存放表里和文件里，由于量很大，不建议放表里以下脚本定时执行可以清理general_log_file文件#!/bin/bashcurrent_dir=`cd $(dirname $0);pwd`cd $current_...