mysql安装过程（菜鸟教程写的非常详细了） https://www.runoob.com/mysql/mysql-install.html 1.停止你正在运行的mysql 方法一：命令行：net s...
Mysql
Mysql
mysql占用磁盘IO过高的解决办法
一、现象 最近发现Mysql服务器磁盘IO一直很高 # iostat -k -d -x 1 10 Linux 3.10.0-957.el7.x86_64 (push-5-221) 2019年07月05...
Memcache存储大数据的问题
Memcache存储大数据的问题 huangguisu &...
memcached 穿透mysql_memcached 和 mysql 结合使用的两种实现选择？
memcached 和 mysql 结合使用的两种实现选择？ 这是我在知乎上抛出的一个问题”我们的应用已经决定采mysql+memcached 的方式，针对的数据库版本是 mysql 5.1，目前已经...
Mysql
MySQL重启失败：MySQL server PID file could not be found!
今天里维斯社发现服务器磁盘空间满了，然后开始清理磁盘，删除mysql-bin.xxxx文件，又修改了/etc/my.cnf文件，禁用以下3行代码；MySQL server PID file could...
Ubuntu18.04 安装MySQL
#命令1 sudo apt-get update #命令2 sudo apt-get install mysql-server #1 VALIDATE PASSWORD PLUGIN can be u...
Mysql
drop 和truncate table对高并发MySQL性能的影响
问题背景： 2019-08-24T23:47:09.361836+08:00 0 InnoDB: page_cleaner: 1000ms intended loop took 24915ms. Th...
Mysql
mysql循环递归更新数据库内容
<?php function foo(){ $host = 'localhost'; $database = 'test...
![MySQL异常：[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr](https://anyun.org/wp-content/themes/anyun_begin/timthumb.php?src=/ueditor/php/upload/image/20210111/1610349935589664.png&w=280&h=210&a=&zc=1)
Mysql
MySQL异常：[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
MySQL异常： 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregate...
Mysql
mysql在select into outfile时出错
测试mysql的select into outfile时，报错“The MySQL server is running with the --secure-file-priv”查询了下，通过mysql...
