把 CLI 从 php7降级到php.6

https://askubuntu.com/questions/761713/how-can-i-downgrade-from-php-7-to-php-5-6-on-ubuntu-16-04

1. Re-Install PHP 5.6

What worked for me was this guide: http://www.lornajane.net/posts/2016/php-7-0-and-5-6-on-ubuntu

Actually is not required to remove php7.0, you can install php5.6 together ( also because you will have dependency problem with phpmyadmin package that required php7.0)

Assuming libapache2-mod-php is a suitable way to enable PHP in Apache for you, you can proceed in this way:

sudo add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get install php7.0 php5.6 php5.6-mysql php-gettext php5.6-mbstring php-mbstring php7.0-mbstring php-xdebug libapache2-mod-php5.6 libapache2-mod-php7.0
2. Switch PHP version:

From php5.6 to php7.0:

Apache:

sudo a2dismod php5.6 ; sudo a2enmod php7.0 ; sudo service apache2 restart
CLI:

sudo update-alternatives --set php /usr/bin/php7.0
From php7.0 to php5.6:

Apache:

sudo a2dismod php7.0 ; sudo a2enmod php5.6 ; sudo service apache2 restart
CLI:

sudo update-alternatives --set php /usr/bin/php5.6

PHP7 载入动态库错误

PHP Warning: PHP Startup: Unable to load dynamic library

我解决的办法php7.0全家桶

sudo apt-get install libapache2-mod-php7.0 libphp7.0-embed libssl-dev openssl php7.0-cgi php7.0-cli php7.0-common php7.0-dev php7.0-fpm php7.0-phpdbg

有效!

innodb不能启动的问题

今天遇到奇怪的问题. 应用程序显示数据写入库正常,也拿到了新的id.但是去数据库看,却没有看到新进来的数据.
于是重启mysql,发现启动不了./var/log/mysql/error.log显示inndob引擎试图往/tmp目录下写临时文件失败了,报告没权限.

/tmp是个符号链接link到一个网络驱动器.一直是走aws内部线路,速度可以没有问题.唯一可疑的是目录下还有2个4G的大log.
尝试多种可能后,决定删除/tmp,重新做一个本地的tmp,然后问题就解决了. 

mysql能启动了,但是数据没有落地(数据没有写入磁盘)的问题依旧.