Fast Table Repairs for myisam

Linux
2 Comments

SQL table corruption can happen from time to time for a number of reasons. As we have scaled ExchangeDefender, I ran into a number of situations in which the data inserts were incomplete, or some maintenance tasks (large delete queries) crashed the table. This in turn would affect processes that produced reports and BI based on that data and really create a ton of pain and complaints.

So how does one repair crashed myisam tables?

myisamchk -r /var/lib/mysql/database/table.MYI

This process rebuilds the indexes and the entire table, but is very reactive in nature, you have to be aware of the crashed table in order to repair it.

There is a more maintenance-conscious process called mysqlcheck:

mysqlcheck –auto-repair -A -u dbuser -p database

This is a very thorough (read: slow as @#%@) process that will check all your tables and at the end of it proceed with the repair. Fantastic. Unless you have thousands and thousands of tables that you want to check quickly. This process on our dev box took a day and a half to run. Here is one that executes in less than 10 minutes in just a few lines of php:

$myquery = mysql_query(“show keys from $table”);
if(mysql_error() != “”) { backup / repair / report / log }

Stick that into a loop that goes through all your tables and you’re set.

Poor Corporate Hiring Strategies in SMB

IT Business, IT Culture
6 Comments

I knew there would come a day when I would have to categorically disagree with Karl on virtually every piece of advice he has offered. Take a look at this post on Hiring the Best Employee.

The basic flaw in Karl’s process, and process of hiring in virtually every corporate institution, is that the focus is on finding the right fit for the role, not the right individual for the company. Have you ever heard the following words:

You are just not a good fit.

Yeah, you’re just a fantastic person, very talented, exactly what we are looking for except you didn’t fit the role of the imaginary employee we came up with while circling the lines of the resume of the last two people that didn’t leave this company in a quadruple-fatality shootout.

Criteria hiring works OK in very large companies both because HR department has limited time/money and the employees are not really meant to be very fluid in their capacities. They post a list of qualifications, people with time to rearrange their resume send in their applications, the most apt liars that can repeat them back to HR meet the hiring manager who is really looking for someone that can read and think at the same time. This is an awesome way to hire a burger assembler at McDonalds or a data entry person in a hospitality industry.

It is a horrible way to hire in SMB, and the reason why most one man shops that do hire someone end up firing them on a very short schedule. How is it that someone that fit every one of your criteria, that you really liked, that could do everything that was expected turned out so horribly – as a matter of fact, most turn out so horribly bad that many one man shops never want to hire another person again or be someone’s manager?

Flexible Prospect, Desperate Candidate, Fired Employee

The traditional hiring process falls apart at the mere premise that there are people out there so unfulfilled with their jobs that they have the time to spend on full-day interviews, three lunches and two application appointments. Unless you are offering a LOT of money, or seeking an executive with commensurate pay, you are statistically less likely to find a good candidate and more likely to just find someone that is unemployed for a number of very good reasons.

Think about the desperation for a second. If you are finding a candidate that is willing to put up with such a huge hassle not to work for a brand name company with global visibility (IBM, Google, Microsoft) after which they can go to another big company and claim global experience, how desperate are they for employment now?

Desperation brings out the worst in people. They will lie. They will tailor the right resume. They will subject to every test, interview, assessment and application you give them.

Then as soon as something better, something they really wanted, becomes available they will leave you.

What went wrong? You hired the wrong person. Right role, right fit,  wrong person.

The truth about SMB is that we look for flexible people, ambitious and knowledgeable, that want to work well with other people. But at the same time we want to subject them to baselining, assessments, comparative metrics and treat them as business assets that will constantly learn and evolve just not to the point that they figure out that they can make more money elsewhere for far less work. This is the underlying theory of “Human Resources” — treating people like movable objects, hiring them based on a list of credentials, bullet points, and percentage based compatibility with the set of criteria in the Kit with folders Step 1, Step 2, Step 3.

Then the business owner sits back in dismay when the employee leaves under the most unpleasant of circumstances… seriously, should you ever expect any better?

The Right Hiring Process

Hire people. Not roles.

If you hire the right person, they will find a way to fit the role you give them now. They will be able to adjust as your business adjusts. They will be capable of being promoted, of teaching, managing, nurturing and growing other employees that your company gets as it grows.

If you hire the right role, that employee will be gone with the first sudden shift in your business strategy (read Erick’s book on Managed Services) and you will be stuck at square one of looking for a fit for a hole that will change shape with a business that must change in order to grow and survive.

You can either adjust your business hiring practices to fit your changing business and the rapidly changing IT market… or you can franchise a Subway hole in a wall sandwich shop.

The process of finding, qualifying, and hiring people is NOT bullet point or KIT based. It can’t be downloaded online, it can’t be ran through a computer, it is not something you can process. If you want to see how well the process-based hiring works, go to Target. Look at all the drones there. Not an ounce of passion. Not a cent of personality. Just drones running around doing what the master told them.

But you don’t want that. You want an adaptable, flexible, skilled, creative passionate employee that is going to have your best interest at heart and do as they are told (hopefully for less than market value). Good luck with that.

The process of hiring, qualifying, nurturing, leading, empowering, enabling and growing a creative sales force that can work in a rapidly changing business is at a core of business leadership and being able to work with people and treat them like people.

We look for good people. There is always plenty of business to go around and plenty of things to get people to work on. There is not always a ready supply of people that are motivated, willing and capable of working on what we have. But we also aren’t installing a revolving door in our office.

Hire the right person. Get them to build up your company in the same way you have built it to the point of being able to allocate a salary.

Only then do you get someone who has your company on their mind, not just themselves. 

Cultural expectations of toll free numbers

IT Business, Vladville
10 Comments

One of the fun parts of running a global business is trying to adjust to the different cultural and business expectations of different countries. If you’ve ever worked with the people from the far east you know what I mean, but sometimes even the most inconsequential items tend to make a difference.

In United States, companies are expected to offer toll free numbers, for everything. Unless you want to be bundled into the “I work from my spare bathroom” and “Ask me about making $2K a week from home painted on the back window of my car” types of companies, you spend the extra $8 a month and get a toll free number. It is more than a business identity that separates real companies from scammers on prepaid cell phones, it is an expectation set long ago that customers contacting the company for service should not do so at their own expense. It’s a matter of courtesy, an invitation if you will. Don’t think about the long distance charges, just call us, we’ll foot the bill. Yes, we’ll eat all 6 cents of it to earn hundreds of dollars in business. It’s just good business.

Brits don’t see it quite that way. Totally opposite, actually. Earlier today I was setting up the UK trunks for Shockey Monkey support and the UK telco offered me 0800, 0845 along with every city code in UK. Naturally confused I called one of my partners, James Cash, and asked about the dialing options (and opinions). Apparently, unlike in US, UK companies tend not put a lot of emphasis on toll free use:

0870 is quite expensive to call and should be avoided, 0800 is free to call, 0845 is local rate. I’m pretty sure that 0870 and 0845 are being phased out and replaced by 0844 numbers

Thinking that James may be messing with me I decided to ring up the telco. They said the very same: “Unless you are purely interested in making a sale, 0800 numbers are very few and far in between.

Talk about the opposite world on something so little. What generally indicates a shady operation in USA is the norm in UK where the toll free numbers likely indicate you’re about to be harassed by a slimy sales person.

Pleasing them all… I am not sure where courtesy stops and ridiculing begins but I am all of a sudden more self-conscious about my choice of phone numbers.

You learn something new every day. Not necessarily useful…

The Loudmouth Kick In The AdSense

Vladville
2 Comments

In what is surely to be the most hotly disputed or buried story of 2008, recent study finds that “influencers” happen to have very little actual influence over their audience. Why, I’d never…  You mean to tell me that the worthless people who could only get an English major, the same ones that couldn’t get a real press job and spend their day bashing mainstream media aren’t.. influential? Say it ain’t so man, where is this world going to get true leadership if its not delivered by the guys with 10,000 Twitter buddies reflecting on their stool consistency?

How about the people that are actually doing something? Nah, thats just ridiculous.

Here is the thing, actual creators, movers and shakers tend to either not be very good at communicating or too swamped with what they are actually doing. Reporters, by comparison, are only useful to the extent that they can quickly inform you about whats going on.

So what happens when the reporters try to run the show? What happens when the charlatans try to pretend they matter and build a fantasy world of grandiose self-congratulations? Debates such as “Where has the original thought gone?” start, but all the relevant people have long walked out the door and well, delusion sets in.

Just because you get a lot of traffic, does not make you relevant. Just because you are relevant, does not mean you are influential.

That is something that upsets me the most about blogging, the number of times I have heard that there is no reason to blog just because Susan Bradley says it all already, or because its going to be covered by Engadget or seen on TechMeMe. So what? Blogging is about opinions, about conversations, about presenting an idea.

Do you have an idea? Well, lay it out. People will think about it, come back, and hopefully you will be enriched by what your visitors have to say.

It is also an amazing way to market yourself. I listen to woe is me stories every day about the sales phone not ringing, about customers not banging down the doors, about how things actually require hard work. What did you expect it to be like? An infomercial? You just open up shop, pick a logo, and people slam down your web site and just line up to buy and click and pay attention to you?

There is an incoming wave of reality about to wash out a lot of AdSense accounts fronted by plaguerised me-too “news” you can get everywhere and anywhere else. Find a way to stand out, or its the end of filling up your coffers with the theoretical money (see South Park)

Most of all, find something to say. If there is nothing to you, why should anyone trust you or do business with you?

Excellent breakdown of the numbers and take on the Tipping Point here.

What is different? (24 hours, 3 iPods)

Shockey Monkey
48 Comments

As I mentioned yesterday, if there was ever an easy way for you to score an iPod, this is it. Below you will find three pictures. What is different about them?

 

 

I need to know specifically what difference you see.

Post a comment, three winners will be randomly chosen from the comments that get it right. I’m not looking for the numbers, so this has a medium degree of difficulty.

But hey, free iPod, and an advanced copy of SBS Show #28. Can’t beat that. 

If your opinion is worth $10 you should be standing on the corner begging for money

IT Business
3 Comments

There is pretty much only one thing that Schrag and I agree on, and it’s that IT survey conclusions are worthless because they draw data from unemployed people. Look at the email I just got:

Subject: First 100 survey respondents receive a $10 gift certificate

If you would like to influence the way technology vendors support channel partners serving the government market, please take a few minutes to complete this brief survey.
Everything Channel’s Institute for Partner Education and Development (IPED), the professional services division of the Everything Channel (publishers of CRN & VARBusiness) is conducting an important research project to better understand the requirements of solution providers in the government marketplace to help influence the direction of the partner programs.
Click your personal URL below to complete the survey:

Ok, let’s review: this organization makes money selling conclusions they draw from rapid-fire unemployed IT people that are racing through a survey to make sure they get their $10 as one of the first 100. What sort of legitimate goal can this survey produce with that kind of bait?

I hope the survey’s goal is to figure out how people fail at IT business so horribly that they have the time to enter surveys in the middle of the day for $10.

Maybe IPED is trying to figure out which marketing strategies are failing?

Which markets do you target, with your unemployed ass, so we can tell our readers that those markets are not investing in IT?

I’m familiar with IPED and have met and talked to enough people on their side that I know they are not fools.. but with the incentives like the one above I hope IPED is producing a report: “Fu..ed in IT: Top 100 ways to assure your doom.”

Otherwise, IPED does not have an ounce of credibility to hang on to.

SWAGtrain has left the station

Vladville
Comments Off on SWAGtrain has left the station

IMG_1876First of all, apologies to those of you that recently won stuff from Vladville, podcasts, webcasts, comments, etc. It took me a while to get it all in order and things will be better going forward now that I have the shipping situation figured out. So thanks for waiting and thank you for participating in the SMB IT community.

The SWAG train has left the station and is on its way to you. I shipped a bunch of iPods, SBS boxes and flying monkeys. (please stop asking why I’m not giving away Zunes, it still prints microsoft.com in the headers even if you send it from a yahoo.com freemail account. n3wbs.)

Now, tomorrow is a special treat. I will be posting a puzzle here. I will have three iPods (all ready to go in my office) and the winners not only get those, but also the advanced copy of SBS Show #28. Yes, you did read that right. The sweeps will run for 24 hours, winners will be chosen randomly from the comments, not open to OWN employees, etc.

* Illustration credit: Microsoft Corp (Karlus Swaghooverus, mamal. Found in North California, known for the ability to carry twice the body weight in swag.)

How and when will the next "feature push" come?

IT Business
2 Comments

Selling technology has not been a giant challenge for a really long time. Why? The customers hate their technology and if they rely on it they are willing to spend more money on it to improve it. The trick to selling, to the smallest mortgage broker all the way up as the CIO of the largest bank, has been a mix of being at the right place at the right time and being an answer to the problem of why the computer is slowing down the worker.

We are starting to see the worker catching up to the computer, and vice versa, leaving very little room for the actual software to solve the human problems.

As a result, many on the bottom tier of the IT industry have moved to managed services and the leaders in the software development are running around tripping over the table-computer hybrids trying to figure out a way to solve an infrastructure problems with hosting. Just who is working on the application feature set for business?

Truth is, a lot of people, but they are meeting the wall head on and leaving a lot of blood-brain stained spots on it. Not only is the “innovation” not a hit, but it tends to anger the users that are not willing to accept change to what is already working for them, even if the new solution could work better. Office 2007’s new interface has been met with enough resistance to cause major part of our customer base to simply ignore it. Windows Server 2008, codename “Is it out? Really? Ah well” marked the most giant leap in software management since the batch file got rem’ed out of popular use, is not even on the radar of any of the IT people I deal with. Then there is Vista.

What is the incentive to even work on or invest in deployment of large scale IT solutions if the consumer is gawking at the stripped-down, minimalist solutions like Gmail and Mac OS X?

Where does the money come for, for the would be IT generation, if the user is not interested in what the computer and software can do for them but instead just wish the computer would get out of their way of getting “it” done?

Where does that leave the field of IT consulting?

See you on the 2nd…

Gaypile
2 Comments

Tomorrow is April 1st and I will not be blogging out of protest.

You see, April 1st is the excuse for people without the slightest sense of humor to take one day a year and act like awkward imbeciles. I’m not even going to work tomorrow, I can imagine the helpdesk, voicemail, phone calls and other mediums will be flooded by people that get one obligatory day to pull out the giant stick they carry up their butt the other 364 (or this year, 365) days of the year.

Humbug. I wish most people could stop trying to destroy a productive workday and instead ration out that good spirit and humor over the course of the whole year.

See ya on the 2nd.

Scheduling Woes & Conferencing

Vladville
9 Comments

It’s Monday morning and I’m sure the following may make many of you sick to your stomach so feel free to skip to the next paragraph: I love coming to my office with a smile on my face. I couldn’t be happier with where the business is, where all our product lines are falling, how well things are going and just how much good we’re able to do, from jobs to community (as in community services, not the online cults) empowerment to philanthropic stuff. Having had years of being kicked down and asked “Oh, so what you do is just like ___” I am happy to finally be able to say “___ who? Didn’t they go out of business / fold / sell out?” To be able to come to work and have my choice of meaningful things to work on, instead of working for money, has finally come and I am loving every damn second of it. Yes, even when LA-DC2 is on fire 🙂

Which brings the work addiction – family man equation out of balance. I decided (a while ago) that I wanted my life to have more than just work, and I cut my schedule, I cut my involvement in extracurricular stuff, I have a baby on the way and really a lot of stuff I am truly looking forward to doing. I have effectively pulverized my speaking schedule for 2008 so I do not have the pressure of “Can you blog about this, Can you talk about that, Can we do this, Would you do that” that used to be in my inbox non-stop. So now that there is no expectation, life is easy.

I want to go out and have some fun & make some money, and there are only two conferences that (kind of) fit my schedule. I have been invited to the Microsoft MVP Summit which is two weeks from now, and I would also like to go to WWPC. Here is the problem:

If I go to the Microsoft MVP thing, I may miss the birth of my son if he’s early. If I go to the Microsoft WWPC and leave my lovely wife with a month-old baby for a week, I might come back just in time to watch my own murder at the hands of the aforementioned wife.

The two events are almost mutually exclusive, value-wise, as one is a social/training event and the other is pure and shameless pimping (not that I am otherwise shameful when it comes to pimping, it’s just that people are paying to hear the pitch!)

So what’s the point? Well, the point is that if you’re really down and dirty and trying to build a sustainable business, there is a light at the end of the tunnel, and one day you will not be looking for a way to go to a conference to learn how to get business, but will be trying to think of a way to get out of business so you can go out there and have some fun. Stick it out.

As for me, I’m not sure.