Change innodb_buffer_pool_size Online
If you'd like to raise innodb_buffer_pool_size without restarting mysqld, you can set the variable at run-time. The size unit is in byte. mysql> set global… Read More »Change innodb_buffer_pool_size Online
MySQL 5.7
How to Resolve SQLSTATE[HY000] [1040] Too many connections
MySQL Too many connections Recently, I saw some blank pages on my website without any error, especially when the web server was very busy. I… Read More »How to Resolve SQLSTATE[HY000] [1040] Too many connections
Install Newest LAMP on CentOS 7.2 Minimal (1/4) - Install MySQL 5.7
Install official yum repository. [root@test ~]# rpm -Uvh https://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm Retrieving https://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm warning: /var/tmp/rpm-tmp.aF6L5J: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing... … Read More »Install Newest LAMP on CentOS 7.2 Minimal (1/4) - Install MySQL 5.7
MySQL Set Root Password
Before MySQL 5.7 For the first time to reset root password before MySQL 5.7, you set the new password by mysqladmin: On Windows.C:\Users\ed>mysqladmin -u'root' password… Read More »MySQL Set Root Password