mysql总结

文章目录

1. 1. 配置
2. 2. 建表

配置

*日志

+ 通用log： general_log_file        = /var/log/mysql/mysql.log
+ replication日志： server-id              = 1
    log_bin                        = /var/log/mysql/mysql-bin.log
    expire_logs_days        = 10
    max_binlog_size         = 100M
    binlog_do_db           = include_database_name
    binlog_ignore_db       = include_database_name

mysqld –help –verbose里面查看my.cnf的路径， 一般来说是 /etc/my.cnf > etc/mysql/my.cn > usr/etc/my.cnf > ~/.my.cnf

建表

CREATE TABLE `NewTable` (...PRIMARY KEY (`id`),CONSTRAINT `pk_uid` FOREIGN KEY (`userid`) REFERENCES `blog_user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION)
...
PRIMARY KEY (`id`),
CONSTRAINT `pk_uid` FOREIGN KEY (`userid`) REFERENCES `blog_user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
)

##

ref:

https://code.launchpad.net/~percona-dev/perconatools/tpcc-mysql
https://github.com/junneyang/easybenchmarktesttool.git