存储架构 centos系统大量time wait占用的解决 统计在一台前端机上高峰时间TCP连接的情况,统计命令: netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a... SegmentFault博客 2019-02-23160 0
存储架构 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 ... Hello, buddy! 2019-02-23970 0
存储架构 MySQL -- 主从一致在状态1,客户端的读写都是直接访问节点A,节点B是节点A的从库只是将节点A的更新都同步过来,在节点B本地执行,保持一... 机智的小鸣 2019-02-222880 0
存储架构 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 ... Planet MySQL 2019-02-221930 0
存储架构 MySQL透视器 MySQL是互联网公司数据库的标配,也几乎成为了关系型数据库事实上的标准。 作为一名后端开发,难免有接手别人项目的时候。后... 白季飞龙的个人主页 2019-02-222010 0
存储架构 Galera Cluster for MySQL - Tutorial 1. Introduction This tutorial covers basic information about Galera Cluster for MySQL/MariaDB, with information about... Severalnines 2019-02-221850 0
存储架构 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... Hello, buddy! 2019-02-221040 0
存储架构 Mysql数据备份恢复及主从同步 Mysql备份及主从同步 Mysql备份 1. mysqldump全量备份 1.1 mysqldump备份原理 mysqldump备份数据的过程,实际上就是把数据库... 博客园精华区 2019-02-222140 0
综合编程 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... Node.js Recipes 2019-02-22290 0
存储架构 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... Node.js Recipes 2019-02-222070 0
存储架构 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... Hello, buddy! 2019-02-221110 0
存储架构 MySQL -- 数据可靠性 事务在执行过程中,先把日志写到 binlog cache ,事务 提交 时,再把 binlog cache 写到 binlog file 一个事务的binlog是... 机智的小鸣 2019-02-22670 0
存储架构 【Zabbix】CentOS6.9系统下部署Zabbix-server 3.0 安装Zabbix 关闭selinux [root@localhost ~]# sed -i "s#SELINUX=enforcing#SELINUX=disabled#g" /etc/selinux/con... 博客园精华区 2019-02-2290 0
存储架构 SQL优化 MySQL版 - B树索引进阶详讲(一) SQL优化 MySQL版 - 索引分类、创建方式、删除索引、查看索引、SQL性能问题 作者 Stanley 罗昊 索引分类 单值索引 ... 博客园精华区 2019-02-221500 0
存储架构 LNMP编译安装 LNMP编译安装 1.安装准备 1.1 先卸载之前yum安装的相关软件 #停止mysql服务 /etc/init.d/mysqld stop #停止php-fpm服务 /etc/... 博客园精华区 2019-02-221320 0
存储架构 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... Node.js Recipes 2019-02-221300 0
存储架构 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... Hello, buddy! 2019-02-22770 0
综合技术 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 Performance Blog 2019-02-224940 0
存储架构 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 Performance Blog 2019-02-223120 0
存储架构 MySQL 千万级数据表 partition 实战应用 目前系统的 Stat 表以每天 20W 条的数据量增加,尽管已经把超过3个月的数据 dump 到其他地方,但表中仍然有接近 2KW 条数据,... 稀土掘金 2019-02-213830 0
存储架构 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 ... Hello, buddy! 2019-02-211890 0
存储架构 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... MySQL Server Blog 2019-02-211160 0
综合技术 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... MySQL Server Blog 2019-02-213060 0
存储架构 阿里最全面试130题:阿里天猫、蚂蚁金服、阿里巴巴面试题含答案 【阿里天猫、蚂蚁、钉钉面试题目】 不会做别着急:文末有答案以及视频讲解,架构师资料 1. junit用法,before,beforeClas... 简书 2019-02-211710 0
存储架构 SQL优化 MySQL版 - -B树索引详讲 SQL优化 MySQL版 - -B树索引详讲 作者:Stanley 罗昊 为什么要进行SQL优化呢?很显然,当我们去写sql语句时: 1会发... 博客园精华区 2019-02-213540 0
存储架构 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 ... Hello, buddy! 2019-02-21740 0
存储架构 浅谈MySQL架构体系 一 数据库和数据库实例 在MySQL的学习研究中,存在两个非常容易混淆的概念,即数据库和数据库实例。在MySQL中,数据库... 博客园精华区 2019-02-211430 0
存储架构 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... Hello, buddy! 2019-02-212360 0
存储架构 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... MySQL Troubleshooting Blog 2019-02-211820 0