Daily Bitekletas

The patches includes a few significant features and many enhancement on the manageability and reliability of MySQL database server.

The features are:

• SemiSyncReplication - block commit on a master until at least one slave acknowledges receipt of all replication events.
• MirroredBinlogs - maintain a copy of the master’s binlog on a slave
• TransactionalReplication - make InnoDB and slave replication state consistent during crash recovery
• UserTableMonitoring - monitor and report database activity per account and table
• InnodbAsyncIo - support multiple background IO threads for InnoDB
• FastMasterPromotion - promote a slave to a master without restart

Enhancements include:

• LosslessFloatDump - support dump and restore of float/double without loss of precision
• Use 8X less memory for account and table privileges
• Use fastest compression rather than the default level for client/mysqld networking
• InnodbSampling - control the number of leaf blocks sampled for optimizer statistics
• InnodbStatus - display more statistics in show innodb status
• Reduced number of calls to fsync when the InnoDB background IO thread is active
• Changed InnoDB to recover when InnoDB and MySQL data dictionaries are inconsistent
• NewSqlFunctions - functions for checksums and floating point to string conversion
• Backported START SLAVE UNTIL
• Sort float columns with the order: -INF < negative < 0 < positive < +INF < NaN
• Change long_query_time to be dynamic and log all queries that run for greater than or equal this number of seconds rather than greater than.
• Count connection attempts tha are denied because of max_connections and display the count as denied_connections
• MoreLogging - log actions done on specified tables and SUPER users
• rpl_always_enter_innodb boosts the priority of the slave SQL thread (for replication) in InnoDB by making it ignore the InnoDB concurrency limits
• rpl_event_buffer_size sets the fixed size buffer that is allocated in the master for each connected slave. The buffer is used for replication events smaller than the buffer. This reduces memory allocation done to copy replication events from the master.
• Backported sync-binlog
• Added reserved_super_connections to reserve the final N connections for users with the SUPER privilege
• NewShowStatus - many new variables in SHOW STATUS

More details here..

LAMP is an open source web development platform, a software stack, used together to run dynamic websites. The acronym LAMP stands for: Linux (L), Apache HTTP Server (A), MySQL (M), PHP or Perl or Python (P). The acronym was coined by Michael Kunze coined in an article for the German computing magazine.

I admit that the title kind of confusing and most people would say that running LAMP on Windows is impractical since there are packages that are specifically designed to run on Windows platform like XAMPP. However, I just feel that running XAMP puts a heavy load on work station. I tried it, for me it runs slow. Though it works, I still enjoy working on Linux commandline as most geeks are. I’m a LAMP specifically Linux fan (dual boot - Windows and Ubuntu ) but my work requires me to use Windows.

Read the rest of this entry »

This is a follow up of the recent post I’ve made regarding the Top 10 Worst PCs of All Time as published by PC World. This is a more exhaustive “Worst List” of tech products for the past 11 years.

1. America Online (1989-2006)
2. RealNetworks RealPlayer (1999)
3. Syncronys SoftRAM (1995)
4. Microsoft Windows Millennium (2000)
5. Sony BMG Music CDs (2005)
6. Disney The Lion King CD-ROM (1994)
7. Microsoft Bob (1995)
8. Microsoft Internet Explorer 6 (2001)
9. Pressplay and Musicnet (2002)
10. dBASE IV (1988)
11. Priceline Groceries and Gas (2000)
12. PointCast (1996)
13. IBM PCjr. (1984)
14. Gateway 2000 10th Anniversary PC (1995)
15. Iomega Zip Drive (1998)
16. Comet Cursor (1997)
17. Apple Macintosh Portable (1989)
18. IBM Deskstar 75GXP (2000)
19. OQO Model 1 (2004)
20. CueCat (2000)
21. Eyetop Wearable DVD Player (2004)
22. Apple Pippin @World (1996)
23. Free PCs (1999)
24. DigiScents iSmell (2001)
25. Sharp RD3D Notebook (2004)

Read the complete story..

Jeff Pollard of Drivl.com :

Before you hire some company to redo your website, take a moment to read the 10 most important things for you to understand about that process. Charlton Heston free!
I’ve been working in web design/development for a long time now, both as a hobby and as a profession. During my tenure, I’ve grown to understand a lot about how this industry works, most of which seems totally lost on the clientel that walks through the door. They seem to think that through some sort of black magic, a lot of clicking, a white board, 45 minutes, and a kazoo I will make them this killer website. Sorry, not true.

Some of the points he discussed are very true unfortunately.

A group of developers all over the world are into something big that will soon be in your next phone. OpenMoko is an attempt to create an open/free software stack for mobile phones.

At the moment, there is an actual live phone (Neo1973) being used by developers to further the development of the OpenMoko Framework. Most of the user interface specifications supports stylus and finger based input. The phone functions just like the Apple iPhone but I would think that OpenMoko based phones will be very customizable as it is most likely to run on embedded Linux and QT.  Some more links for your reading pleasure..

•  iPhone and Neo1973 Comparison
• Some photos
• Look and Feel Specs
• Planet OpenMoko - where developers’ blog are aggregated

All in all, their wiki page is very impormative and worth checking out.

My co-developer forwarded this blog entry to me and I just though that it is something that I can learn from.

For those unfamiliar with Captcha, please read on.. - and please come back again