Whilst a truncate table operation is underway a lock mutex around the table is created to ensure data consistency; if using innodb file per table the physical .ibd file must be removed which is a painfully slow operation under ext3.
You are currently browsing the archive for the Practice category.
Tags: data warehouse, MySQL, performance
In short, if your systems failed in the Amazon cloud this week, it wasn’t Amazon’s fault. You either deemed an outage of this nature an acceptable risk or you failed to design for Amazon’s cloud computing model.
via The AWS Outage: The Cloud’s Shining Moment – O’Reilly Broadcast.
Tags: foundation, performance, security
Having worked with interaction and graphical design for iPhone applications during the last couple of years I’ve managed to pick up some lessons the hard way, and in this post I would like to share my thoughts on a couple of do’s and don’ts.
Tags: usability
Take one Central European folk dancing team, a small folk band and an added overlay showing array locations and get them to dance the algorithms in time to “appropriate” folk music. The result is slightly surreal and for a time at least slightly hypnotic.
Tags: digression
Although some analysts questioned the finding of search dominance, its a user behavior that gets stronger every year. Today, many users are so reliant on search that its undermining their problem-solving abilities. Ironically, the better search gets, the more dangerous it gets as people increasingly assume that whatever the search engine coughs up must be the answer.
via Incompetent Research Skills Curb Users Problem Solving Jakob Nielsens Alertbox.
Tags: education
Clients say the darnedest things. The other day, one scoffed, “Anyone who’s looking at our website on a stupid little phone screen probably isn’t our customer anyway.”
Summary:
A single mobile screen with almost no features still required 10 design changes to meet usability guidelines for mobile websites.
via Optimizing a Screen for Mobile Use (Jakob Nielsen’s Alertbox).
The link to the iteration of the page design is worth following as well.
Free Electron Got’chas:
» There are two classes of Free Electrons. Sr. Electrons and Jr. Electrons. Both have similarly productivity yields, but the Senior versions have become politically aware. In technology savvy organizations, most CTOs fall into this category. Think Bill Joy. The Junior versions have all the ability, they just don’t have the experience of dealing with people because they spent a lot of the youth writing their own operating system as a intellectual exercise. These Junior electrons represent the single best hire you can make as a hiring manager. If you get two in twenty years, you’re doing something right.
» Misdirected Free Electron intensity can yield odd results. On one project, I assigned a couple of slippery memory corruption bugs to a Free Electron who nodded quietly and promptly vanished for a week. When he returned, the bugs were fixed and the entire database layer had been rewritten. A piece of code that’d taken two engineers roughly six months to design had been totally redone in seven days. Sound like a great idea until you realize we were working on a small update and did not have the resources or time to test a brand spankin’ new database layer. Oops.
Tags: management
As a manager, think of your day as one full of stories. All day, you’re hearing stories from different people about the different arcs that are being played out in the hallways and conference rooms.
Tags: management
This is not going to be one of those posts about how to widgetize your sidebar because frankly, if by now you still are not using a theme with widgetized aeras you need start looking for one. This post is about how to use those widget area’s in the smartest way possible.
via How to Create the Most Flexible Widget Area in Your Sidebars | BloggingPro.