MoU Signing Ceremony with TEGAS

I recently signed a Memorandum of Understanding (MoU) with TEGAS for working together as strategic partners. The MoU signing ceremony was witnessed by YB Datuk Haji Talib Zulpilip and Datuk Len Talif Salleh. The state government aims to develop digital ecosystem throughout the state through collaborations between government and private sectors. I’m really excited to be part of this, and hopefully this will yield many fruitful results in the coming years.

Shell STEM School Geek-a-thon Competition

I feel very honored to be invited to become the industry technical judge for Shell’s STEM School Geek-a-thon Competition, which was held in my hometown, Bintulu.

10 teams of students of different academic levels were taking part in this competition. They had to come out with creative solutions that incorporate arduino and android applications to solve common domestic and environmental problems and try making the world a better place to live in.

My main role was to check out their prototype, especially the coding that they wrote; and making sure that it is both functional and without plagiarism. Overall, most the projects were really cool and creative!

At the end of the competition, 2 teams were chosen to represent their school to take part in state-level competition in Kuching in 2 months time. I wish the students well, and hope that they will continue to uphold their passion and dreams. Can’t wait to see what they can achieve in coming years!

New Book Published

I have recently published another book with Packt Publishing, entitled “Hands-On GUI Programming with C++ and Qt5“. This is the 3rd book I’ve written so far, and hopefully the content quality is improving more this time.

If you’re using Kindle for reading ebooks, you can get this book from Amazon. Otherwise, you can get the ebook and printed copy at Packtpub. You can also get all the source files used in this book at the Github page.

Killing MySQL Processes

Once in a while you might face problems related to MySQL being not responding. Most of the time it’s due to large database size or you’re running a select query on an un-indexed table. Instead of waiting for the process to complete (which may take hours), you can cancel the stalling processes using the following method.

First, open up another MySQL session and call the following query:

SHOW PROCESSLIST;

Next, you will see results like this:

+—-+—————–+———–+——+———+——+————————+——————+———-+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+—-+—————–+———–+——+———+——+————————+——————+———-+
| 254772 | event_scheduler | localhost | NULL | Daemon | 2693 | Waiting on empty queue | NULL | 0.000 |
| 435342 | root | localhost | NULL | Query | 0 | Table lock | SHOW PROCESSLIST | 0.000 |
+—-+—————–+———–+——+———+——+————————+——————+———-+

Look for the ID of the query which you wish to terminate and use it in the following query, for example:

KILL 435342;

That’s it, the process will then be terminated by MySQL. Hope it helps.