友人C

把一件事情做到极致,无惧行业周期变化,天塌下来,这件事情都是赚钱的!

设置每隔5分钟检查mysql运行的状态的方法

由于mysql经常性的挂掉又找不到原因所以写了一个脚步挂掉5分钟自动启动mysql代码如下#!/bin/sh pgrep -x mysqld &> /dev/null if [ $? -ne 0 ];then echo Time at : `date "+%Y%m%d_%H:%M:%S"` is stop. >> 这里写日志文件的路径 /etc/...

小黄  2020-11-05  暂无评论

Be a Fighter

A young friend of mine asked me in a letter, “What kind of man should I be?” My answer was, “Be a fighter.”  Another friend of mine inquired, “How should I live my life?” Again my answer was, “Be a...

小黄  2020-10-29  暂无评论

定时重启mysql的方法

1、编写sh脚本语言#!/bin/sh pgrep -x mysqld &> /dev/null if [ $? -ne 0 ] then echo “At time: `date "+%Y%m%d_%H:%M:%S"` :MySQL is stop .”>> 日志路径 /etc/init.d/mysqld start else ec...

小黄  2020-10-27  暂无评论

网站证书过期了怎样替换?

打开阿里云https://yundun.console.aliyun.com/?spm=5176.2020520160.aliyun_sidebar.220.75601Nwr1Nwroj&p=cas#/overview/cn-hangzhou这个页面购买免费证书,域名需要验证必须打开网站的http访问才能验证。我用的是Apache,下载对应证书上传替换就可以了。因为我用了百度免费cdn,所以...

小黄  2020-10-17  暂无评论

解决Mysql异常挂掉的方法

1.mysql的默认INNODB分配内存大小为128M,而我买的是最初级的服务器,内存比较小,所有需要调整内存。进入etc/my.cnf编辑my.cnf文件 ,在mysql下加入: innodb_buffer_pool_size=50M保存,启动serivce mysqld start 成功

小黄  2020-09-29  暂无评论

When is a man old?

“I dread to come to the end of the year,said a friend to me recently, ”it makes me realize I am growing old.“  William James, the great psychologist, said that most men are ”old fogies at twenty-fi...

小黄  2020-09-23  暂无评论

Power of Self Talk

Life is like a big swing, dangling between the depths of happiness and sadness. As soon as we descend down the slope of sadness, we accelerate over the ever-feel-good acclivity f happiness. At time...

小黄  2020-09-22  暂无评论

Today I begin a new life

Today I am born anew and my birthplace is a vineyard where there is fruit for all.  Today I will pluck grapes of wisdom from the tallest and fullest vines in the vineyard,for these were planted by ...

小黄  2020-09-21  暂无评论

mysql实现先查询后更新的语法

今天遇到一个问题就是利用sql查询最近的一条记录然后更新到另外一个表中,试了很久发觉这样格式才不会报错!update a inner join( select * from d ) b on a.id=b.id set a.name =b.name;

小黄  2020-09-10  暂无评论

mysql导出和导入linux命令

导出命令:mysqldump -uroot -p abc>abc.sql 或者 mysqldump --socket=/usr/local/mysql/mysql.sock -uroot -p abc>abc.sql导入命令:mysql -h localhost -u root -p abc>abc.sql

小黄  2020-08-25  暂无评论