Monthly Archives: September 2015

innodb_force_recovery oprions

Mode 1 – Doesn’t crash MySQL when it sees a corrupt page
Mode 2 – Doesn’t run background operations
Mode 3 – Doesn’t attempt to roll back transactions
Mode 4 – Doesn’t calculate stats or apply stored/buffered changes
Mode 5 – Doesn’t look at the undo logs during start-up
Mode 6 – Doesn’t roll-forward from the redo logs (ib_logfiles) during start-up

[error] mod_hostinglimits:Error on LVE enter: LVE(516) HANDLER(application/x-httpd-php5) HOSTNAME(domain.com) URL

You shoud check EP number. lveinfo –period=1d –by-fault=mep –display-username

root@srv [~]# lveinfo –period=1d –by-fault=mep –display-username
+——–+—-+—-+—-+—+—+—+——+—–+—–+—-+—–+—–+—–+—–+
| ID |aCPU|mCPU|lCPU|aEP|mEP|lEP|aPMem |mPMem|lPMem|EPf |PMemF|aIOPS|mIOPS|lIOPS|
+——–+—-+—-+—-+—+—+—+——+—–+—–+—-+—–+—–+—–+—–+
|username| 35 |100 |100 | 8 |149|200|484.4M| 2.4G| 6.8G|6829| 0 | 0 | 22 | 1024|
+——–+—-+—-+—-+—+—+—+——+—–+—–+—-+—–+—–+—–+—–+

lvectl limits $(id -u website_username)
lvectl set ID –maxEntryProcs NEW_NUMBER –save