http://dimitrik.free.fr/blog/posts/mysql-performance-80-and-utf8-impact.html 2018-04-26 00:58 | MySQL, Performance, UTF8 by Dimitri The world is movin
https://www.bilibili.com/read/cv10762342?spm_id_from=333.999.0.0 原地址 十个漂亮的数学定理赏析 Beauty is the first test: there is no permanent place in the world fo
问题时这样的,我在建表时加了联合索引结果报key长度超过3072个字节了,如下图。 [42000][1071] Specified key was too long; max key length is 3072 bytes 先说解决方案:1.调整索引字段,包括修改字段长度、更换字段;2.使用前缀索
https://github.com/brendangregg/Dump2PNG Visualize file data as a png. Intended for memory or core dumps. This tool is an experiment, intended to char
https://www.jianshu.com/p/fb4dde8baff4 霸爷博客,干货满满。有两篇文章现在还记得,《Linux下如何知道文件被哪个进程写》和《巧用Systemtap注入延迟模拟IO设备抖动》,周末突然想起来,发现能看懂了:) 什么是 systemtap Systemtap is
1.I really like being alone, and I'm really afraid of being alone. 我真的喜欢独处,也真的害怕孤独。 2.The city is full of flowers and 3000 lights for you. 为你花开满城,为你灯明
https://www.cnblogs.com/minglee/p/9232673.html 编译安装完Python3之后,使用pip来安装python库,发现了如下报错: $ pip install numpy pip is configured with locations that requi
https://joemario.github.io/blog/2016/09/01/c2c-blog/ Do you run your application in a NUMA environment? Is it multi-threaded? Is it multi-process with
https://zhuanlan.zhihu.com/p/206743670 Brendan Gregg何许人 Brendan Gregg在性能分析工业界如雷贯耳, 相信看到这篇文章的人肯定知道他的大名. 我们看一下他自己写的bio, 这里摘取的是short版本: Brendan Gregg is
本文主要介绍了iptables的基本工作原理和四表五链等基本概念以及NAT的工作原理。 1、iptables简介 我们先来看一下netfilter官网对iptables的描述: iptables is the userspace command line program used to config
今天给大家下另一个性能提升神器-STRAIGHT_JOIN,在数据量大的联表查询中灵活运用的话,能大大缩短查询时间。 首先来解释下STRAIGHT_JOIN到底是用做什么的: STRAIGHT_JOIN is similar to JOIN, except that the left table i
Yesterday's the past, tomorrow's the future, but today is a gift. That's why it's called the present. Bil Keane Inspirational, Life, Motivational 1610
https://blog.myhro.info/2017/01/how-fast-are-unix-domain-sockets Jan 3, 2017 • Tiago Ilieve Warning: this is my first post written in English, after o
https://alphaoragroup.com/2022/04/06/ash-report-row-source-not-available/ Whenever in ASH report, there is a section called Top SQL with Top Row Sourc
现场测试工程师在半夜电话反馈:在新建的小测试库做XTTS流程验证,遇到错误: ```shell ERROR at line 1: ORA-20001: TABLESPACE(S) IS READONLY OR, OFFLINE JUST CONVERT, COPY ORA-06512: at lin
对于反义疑问句: # 1.反义疑问句语法规则 第一个知识点是:在反义疑问句中,前面肯定描述,反义就是否定去问;前面否定描述,反义就是肯定去问。 简单记忆口诀就是“前肯后否,前否后肯”,举例来说: ```shell He is a teacher, isn't he? 他是一名教师,不是吗? He i
要提升价值就要改变; 要达到完美就得经常改变。 To improve is to change; to be perfect is to change often.
docker 配置Mysql集群 Docker version 20.10.17, build 100c701 MySQL Image version: 8.0.32 Docker container mysql-master is source. mysql-replica is replicat
azure.core.exceptions.ClientAuthenticationError: Authentication failed: AADSTS70011: The provided request must include a 'scope' input parameter. The provided value for the input parameter 'scope' is
Python装饰器实例讲解(一) 多种角度讲述这个知识,这是个系列文章 但前后未必有一定的顺承关系 部分参考网络 本文以一个小案例引出装饰器的一些特点,不涉及理论,后面再谈 案例 写一个代码来求一个数是否是质数 def is_prime(x): if x == 2 : return True eli