Ready Boost not for MySQL

2 posts ago, i showed you why having MySQL data on a flash thumb drive no matter how fast will not give you good database performance, But what about Windows ReadyBoost

I have already tested ReadyBoost to validate my theory before presenting it here, The answer is that ReadyBoost will NOT help with MySQL DBs, The reason is that ReadyBoost probes for file size and will only work on small files, large files such as your MySQL MYI or MYD files are skipped automatically.

How you can know this is correct, or how i probed to check that ReadyBoost will not work, i installed the flash drive on a Windows7 Machine, a good SANDISK 16GB extreme, i set it up for ready boost, and i watched the Blue Light that blinks when there is reading or writing, from the minute i executed the script that should talk to MySQL to the end of that execution and the ones that came after it, the blue LED did not blink, and so i know for fact it does not work with MySQL.

An exception would be if you had very very little data (The MySQL data files are very small), but in that case MySQL would have them cached in advance, so there would probably be very little to gain

I think web servers could make use of readyboos for those photos and similar small files, but then again this is just a theory.

Valentine’s Day

Valentine’s Day movie is what everybody is calling an all star movie, why?? because all the cast members of the movie are huge stars, and actually watching a movie that has all these stars in it is a rare thing.. Am i right?? so who’s in this movie.. Well let’s see, Anne Hathaway, Ashton Kutcher, Jennifer Garner, Julia Roberts, George Lopez, Emma Roberts, Taylor Lautner, Taylor Swift, Eric Dane, Bradley Cooper, Jessica Alba, Jessica Biel, Patrick Dempsey, Jamie Foxx, Hector Elizondo.. hoooof.. who else, Katty Bates, Topher Grace, Queen Latifa, and Shirley Macliane. wow that’s a lot of stars in one movie…

The story of the movie is talking about romance, and nothing but romance, as posted on the official site of the movie, “It’s about a group of Los Angelinos as they find their way through romance over the course of one Valentine’s Day”..

I don’t know if this movie is right for everyone, a chick flick is not a movie for everybody you know, but it sure is a good movie for Valentine’s day. Valentine’s Day, February 2010.. Enjoy the trailer..

I Am Ozzy, The Movie…

Ozzy Osbourne’s new memoir is getting scripted, and it’s going to hit the big screen really soon.. But who do you think Ozzy chose to play his part in the movie?? It seems that the prince of darkness wants non other than Johnny Depp to play this part.. He said in a recent interview “I’ve thought about Johnny Depp.” Osbourne added” He’s one of the few actors who knows about rock ‘n’ roll who does a really good English accent.”

Actually, yeah, and hell yeah, i think Depp is the right person for the job, and he’s gonna do it really well.. but wait, what about that dude from America’s got talent?? what’s his name Randy Hanson…

Kelis going GaGa in the 1st Annual Data Awards..

click here for the full size picture of Kelis’ madness

Kelis attended the 1st annual Data awards, dressing up like a combination of Lady Liberty, Lady GaGa, a mermaid, and a donkey i guess.. i really don’t know who her stylist is, but he/she must be killed.. Now.. I know that sometimes celebrities needs to dress funny for publicity reasons.. but come on.. this is ridiculous… GaGa can pull it off easily, not you Kelis, not you…

Pirates Of The Caribbean 4, who's in and who's not…

I really enjoyed the first 3 Pirates of  The Caribbean movies, and i can’t wait to watch the fourth part of the movie.. But who’s going to be in that movie?? Well we know that Captain Jack Sparrow will be in the movie, actually Johnny Depp is going to make over $30 million from that movie, which is fair because come on, what’s Pirates of The Caribbean without Captain Jack Sparrow.. But listen to this neither Orlando Bloom(Will Turner) nor Keira Knightly(Elizabeth Swann) will be playing their parts in the fourth part of the movie.. I really don’t understand how this is going to happen. I guess we’ll have to wait and see.. Are you going to watch the Pirates Of The Caribbean 4

The Losers

Have you ever been betrayed by your own team?? well these guys were.. A highly trained CIA agents are facing the trouble of being followed by their own fellow agents for knowing too much information. And now it’s time to use their special skills to know how this happened exactly and who’s behind it..

Ke$ha uses her music for revenge…

I really didn’t know who she is until a couple of weeks ago, i mean i heard her song Tik Tok on the radio about a 100,000 times, and every girl in town is driving around with “Don’t stop, make it pop DJ, blow my speakers up Tonight, I’mma fight ‘Til we see the sunlight Tick tock on the clock But the party don’t stop, no” But i had no idea who’s singing.. I stopped paying attention i guess, i just enj0y the music.. Well Ke$ha is now one of the most popular singers in the United States, and she’s becoming really huge all around the world. One of the things that really amazed me about that Ke$ha girl is that she’s super honest and she doesn’t care about anything.. which i really like in a girl.. check this out.

Jesus Luz helps Haiti

Jesus Luz getting dressed backstage of Ellus fashion show

Article taken from photos.nos.cc;

On January 19th, Jesus Luz (who seems to be a very busy guy lately) spotted arriving to the Bienal building accompanied by more than ten bodyguards where he went directly to a backstage dressing room which was exclusively reserved for him.

So far, Jesus participated in three runway shows during the Sao Paulo Fashion Week, including “Colcci”, “Gisele Bundchen”, and “Ellus”.

Jesus, who arrived to Sao Paulo on January 18th, 2010 and stayed at the luxurious hotel “Fasano”, got the special catwalk privilege of opening and closing the Ellus show with his double appearance “first wearing a leather jacket, and later in a blue t-shirt”.

During the show, photographers were allowed to get inside the dressing room “but not reporters” as Jesus was in no mood for interviews.

Photos of him dressing and having the final touches of makeup artists can be seen here.

Jesus Luz picture from his DJ charity party at the club Royal on January 20th 2010

But his visit to Brazil held more than just “modeling”. Jesus decided to do some charity work as well. Being a DJ, Jesus held a disco party at club Royal on January 20th 2010, to raise funds for the Haiti victims. His manager, Ibrahim Peterson, told the press that Jesus was greatly moved by the sight of earthquake destruction and therefore decided to help.


MySQL Windows VS MySQL on Linux

Comming across Robin Schumacher’s “MySQL on Windows? Absolutely!” i have some stuff to say

First, I absolutly LOVE windows on my Desktop, and i LOVE Linux on my servers, and i have nothing against windows servers or Linux Desktops, i like Operating systems that get the Job done faster and with least effort, so what suits a job suits me, having never used a mac, i would jump to a mac if they tell me it can help you develop application X faster, why not, but the article here http://dev.mysql.com/tech-resources/articles/mysql_on_windows.html does not seem to make sense to me. Here is why

In the comparison of number of downloads, it clearly reads that windows has 600K downloads VS linux that has 200K downloads, but are you serious ?

On Linux, MySQL is hardly if ever downloaded from mysql.com , while on Windows it is always downloaded from MySQL.COM and therefore i beg an explanation on why you say this statistic tells anything, Also, most developers are like me, they use the Windows edition for development on there development PCs, and then deploy the actual application on a Linux server.

For example, on a debian system i would simply issue

apt-get install mysql-client mysql-server

this will get MySQL binaries from Debian, not from MySQL, and therefore making the statistic not available to you.

Then the article talks about how insignificant the differences between the Linux and Windows edition is, to tell you the truth, this is not the case at least for me, here are SOME examples

Most of my applications can not make good use of RAID because RAID does not help with disk seek time (And therefore latency), My answer to this is usually separating tables to more than 1 hard disk , and although having databases moved to other hard drives is supported in windows by creating a text file, moving individual tables on windows is not, On linux, i simply create a symbolic link to the MYD file, and one to the MYI file, i can even split a single table to 2 hard drives with the indexes on 1 drive and the actual data on the other.

Clustering anyone ??

For a longer list check out http://dev.mysql.com/doc/refman/5.0/en/windows-vs-unix.html , this is certainly is inferior to the Linux counterpart for something like a shared hosting environment (See number of open files and connection timeouts etc..)

Now to add more to that, Linux is a free OS, you install and upgrade it for free, and MySQL is also free, if your business uses many many MySQL servers, your savings on Windows Server licenses can be significant.

The bottom line is, when a company like Oracle (Since it has acquired SUN) gets hold of an open source database engine, you can rest assured objectivity will still be there only when it supports the paying product.

Thanks for listening.

Percy Jackson & the Olympians: Lightning Thief

Gods of Mount Olympus and assorted monsters are going to walk among us, trying to find the prime suspect who stole Zeus’ lightning bolt, and that suspect is just a high school kid called Percy Jackson. But don’t let that fool you, Jackson will find out that he’s half man, half God, and that he’s the son of Poseidon God of The Sea. With the help of his friends, Percy Jackson will use his powers to find his missing mother who disappeared suddenly, and also, the real thieves that took the lightning bolt. Percy Jackson & the Olympians: Lightning Thief  in theaters everywhere, February 2010.. Enjoy the trailer..