I have encountered this when moving my Xbian installation from 8GB card to 32GB one. The solution is to copy everything and force it to resize to 32GB.
1. dd copy old SD card to new bigger SD card (for example:
dd if=/dev/sdd of=/dev/sde bs=4M
where sdd is your old card and sde is your new SD card. Continue reading “Force Xbian resize partition when moving to bigger card”
I have Debian Jessie installed on gk802 Android stick running Freescale i.MX6 quad core CPU. Often I faced issues with kernel panic when allocating pages, which leaves stick unusable.
To mitigate this issue add following to your /etc/sysctl.conf Continue reading “How to prevent kernel panic when allocating page on android sticks running linux”
To keep SSH connection alive you must edit your ~/.ssh/config file (if the file does not exist create it) and enter the following on top of the file:
Host * ServerAliveInterval 60
First line applies this config to all hosts (*), and the second one is interval when to send keepalive packets in seconds (60).
Put this into ~/.bashrc file of your account (if the file does not exist, you create it):
shopt -s histappend PROMPT_COMMAND="history -a;$PROMPT_COMMAND"
In order for this to start working you need to log out and in again.
Execute following command in mysql shell by connecting with your username and password:
mysql> SELECT CONCAT(ROUND(KBS/POWER(1024,
IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.4999),
SUBSTR(' KMG',IF(PowerOf1024<0,0,
IF(PowerOf1024>3,0,PowerOf1024))+1,1))
recommended_key_buffer_size FROM
(SELECT LEAST(POWER(2,32),KBS1) KBS
FROM (SELECT SUM(index_length) KBS1
FROM information_schema.tables
WHERE engine='MyISAM' AND
table_schema NOT IN ('information_schema','mysql')) AA ) A,
(SELECT 3 PowerOf1024) B;Response will be something like this:
+-----------------------------+ | recommended_key_buffer_size | +-----------------------------+ | 1G | +-----------------------------+ 1 row in set (0.08 sec)
When I used this calculation for my Raspberry Pi 2 running MySQL result was 0G, so you need to modify the query to show either MB or KB values by using:
For key_buffer_size recommended size in MB:
SELECT CONCAT(ROUND(KBS/POWER(1024, IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.4999), SUBSTR(' KMG',IF(PowerOf1024<0,0, IF(PowerOf1024>3,0,PowerOf1024))+1,1)) recommended_key_buffer_size FROM (SELECT LEAST(POWER(2,32),KBS1) KBS FROM (SELECT SUM(index_length) KBS1 FROM information_schema.tables WHERE engine='MyISAM' AND table_schema NOT IN ('information_schema','mysql')) AA ) A, (SELECT 2 PowerOf1024) B;Result:
+-----------------------------+ | recommended_key_buffer_size | +-----------------------------+ | 1M | +-----------------------------+ 1 row in set (0.44 sec)
For key_buffer_size recommended size in KB:
SELECT CONCAT(ROUND(KBS/POWER(1024, IF(PowerOf1024<0,0,IF(PowerOf1024>3,0,PowerOf1024)))+0.4999), SUBSTR(' KMG',IF(PowerOf1024<0,0, IF(PowerOf1024>3,0,PowerOf1024))+1,1)) recommended_key_buffer_size FROM (SELECT LEAST(POWER(2,32),KBS1) KBS FROM (SELECT SUM(index_length) KBS1 FROM information_schema.tables WHERE engine='MyISAM' AND table_schema NOT IN ('information_schema','mysql')) AA ) A, (SELECT 1 PowerOf1024) B;and result is:
+-----------------------------+ | recommended_key_buffer_size | +-----------------------------+ | 23K | +-----------------------------+ 1 row in set (0.44 sec)