存储架构
centos系统大量time wait占用的解决
统计在一台前端机上高峰时间TCP连接的情况，统计命令： netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a...
# MySQL
当前标签中共有 5871 篇文章
存储架构
CHOOSE ALL with Medoo
I have just started using Medoo, and it seems that it's impossible to perform SELECT * FROM users in a simple way. I ...
存储架构
Impact of “tmpdir” change in MySQL replication
Recently we had encountered a strange issue with replication and temp directory(tmpdir) change while working for one ...
存储架构
Galera Cluster for MySQL - Tutorial
1. Introduction This tutorial covers basic information about Galera Cluster for MySQL/MariaDB, with information about...
存储架构
Split the character of the mysql result
Lose the mysql result resource after the first use I have the following code: (query added) $weight_t...
存储架构
Mysql数据备份恢复及主从同步
Mysql备份及主从同步 Mysql备份 1. mysqldump全量备份 1.1 mysqldump备份原理 mysqldump备份数据的过程，实际上就是把数据库...
综合编程
Return rows with nodejs and node-mysql
I'm discovering Nodejs and the node-mysql module. I have a small problem. Every tutorial that I find explain how to d...
存储架构
Return rows with nodejs and node-mysql
I'm discovering Nodejs and the node-mysql module. I have a small problem. Every tutorial that I find explain how to d...
存储架构
Mysql union number of different columns
I know union queries have to have the same number of columns. I'm trying to get results from the table comments a...
存储架构
MySQL -- 数据可靠性
事务在执行过程中，先把日志写到 binlog cache ，事务 提交 时，再把 binlog cache 写到 binlog file 一个事务的binlog是...
存储架构
【Zabbix】CentOS6.9系统下部署Zabbix-server 3.0
安装Zabbix 关闭selinux [root@localhost ~]# sed -i "s#SELINUX=enforcing#SELINUX=disabled#g" /etc/selinux/con...
存储架构
SQL优化 MySQL版 - B树索引进阶详讲（一）
SQL优化 MySQL版 - 索引分类、创建方式、删除索引、查看索引、SQL性能问题 作者 Stanley 罗昊 索引分类 单值索引 ...
存储架构
Sending multiple query results to res.render() using node-mysql and mysql-queue
I [new to node.js and programming in general] have two mysql query results (member info and list of worksh...
存储架构
Duplicate entry for key 'group_key'
I'm running a query in MySQL where I'm grouping by four columns and selecting a lot of things, including the four val...
综合技术
MySQL 8 is not always faster than MySQL 5.7
MySQL 8.0.15 performs worse in sysbench oltp_read_write than MySQL 5.7.25 Initially I was testing group replication p...
存储架构
MySQL 8 is not always faster than MySQL 5.7
MySQL 8.0.15 performs worse in sysbench oltp_read_write than MySQL 5.7.25 Initially I was testing group replication p...
存储架构
MySQL 千万级数据表 partition 实战应用
目前系统的 Stat 表以每天 20W 条的数据量增加，尽管已经把超过3个月的数据 dump 到其他地方，但表中仍然有接近 2KW 条数据，...
存储架构
Finding co values ​​in MYSQL weak relation
I have a weak relation table, called header , it is basically just three ID's: id is an autoincrement primary ...
存储架构
JSON specific window functions in MySQL 8.0
In 8.0, we introduced window functions in MySQL server. A detailed explanation of how window functions can be used a...
综合技术
JSON specific window functions in MySQL 8.0
In 8.0, we introduced window functions in MySQL server. A detailed explanation of how window functions can be used a...
存储架构
阿里最全面试130题：阿里天猫、蚂蚁金服、阿里巴巴面试题含答案
【阿里天猫、蚂蚁、钉钉面试题目】 不会做别着急：文末有答案以及视频讲解，架构师资料 1. junit用法，before,beforeClas...
存储架构
SQL优化 MySQL版 - -B树索引详讲
SQL优化 MySQL版 - -B树索引详讲 作者：Stanley 罗昊 为什么要进行SQL优化呢？很显然，当我们去写sql语句时： 1会发...
存储架构
Mysql Syntax Error in ALTER TABLE
Mysql Syntax Error & hellip; Or is it the PHP? Can someone help me figure out what is wrong with ...
存储架构
MySQL Gets products also bought with a product / Optimize IN query
I'm trying to write a simple 'customers who bought this also bought...'I have an order table, which contains ord...
存储架构
MySQL 8.0 allows unprivileged user access to its data if table mysql.user does not exists
Yesterday my Percona colleague Ceri Williams found a nasty bug in MySQL 8.0. Its twin for Percona Server...
