Recover a Bricked mk802 (LiveSuit error 0x162). :: today I made a mistake, I tried to flash (install) the wrong firmware for my mk802. Once I realized it, I tried flashing the correct firmware, but it's too late – LiveSuit always stopped with error message 0x162. That's it.

After much googling, I found :

The Reason :: that wrong firmware was messing the mk802's partition scheme.

The Fix :: find a firmware that will forces LiveSuit to rearrange the partition scheme.

The Solution :: this is the only firmware I found that will do so : en-us-NEW2-ak003.rar http://beta.androidfilehost.com/?fid=9390077933525140458

Once I flashed it into my mk802, it works again 🙂 thank God.

Hope it helps someone.

On the next post, I'll continue with installing CM10 (CyanogenMod10) on this mk802.

http://www.amazon.com/MK802-Android-Google-Player-Allwinner/dp/B008BFXOZE

Daftar ROM / firmware untuk mk802. :: inilah enaknya menggunakan gadget yang populer – banyak sekali solusi dari komunitas 🙂 yang kualitasnya bahkan jauh lebih bagus daripada vendornya sendiri (rikomagic, you suck)

Selamat menikmati.

http://touchscreen-apps.blogspot.ro/2013/01/mk802ii-firmwares-gathered-on-one-place.html

Susah Tahajud ternyata karena lampu listrik. :: siapa sangka, zaman dahulu, sebelum ada lampu listrik, mayoritas orang terbangun sendiri otomatis di tengah malam, sebelum kemudian tidur kembali.
Ini dikenal dengan istilah "bimodal sleep", atau "segmented sleep" 

Di saat antara dua tidur itu, bisa terjadi berbagai kegiatan – percakapan, mengunjungi tetangga (!), menyiapkan makanan untuk esok hari, dst. 

Pada waktu ini, biasanya adalah saat dimana pikiran sedang jernih, dan tidak ada rasa terburu-buru. Karenanya, ini adalah saat yang sangat tepat untuk bermunajat / tahajud.

Sialnya, pola tidur ini (bimodal sleep) mulai terkikis sejak abad ke 17. Penyebabnya ? Lampu listrik = lampu jalan 🙂 karena terlalu terang, maka, banyak orang yang jadi mundur waktu tidurnya. 

Dan, di awal abad 1900-an, nyaris semua orang sudah lupa, bahwa, selama berabad-abad, manusia itu tidur DUA kali di satu malam.

Terimakasih kepada Dr. Roger Ekirch, kini kita jadi mengetahuinya lagi.

Selamat menikmati : http://www.history.vt.edu/Ekirch/sleepcommentary.html

fish – friendly interactive shell. :: sudah beberapa minggu ini saya menggunakan fish sebagai shell saya di Linux, menggantikan bash. Sangat menyenangkan ! 🙂 akhirnya terasa menggunakan shell yang modern & powerful.

Autocompletion nya kencang sekali, dan malah bisa otomatis menampilkan semua detail parameter command ybs (di parsing langsung dari man page nya !)

Senang dengan fitur auto-correct di smartphone ? Fish juga ada fitur seperti ini, bernama auto-suggestion 🙂 DAN mayoritas suggestion nya akurat 😀 berbeda dengan http://www.DamnYouAutoCorrect.com 😀

Konfigurasi fish juga sangat mudah – via browser :O yup, dari browser. 
Edan 😀

Sekilas kelebihan fish : http://en.wikipedia.org/wiki/Friendly_interactive_shell

Saya pribadi sangat menyarankan artikel berikut ini dari ArsTechnica – disini kita akan makin menyadari akan berbagai kelebihan shell yang satu ini : http://arstechnica.com/information-technology/2005/12/linux-20051218/3/

Enjoy !

http://ridiculousfish.com/shell/

Mass Kill MySQL Sessions :: kadang terjadi ada banyak session yang bermasalah di server MySQL. Contoh yang barusan terjadi di salah satu client saya adalah banyak session yang menggunakan parameter SQL_NO_CACHE == membuat server menjadi berat beban I/O nya, karena mem bypass mekanisme cache @ MySQL.

Terlampir adalah sebaris perintah yang memberhentikan semua sesi tsb :

for each in `mysqladmin proc |grep SQL_NO_CACHE| sort -r -n -k6 | awk {'print $2; '}` ; do mysqladmin kill $each; done

Dalam sekejap, puluhan sesi ini langsung ditutup oleh MySQL.

CATATAN : ganti "SQL_NO_CACHE" di atas dengan string yang relevan pada kasus Anda.

Semoga bermanfaat.

Burger berumur 14 tahun :: David Whipple membeli sebuah burger McDonalds di tahun 1999 – dan lalu lupa. 

Dia baru menemukannya lagi di tahun 2013, dan kaget setengah mati karena burger tersebut tidak berubah ! Tidak ada jamur, tidak ada bau busuk, sama sekali.

Ya, burger McDonalds yang mahal itupun tetap banyak juga berisi berbagai racun, seperti pengawet, dll. Mengerikan. 

Oracle is great for MySQL's development :: one thing I've noticed since MySQL 5.5 – it's of much better quality than the previous versions. A lot of very important features, especially related to InnoDB, are released. 

MySQL 5.6 provides even more excellent features for us.

That's why I think Oracle is making MySQL into a much better product. I'm happy for the MySQL users everywhere.

However, Oracle is starting to close MySQL. Parts of MySQL that's very important to the open source community have begun to be closed down : http://blog.mariadb.org/disappearing-test-cases/

I understand that Oracle feels confident about its ability to develop a superior product. But moves like this causes fear with people, such as "what's next to be gone missing – MySQL's source code ?"

MySQL can become a superior product because of its community. Even giants, like Google, Facebook, Percona, etc; are contributing very important patches to it. If Oracle closes down MySQL, then MySQL will suffer from it.

So, yeah, Oracle is great for MySQL's development. Not so great for its community.

If you're looking for a MySQL-compatible database with great community backing it, then it's simple: MariaDB.

For anyone looking for comparison between MariaBD & MySQL, hope you'll find this useful.

http://blog.mozilla.org/it/2013/04/24/the-3-hidden-messages-in-tomas-ulins-keynote/

You are inspiring a LOT of people to move forward & innovate – even including Google 🙂

Cheers for SciFi movies ! 

Reshared post from +Life at Google

“These are the best times we’ve ever had in search. I have done this for 22 years, and I've been at Google for 12 years, so I should know. This is the most exciting time—every morning I come into work more excited than ever. Strap in. It's all happening in our lifetimes.”

What has +Amit Singhal so excited? +Slate goes behind the scenes with his Knowledge team to learn about our attempt to build "the Star Trek computer."

Gigabit MySQL. :: Percona, konsultan MySQL yang terkenal, membahas pentingnya menggunakan link 100 Mbps untuk koneksi ke server database. 

Barusan sekilas saya memeriksa server database client, ternyata, server MySQL nya ini sudah nyaris menghabiskan seluruh bandwidth link 1 Gbps nya ! 😀

Tidak kebayang akan seperti apa kacaunya jika cuma menggunakan link 100 Mbps 😉 fiuh. 

Di sisi lain, suksesnya server MySQL ini men saturasi link 1 Gbps menunjukkan performa yang handal — servernya sendiri bekerja dengan santai (nyaris tidak ada query yang > 1 detik). Namun, sukses melahap seluruh bandwidth Gbps yang ada.

Network nya yang menjadi bottleneck nya 🙂 bukan lagi servernya.

SOLUSI CEPAT : aplikasi client diubah settingnya, agar menggunakan flag MYSQL_CLIENT_COMPRESS

HASIL : traffic database drop sekitar 20% 🙂

SOLUSI KOMPREHENSIF :

# Memisahkan database-database yang ada ke beberapa server MySQL = traffic jadi terbagi ke beberapa server / link Gbps

# Seluruh aplikasi menggunakan flag MYSQL_CLIENT_COMPRESS

http://www.mysqlperformanceblog.com/2007/12/20/large-result-sets-vs-compression-protocol/

Live feed perburuan tersangka Boston bomber :: di Reddit; menarik sekali, sangat up to date karena di update beramai-ramai oleh komunitas 🙂 CNN pun kalah cepat ;D

Situasi sejauh ini : 1 tersangka tewas (bom di badannya meledak), 1 polisi tewas, 1 polisi cedera. 1 tersangka sedang dikepung.

Selamat membaca :

Bagian I : http://reddit-stream.com/comments/1cnwms/

Bagian II : http://reddit-stream.com/comments/1co395/

Silakan jika ada saran & masukan: terlampir adalah script untuk bypass duplicates query di slave, yang bisa terjadi misalnya karena proses mysqldump terlalu lama (sehingga sudah ada data baru yang di INSERT di master)

==============
<?php

$dbuser = 'root';
$dbpass = 'rahasiaaa';
$dbserver = 'localhost';

mysql_connect($dbserver,$dbuser,$dbpass) or die("Koneksi gagal");

while (true) {

// ambil status slave
$sql = 'show slave status';
$hasil = mysql_query($sql);

$x = mysql_fetch_array($hasil);
//var_dump($x);

// jika ada error 'Duplicate entry', maka skip query tsb
if (($x['Slave_SQL_Running'] == 'No') && (stripos($x['Last_Error'], 'Duplicate entry'))) {

echo "Found problem: ".$x['Last_Error']." — restarting Replication… n";

// skip the problematic query
$sql = 'STOP SLAVE';
$hasil = mysql_query($sql);
$sql = 'SET GLOBAL sql_slave_skip_counter=2';
$hasil = mysql_query($sql);
$sql = 'START SLAVE';
$hasil = mysql_query($sql);

// wait 1 sec before checking again
sleep(1);
};
};

?>

News is bad for you :: In the past few decades, the fortunate among us have recognised the hazards of living with an overabundance of food (obesity, diabetes) and have started to change our diets.

But most of us do not yet understand that news is to the mind what sugar is to the body.

News is easy to digest. The media feeds us small bites of trivial matter, tidbits that don't really concern our lives and don't require thinking. That's why we experience almost no saturation.

Unlike reading books and long magazine articles (which require thinking), we can swallow limitless quantities of news flashes, which are bright-coloured candies for the mind.

Today, we have reached the same point in relation to information that we faced 20 years ago in regard to food. We are beginning to recognise how toxic news can be.

http://www.guardian.co.uk/media/2013/apr/12/news-is-bad-rolf-dobelli

Blazing Fast MySQL Backup :: I've been trying to backup a 400 GB database over network (#), and I kept getting abysmal speed. Even after using compression (mysqldump -C), gzip trick (mysqldump | gzip -c), etc; I can only get 20 Mbps transfer rate at best.

So I looked around, and found out this article about using "tab" option on mysqldump, to make the backup process much faster. 

Apparently, mysqldump spend much of its effort in formatting its output. 
The "tab" option will make mysqldump to save its output in a very sparse format (tab delimited). 

Anyway, since the "tab" option can only be used on disk (not over network), I mounted the destination over network using NFS. Then I pointed mysqldump to use that.

I was shocked to see that I'm getting 200 Mbps transfer speed ! 🙂 instant 10x speed increase. Amazing. 

To be honest, I was sceptical at first. I thought I'd just be getting a bit of performance increase.
But 10x speed increase ? That's just awesome 😀

Listed below is the script to do the fast mysql backup, and its restore. I've also fixed the original script, nothing major, but might be confusing for newbies.

Here you go :

—- fast-mysql-backup.sh —————–
#!/bin/bash
dir=$(date "+%Y-%m-%d_%Hh")
mkdir -m 777 -p /tmp/$dir
for db in $(mysql -BNe "show databases" | grep -v information_schema ) ; do 
  mkdir -m 777 /tmp/$dir/$db
  mysqldump –tab=/tmp/$dir/$db –opt –single-transaction –quick  $db
done
tar czf dump.tgz /tmp/$dir
——————————

—- fast-mysql-restore.sh —————–
#!/bin/bash
### NOTE
# change "dir" with the correct location
# change –use-threads with the number of processors in your computer

dir=/mnt/nfs
cores=16

cd $dir
tar xzf dump.tgz

for db in * ; do
  mysql -e "drop database $db; create database $db default charset utf8"
# create the database structure
cat $db/*.sql | mysql $db
# import the database contents
mysqlimport –use-threads=$cores –local $db $db/*.txt
done
——————————

TIP : to find out network throughput on a server, use "iftop" on linux.

(#) Can not backup to the server itself because it's running out of space…hence the backup (to move its data out, into another server)

Credit : http://matthew.mceachen.us/blog/faster-mysql-dumps-and-loads-with-tab-and-use-threads-1047.html

Cloud14 :: komputer Server dengan 80 prosesor & 128 GB RAM 🙂 siap melayani penggunanya dari seluruh penjuru Indonesia.

http://i.imgur.com/go1mDuG