记一次windows内存16G下mysql优化
2013-12-03
# Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or s...
# Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or s...
//时间转成年月日时分秒 select date_format(now(),’%Y%m%d%H%i%S’) //时间转成年月日 select date_format(now(),’%Y%m%d’) //去年此时 select DATE_AD...
首先修改mysql配置文件: 在[mysqld]下面添加skip-grant-tables [[email protected] ~]# vim /etc/my.cnf [mysqld] port &...