![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
莫薇
荆棘之上仰望的人会看透风尘
展开
-
mysql查看系统状态
[root@localhost ~]# which mysqld/usr/sbin/mysqld[root@localhost ~]# /usr/sbin/mysqld --verbose --help |grep -A 1 'Default options'Default options are read from the following files in the given orde...原创 2019-02-25 21:47:40 · 3145 阅读 · 0 评论 -
mysql mmm
本文转载,原文链接:https://blog.51cto.com/13746824/2173073目录:1·MMM 简介2·MMM 各个角色说明3·案例环境介绍4·案例实施5·总结一:MMM 简介:1)MMM 是什么:说得简单点,就是 MySQL 主主复制的管理器。之前的一篇文章讲述了 MySQL的主从复制 + 读写分离,其中原理都相同,有兴趣的朋友可以访问:MySQ...转载 2019-03-15 14:34:30 · 340 阅读 · 0 评论 -
ERROR 1665 (HY000) /binlog简介
1. 报错 ERROR 1665 (HY000)MariaDB [test]> create table jing as select * from st;ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT ...原创 2019-02-25 21:52:18 · 354 阅读 · 0 评论 -
[ERROR] InnoDB: /opt/lampp/var/data/ibdata1 can't be opened in read-write mode
恢复后修改文件夹权限:chown -R mysql.mysql data备份恢复后启动数据库/opt/lampp/sbin/mysqld --defaults-file=/opt/lampp/etc/my.cnf --user=root & 2018-04-16 17:32:31 140001994162432 [Note] InnoDB: Using mutexes ...原创 2019-02-25 21:39:09 · 942 阅读 · 0 评论 -
innobackup做了什么?
--全量备份[root@localhost /]# innobackupex --user=root --password=xxx --socket=/opt/lampp/var/mysql/mysql.sock /opt/lampp/var/backup180416 12:12:36 innobackupex: Starting the backup operation...原创 2019-02-25 21:51:46 · 269 阅读 · 0 评论 -
mysql的trace跟踪
root@D0DCS 15:17:24 [jing]> show create table t1\G;*************************** 1. row *************************** Table: t1Create Table: CREATE TABLE `t1` ( `c1` int(11) NOT NULL DEFAUL...原创 2019-02-25 21:39:41 · 2614 阅读 · 0 评论 -
mysql导出csv
mysql导出set names utf8;--selrct ... into outfileselect id,val from st limit 5 into outfile './st1.csv' CHARACTER SET 'utf8' fields terminated by ',' enclosed by "";mysql导入load data infile './st.cs...原创 2019-02-25 21:44:22 · 354 阅读 · 0 评论 -
mysql日常运维
1. mysql查看数据库大小use 数据库名SELECT sum(DATA_LENGTH)+sum(INDEX_LENGTH) FROM information_schema.TABLES where TABLE_SCHEMA='数据库名';2. mysql表占用的空间SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS FROM T...原创 2019-02-25 21:45:44 · 2583 阅读 · 0 评论 -
mysqldump 原理
Single-transaction 与锁表时间有关打开 show variable like '%gen%'先建回滚点,然后打开,然后释放$ >> mysqldump -uroot -p --protocol=TCP --port=$port --single-transaction --databases testdb > 1.sql===============...原创 2019-02-25 21:53:01 · 401 阅读 · 0 评论 -
MySQL 5.6 - OCP 考题讲解
【dbdao.com MySQL OCP认证专题\】- MySQL 5.6 - OCP 考题讲解1. A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output: Last_SQL...转载 2019-02-25 21:39:58 · 5466 阅读 · 0 评论 -
innodb lock
Innodb type •Sharedand Exclusive Locks•IntentionLocks•RecordLocks•GapLocks•Next-KeyLocks•InsertIntention Locks•AUTO-INCLocks•PredicateLocks for Spatial Indexes Sharedand Exclu...转载 2019-02-25 21:54:03 · 220 阅读 · 0 评论 -
mysql执行计划
EXPLAINOutput Columns id (JSON name: select_id) The SELECT identifier.This is the sequential number of the SELECT withinthe query. The value can be NULL if the row refers to the unionresult of...转载 2019-02-25 21:54:40 · 166 阅读 · 0 评论 -
ocp详解
【dbdao.comMySQL OCP认证专题\】- MySQL 5.6 -OCP 考题讲解===========================第1题============================1. A simplemaster-to-slave replication is currently being used. The following informationis ...转载 2019-02-25 21:46:14 · 2022 阅读 · 0 评论 -
mysql主从配置
日志文件:binlog,慢查询日志(slow query log),查询日志(query log),错误日志(error log) innodb redo log,事务日志数据文件:.frm文件,.MYD文件,.MYI文件,.ibd文件和ibdata文件Replication 相关文件:master.info文件,relay log 和 relay log index,rela...原创 2019-02-25 21:42:01 · 335 阅读 · 0 评论 -
MVCC (多版本并发控制) part 1
原文链接: https://15721.courses.cs.cmu.edu/spring2018/Compare-and-Swap(CAS) 乐观锁实现机制原子操作,认为某一内存位置M的值应为V,如果是,则将位置M的值更新为V’,否则,操作失败 图1.1内存位置M的值为20,compare value为20,两者相等,...原创 2019-05-05 23:39:58 · 496 阅读 · 0 评论