MySQL errors after update , error 1018 (HY000), errno: 24

Today I’ve updated MySQL server on one of my Ubuntu 12.04 servers. After the upgrade finished, shock and horror: all websites were down, WordPress sites were presenting install page. Quickly connected to mysql via CLI and tried to see if the databases are still there:

mysql> show databases;
ERROR 1018 (HY000): Can't read dir of '.' (errno: 24)

I’ve tried setting limits as in this article, but that didn’t seem to help. Only after adding “open-files-limit = 2048” to my.cnf and restarting the MySQL server things went back to normal. So a big thank you to the author of the article, but I would like to know if there is any need setting those limits or not(obviously I was stressed out over the web sites being down and didn’t test all things).

Anyone else has any experience with this problem?

Freelancer acquires vWorker

Today I’ve received an email from Freelancer.com letting me know that they have acquired vWorker.com (RentACoder for older freelancers). I was quite shocked by this news as I never expected that a big site like vWorker will be bought. But life goes on and nothing stays the same forever. I have to say that so far I really enjoy Freelancer’s interface a lot more than vWorker. It’s clean, it’s modern and it’s logical. Even after the face lift vWorker did some time ago the site looked dated and wasn’t very intuitive.

I am still waiting for Freelancer to import my project ratings, I hope they will do it soon. Without rating is really really hard to get a job on a freelancing site. But while I wait for them I’ve already made a bid to check the process. So far I like what I see, it seems very clean and intuitive. I’ve also checked the taxes (10% for free account and 3% for premium) which are not that bad.

One thing that drives me nuts is the “Skills” section. Although I have checked many skills it only displays 5 for my Freelancer profile, while for my Employer profile it displays a lot more. I don’t get it. I’ll probably contact their support, maybe they can enlighten me.

The Portfolio section is beautiful, I cannot even compare to what vWorker had. It’s exactly what you need to display your work.

I’ll update the article as I discover more things (hopefully pleasant) on Freelancer. Meanwhile if you need my services you can click on the button bellow and give me a job on Freelancer.com

LE: One day later and I have all my ratings and projects imported. Good work Freelancer!
PHP Developer