mysql 5.1

Had evaluated mysql 5.1 and found it to be very good.
Check this out

[root@localhost mysql5]# ./bin/mysqladmin -u root -pjayant status
Uptime: 38621 Threads: 2 Questions: 98346998 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 119 Queries per second avg: 2546.464

The no of queries/second is very high. And the load on the machine is around 2.

Have tried out mysql partitioning on one of the tables. The table has large no of rows – around 90,000,000. And the results were very good. I was able to get large no of queries serverd at the same time from the table.

Few more improvements in the partitioning algorithm can make it rock.

1. Parallel execution of queries on all partitions
2. More efficient administrative commands like alter, add, COALESCE partitions.
3. Decrease locking time of partitions not required in a query.
4. Provision to lock a partition without affecting other partitions.

For more information on partitioning pls go thru the following blog

http://mikaelronstrom.blogspot.com

Hope mysql 5.1 works out fine…

Senti shayari

rotey hain kis kadar unki yaad mein hum
yeh humare ghar ki deewaron se pocchiye

Mujhe dard-e-ishq ka maza malum hai,
Dard-de-dil ki inteha malum hai,
Zindagi me kabhi muskurane ki dua na dena,
Mujhe pal bhar muskurane ki saza malum hai.

palkon ke kinare jo humne bhigoye hi nahi
wo sochte hain hum roye hi nahi
wo poochhte hain khwabon mein kise dekhte ho
hum hain ki ek umar se soye hi nahi.

Aansuonn ko bahot Samjhaya kay tanhayion mein aaya karo
mehfil mein humaara mazaak mat udaaya karo
Is par ansoon tadap ka boley
Itne logon mein bhi aapko tanha paatey hain
isiliye tunhaara saath dene chale atey hain

tum laakh chhupao seenein mein, ehsaas humaari chaahat ka
dil jab bhi tumhaara dhadka hai, awaaz yahan tak aayi hai

Jo taar se nikli hain woh dhun, sab ne suni hai
Jo saaz pe guzri hai woh, kis dil ko pata hai

Khudah se maine ek duva maangi,
Duva mein apni maut maangi,
Phir khudah ne kaha…
Maut to tujhe de doon par,
Usko kya kahoon jisne teri lambi umar maangi

meri qabar par phool charha raha hai koi…
meri qabar par ansoo baha raha hai koi…
aye khuda thori se zindagi aur day…
meri qabar se mayoos ja raha hai koi

AAJ BHI SHAAM KI AANKHEN NAM KYUN HAIN…
HAMEIN TO ARSAA HO GAYA DAASTAANE-GAM SUNAAYE HUE…

na uda yun thhokaron se meri khaak-e-kabr zaalim…
yahi ek rah gayi hai mere pyar ki nishani.

iss tarah likhne mein maahir to hum bhi nahi…
aur phir woh keh jaate hain unko koi gum bhi nahi…
kucch to raaz andar inke bhi chipa hoga..
kahin koi dard hoga andar..tabhi to aasuon ka daayra bana hoga

Unki chahat ko apni mohabbat bana ke dekh
Unki hasi ko apne hoton se muskurakar dekh
Unke ashkon ko apni ankhon se girakar dekh
Unki bechainiyon ke apne dil main basa ker dekh
Ye mohabbat ek hasin tohfa hai ae dost
Kabhi mohabbat ko is tarah bhi nibhakar dekh

PYAAR BOHUT HAI TUM SE JANA,PER EZHAAR NAHI KARTE
MERI CHUP SE YEH NA SAMAJHNA, TUM SE PYAAR NAHI KARTE
APNI AANKHEIN TU HAR LAMHA,TERI RAAH HI TAKTI HEIN
OR TUM PAGAL YEH KEHTE HO HUM INTIZAR NAHI KARTE

Dard ko bhi ab dard hone laga hai
Dard apne zakhmo ko dhone laga hai
Dard ko paaker hum to nahi roye
Dard hame paaker rone laga hai

Main lafzon se kuch bhi izhaar nahi karta
Iska matlab ye nahin ki mai usse pyar nahi karta
Chahata hun mai use aaj bhi
par Uski soch me apna waqt bekar nahi karta
Tamasha na ban jaye kahi mohabbat meri
Isliye apne dard ka izhaar nahi karta
Jo kuch mila hai ussi me khush hun mai
Uske liye khuda se takrar nahi karta
Par… Kuch to baat hai uski fitrat me zalim
Warna ussko chahne ki khata mai baar – baar nahi karta………..

Woh ruthte rahe hum manate rahe,
Unki raahon me palkein bichate rahe,
Unhone kabhi palat ke bhi na dekha,
Hum ankh jhapkane se bhi katrate rahe.

Aansu ko ankhon ki
Dehliz pe laya na karo.
Apne dil ki halat
Kisiko bataya na karo.
Log mutthi bhar namak liye
Ghoom rahe hain
Apne zakhm kisiko
Dikhaya na karo.

India and corrupion

I have been thinking for some time now about writing this blog. A view into the corruption in india. Everybody knows that there is corruption in india and to a major extent. It is something like built into the system. Where-ever you have to interact with government employees to get your work done you have to fill up some unwanted pockets, if you ever want your work done. Forget service, you dont even get anything near that from these people.

Where do i start from is what i am not clear about. Lets start from the top. It is seen in news papers, well to be clear… keeps on coming on and off. Some MP or people in high position in the government caught taking bribes. It is general knowledge that these things come out because certain people in media have not been bribed to keep it down. These news generally disappear from the papers once all connection people have been bribed properly…. thats india darling. Here people dont joing government organizations to serve the country, they join to launder money into their own pockets. God only knows how this country runs and develops with such high levels of corruption.

Well my introduction with corruption happened when i was in college and my folks tried to get me a passport. For verification i had to go to the local police station and present myself. My dad who accompanied me to the police station, gave me a 20 and a 50 telling me to show the 20 first and then give the 50, if the policeman is not convinced by the 20. Well the inspector asked me lots of stupid questions and finally told me directly “Do you think you can get your passport without paying anything over here”. I showed him a 20. And he said “u will be going out of india, earning lots of money. Give us some more.” Well anyways, he was satisfied by a 50.

Since i have been in delhi and driving, i have got a few surprises over here as well. Firstly the “system” states that you cannot purchase a vehicle unless you have a residence proof. Who gives residence/rent proofs to tenants in delhi. If these proofs are given, corresponding taxes will have to be given. So well, i never had a residence proof. Still i managed to purchase 2 bikes. “Thanks to the system”.

Another thing that i came across in delhi is the fact that it is really easy to bribe a traffic cop. They stand at red lights and catch u for almost anything small. Or you may not be carrying all the papers. All you have to do is plead a little and then offer him 50 rs. Only once i had to offer 100 rs. The mentality seems like -> I am down on money today, lets stand on a red light and get some money… Well they also balance their earnings nicely, so you may find 3-5 out of the 50 they have caught being given a ticket and then these people might have to go to the nearby police station to get their licence back which the policemen took.

The common man generally interacts with this type of corruption.

Corruption at high levels was brought into view in “Rang de basanti” in a very nice way. The point is that we will have to change the system, somehow. Where and how to start is the biggest question. We will have to think about this country. Lots of educated and sophesticated people are moving out of this country due to this only.

Lets see what happens. Where we go from here…

Long time no post….

It has been a long time & i have not been able to post any blogs in the mean time…

Its not because i have gone lazy. No no… I have been busy… Well last week was a bad week … loads & loads of work…And i went off with my room-mate “deepak” to my another room-mate “sujith”‘s engagement.

We left delhi on 25th night for bhopal. Since it was already getting hot in delhi, we thought that a t-shirt would do. But it did NOT do. It was terribly cold on the way. And i had to go to the bathroom 4-5 times in the night. Freezing cold…

Also, it was shivratri on 26th, the next day. And mom had asked me to go on a fast that day. It was supposed to be fruit day. So we bought lots of bananas and grapes and oranges (about 1 kg of each).

Reached bhopal around 8 in the morning. Damn cold. Freezing cold. And sujith simply forgot to tell us that it was so cold on the way.

Well anyways, we had breakfast. I ate only bananas and grapes and missed out on the excellent idli & sambar that aunty had made. Always happens whenever i am on a fast….

Went down to the engagement place. Saw the engagement. Well there is nothing in the engagement except 2 people exchanging rings. Again there was good food – traditional south indian style and again i missed out on it 🙁

Later in the evening we went for boating and on a long drive. Boating was boring… Nothing to do except paddle and see water around you… No excitement and loads of time pass. Cost us 40 bucks. The drive was good. Came to know that bhopal is really a very good city with lots of trees and located on a hill.

Had to catch return train at 9 in the night. And we were told “it wont be cold in the night on the way back”. But it was cold. Very cold. So pls remember to take at least a blanket with you whenever you are going to bhopal. Because it is very very cold on the way.

Back to delhi on monday morning. Auto took 80 Rs. Very costly and a cheat. Went to office and have been in and out of meeting since then.

1 week of meetings. Projects being scrapped after they are made. Briefs changing after everything is done and just before launch. The same routine. Same fire-fighting. My normally abnormal life ….

Till i come by again…….