About Author: Kedar

Posts by Kedar

MySQL variable innodb_flush_method – summarized

Posted on January 10, 2013 | No Comments
innodb_flush_method variable specifies how InnoDB opens and flushes log and data files. In Innodb optimization, setting the variable innodb_flush_method tweaks the performance most of the times but there are cases...
Continue Reading...
Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants

Posted on December 17, 2012 | No Comments
Everybody knows the criticality of backup. You might have had your database dumped, data directory copied, flat files exported and even config and binary log files backed-up. But did you...
Continue Reading...
MySQL function returns dates of specified day & between date range

Posted on September 13, 2012 | 2 Comments
This mysql stored function will return you all the dates between given dates having specified day. In short if you say: give me all Sundays in this month. I have...
Continue Reading...
Generate random test data for MySQL using routines

Posted on July 5, 2012 | 6 Comments
At times you’ll find yourself responsible for generating test data for newly created tables for testing or sampling purpose. There are tools that will generate random data for you but...
Continue Reading...
Men in Black-3 (MiB-3) – Xtreme Movie Review

Posted on May 26, 2012 | 4 Comments
“I just learned that Agent K has been assassinated by Boris from future, an alien criminal in 1969. I must travel through a time and stop him and save young...
Continue Reading...
Load columnar text file into MySQL table

Posted on May 3, 2012 | No Comments
Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column! Say, your data to be loaded in table...
Continue Reading...
MySQL – Alter table-change datatype of column with foreign key

Posted on April 23, 2012 | No Comments
Schema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved. Below is a short example for altering...
Continue Reading...
Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY

Posted on January 30, 2012 | 1 Comment
MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. This post briefs...
Continue Reading...
Xtreme Movie Review: Agneepath Agneepath Agneepath (2012)

Posted on January 26, 2012 | 5 Comments
Agneepath… Agneepath… Agneepath… Vruksh ho bhale khade, ho ghane ho bade, Ek patra chhanh bhi, mang mat, mang mat, mang mat, Agnipath, Agnipath, Agnipath… Oh yes… This action-thriller will surely...
Continue Reading...
JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java

Posted on November 18, 2011 | 16 Comments
Introducing JaxtrSMS, The world’s first free and open texting app is a revolutionary product from co-founders Sabeer Bhatia & Yogesh Patel. Sending free text messages or free SMS is now...
Continue Reading...

Page 1 of 1212 3 4 5 »10...Last »

Popular Posts

Subscribe:

Enter your email address:
Recent Comments
- email to fax on MySQL master master replication monitor with php code
- Gabriel Scar on What Music means to you?
- nithi on Place to visit Mumbai: Alibaug 1-2 day tour weekend picnic
- Bobby on Collection for insulting – one liners
- Kedar on Load Delimited Data (csv, excel) into MySQL Server

About Author: Kedar

Posts by Kedar

Popular Posts

Subscribe:

Recent Comments