MEMO.rst

Local Hashrate

UPDATE miner_temp AS a
  LEFT OUTER JOIN (
           SELECT time, ip, port, precise_time, elapsed, total_mh
             FROM miner
            WHERE time = (SELECT MAX(time) FROM miner)
       ) b
    ON a.ip = b.ip and a.port = b.port
   SET mhs = IF(
         a.precise_time > b.precise_time
             AND TIMESTAMPDIFF(SECOND, b.precise_time, a.precise_time) >= a.elapsed - b.elapsed - 1
             AND TIMESTAMPDIFF(SECOND, b.precise_time, a.precise_time) <= a.elapsed - b.elapsed + 1,
         (a.total_mh - b.total_mh) / (a.elapsed - b.elapsed),
         a.total_mh / a.elapsed
       );

Installation

apt-get install python3 python3-yaml
wget http://ftp.ntu.edu.tw/MySQL/Downloads/Connector-Python/mysql-connector-python-1.2.3.tar.gz
tar zxpfv mysql-connector-python-1.2.3.tar.gz
cd mysql-connector-python-1.2.3
python3 setup.py install

apt-get install libyaml-devel php5-devel
pecl install yaml

LuCI RPC API