现象
- top查看mysql的内存占用比平时高了很多,到60%多,cpu占用也大
- 经常报 too many connections
解决
- 查看mysql当前连接数量:
// 进入 mysql 内,执行:
mysql> SHOW STATUS LIKE 'Threads_connected';
- 调大mysql的最大连接数:
// 进入 mysql 内,执行:
mysql> SET GLOBAL max_connections = 1000;
- 后来随手检查了下各种硬件资源,发现硬盘满了:
$ df -h
- 然后看了眼 mysql 的日志目录: /var/lib/mysql/
- 上面是已经删了一些,一开始特别多,占了50%的硬盘,直接把旧的日志全删了就好多了:
$ rm binlog.0017*
- 清理后 mysql 就恢复正常了
Hi my family member I want to say that this post is awesome nice written and come with approximately all significant infos I would like to peer extra posts like this
“Your writing style is engaging and clear, love it!”
“This post has helped me solve my issue, thanks a ton!”
“Well explained, made the topic much easier to understand!”
Cat Cazino Скачать на Андроид. https://www.pgyer.com/apk/apk/com.cat.c115546
I loved as much as you will receive carried out right here The sketch is attractive your authored material stylish nonetheless you command get got an impatience over that you wish be delivering the following unwell unquestionably come more formerly again since exactly the same nearly a lot often inside case you shield this hike
Every time I visit your website, I’m greeted with thought-provoking content and impeccable writing. You truly have a gift for articulating complex ideas in a clear and engaging manner.
“Great content, learned a lot from this post!”
Simply desire to say your article is as surprising The clearness in your post is simply excellent and i could assume you are an expert on this subject Fine with your permission let me to grab your feed to keep up to date with forthcoming post Thanks a million and please carry on the gratifying work
Your blog is a true hidden gem on the internet. Your thoughtful analysis and in-depth commentary set you apart from the crowd. Keep up the excellent work!
Keep up the fantastic work! Kalorifer Sobası odun, kömür, pelet gibi yakıtlarla çalışan ve ısıtma işlevi gören bir soba türüdür. Kalorifer Sobası içindeki yakıtın yanmasıyla oluşan ısıyı doğrudan çevresine yayar ve aynı zamanda suyun ısınmasını sağlar.
Blue Techker Very well presented. Every quote was awesome and thanks for sharing the content. Keep sharing and keep motivating others.
Sugar defender reviews : sugar defender reviews
“I agree with your points, very insightful!”
certainly like your website but you need to take a look at the spelling on quite a few of your posts Many of them are rife with spelling problems and I find it very troublesome to inform the reality nevertheless I will definitely come back again
Sugar defender reviews : sugar defender reviews
Sugar defender reviews : sugar defender reviews
Nitric boost ultra reviews : https://nitricboostultrareviews.usaloves.com
Nitric boost ultra reviews : https://nitricboostultrareviews.usaloves.com
Nitric boost ultra reviews : https://nitricboostultrareviews.usaloves.com
Nitric boost ultra reviews : https://nitricboostultrareviews.usaloves.com