flyweight_visitor的博客

快速入门命令连接数据库mysql -uroot -pmysql> use testdb准备数据mysql> CREATE TABLE child (id int(11) NOT NULL, PRIMARY KEY(id)) ENGINE=InnoDB;mysql> INSERT INTO child (id) values (90),(102);查看当前数据库隔离级别SELECT @@global.tx_isolation;set global tr

https://developpaper.com/take-it-isolation-level-unreal-read-gap-lock-next-key-lock/I’ve written a lot of knowledge points related to MySQL before. I can string them up a little in this article. From SQL execution process, mvcc to lock, I may feel that I

转自【https://www.cnblogs.com/cchust/p/4439107.html】组提交(group commit)是MYSQL处理日志的一种优化方式，主要为了解决写日志时频繁刷磁盘的问题。组提交伴随着MYSQL的发展不断优化，从最初只支持redo log 组提交，到目前5.6官方版本同时支持redo log 和binlog组提交。组提交的实现大大提高了mysql的事务处理性能，下文将以innodb 存储引擎为例，详细介绍组提交在各个阶段的实现原理。redo log的组提交 WAL(W

云计算类Microsoft Cloud Design PatternsAWS Cloud Design PatternsThoughtworks Build Service Mesh软件架构1.Pattern: Microservice Architecture大数据类Flink实战软件工程类[软件研发成本度量规范释义]

MySQL及PostgreSQL安装小计MySQL安装环境准备安装步骤查询有效的MySQL的yum源添加MySQL的yum源安装MySQL导出数据库中的DDLTroubleshootingPostgreSQL安装安装步骤参考资料MySQL安装环境准备OS: CentOS 7安装步骤查询有效的MySQL的yum源yum repolist all | grep mysql添加MySQL的yum源/etc/yum.repos.d/mysql-community.repo# Enable to

PostgreSQL Quick Start常用SQL查询膨胀率SELECT schemaname|| '.' ||relname as table_name, pg_size_pretty(pg_relation_size(schemaname|| '.' ||relname)) as table_size, n_dead_tup, n_live_tup, round(n_dead_tup * 100 /(n_live_tup+ n_de

【转载】https://www.cnblogs.com/zhuyeshen/p/10972049.html1、Mysql的limit用法在我们使用查询语句的时候，经常要返回前几条或者中间某几行数据，这个时候怎么办呢？不用担心，mysql已经为我们提供了这样一个功能。Sql代码 复制代码 收藏代码SELECT * FROM table LIMIT [offset,] rows | rows OFFSET offsetSELECT * FROM table LIMIT [offset,] rows |

https://blog.youkuaiyun.com/hu2010shuai/article/details/55259516(1)QPS(每秒Query量)QPS = Questions(or Queries) / secondsmysql > show global status like ‘Question%’;(2)TPS(每秒事务量)TPS = (Com_commit + Com_rollback) / secondsmysql > show global status like

MySQL分区表验证MySQL分区表快速验证创建分区表SQL验证参考资料MySQL分区表针对MySQL分区表做些简单验证。快速验证创建分区表'CREATE TABLE `tb_raw_order` ( `order_id` int(11) NOT NULL AUTO_INCREMENT, `buyer_id` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total_amount` decimal(65,4) DEFAULT