MySQL
-
![Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binaries […]](http://kedar.nitty-witty.com/blog/wp-content/themes/arras_1.5.1.2/images/thumbnail.png "xtrabackup_51: not found & no ‘mysqld’ group in MySQL options")
xtrabackup_51: not found & no ‘mysqld’ group in MySQL options
Posted on May 27, 2013 | 1 CommentRecently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binaries […] -
![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 […]](http://kedar.nitty-witty.com/blog/wp-content/uploads/2013/01/innodb_flush_method-115x115.png "MySQL variable innodb_flush_method – summarized")
MySQL variable innodb_flush_method – summarized
Posted on January 10, 2013 | No Commentsinnodb_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 […] -
Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants
Posted on December 17, 2012 | No CommentsEverybody 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 […] -
MySQL function returns dates of specified day & between date range
Posted on September 13, 2012 | 2 CommentsThis 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 […] -
Generate random test data for MySQL using routines
Posted on July 5, 2012 | 6 CommentsAt 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 […] -
Load columnar text file into MySQL table
Posted on May 3, 2012 | No CommentsEver 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 […] -
MySQL – Alter table-change datatype of column with foreign key
Posted on April 23, 2012 | No CommentsSchema 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 […] -
Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY
Posted on January 30, 2012 | 1 CommentMySQL 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 […] -
Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitiviy
Posted on December 6, 2010 | No CommentsDo you ever need to transfer databases between servers? Different OSes? Two common ways of data migration: 1. Create mysqldump and load it. 2. File transfer using SCP. Case Sensitivity […] -
Using LOAD DATA INFILE with Stored Procedure Workaround-MySQL
Posted on November 30, 2010 | 20 CommentsOkay! So here we will use Load Data syntax to load file into MySQL Server in a Stored procedure. Yep! It’s a workaround. Download MySQL UDF: [root@localhost kedar]# wget http://www.mysqludf.org/lib_mysqludf_sys/lib_mysqludf_sys_0.0.3.tar.gz […] -
10 Steps: MySQL Monitoring through Nagios: Install & Configure
Posted on November 18, 2010 | 18 CommentsNagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL […] -
Installing MySQL On Mac OS X (Darwin Kernel)
Posted on October 28, 2010 | 2 CommentsRecently I happen to install MySQL on Mac OS X (Darvin Kernel). Below are the quick 5 steps to accomplish the task. Step 1: Check Mac Version Very first step […] -
MySQL Function to Convert Date To Words
Posted on September 16, 2010 | 3 CommentsRecently I saw a MySQL Stored Function requirement on Experts-Exchange for converting date into some specific words format. You may find MySQL function for date to words conversion online; even […] -
MySQL Stored procedure to Generate-Extract Insert Statement
Posted on May 5, 2010 | 8 CommentsA lot of places I saw people asking for ways to generate Insert statements. We do have GUI Tools which can extract insert statements for us readily. of the time […] -
Steps to Move Copy Rename MySQL Database
Posted on May 4, 2010 | No CommentsMoving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux […]
Misc articles
Other posts
-
Software
JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java
16 Comments -
QA-Testing
Bug / Defect Priority vs Severity Matrix
No Comments -
Personal
What Music means to you?
7 Comments -
Personal
Light Writing or Painting Photography with Sony DSC HX1
No Comments -
Personal
Capturing with Manual Mode – Sony DSC HX1 Photography
9 Comments -
Personal
Mad WWE Fan Destroying Kid With Chokeslam | Don’t try this
No Comments -
Personal
Life At Rest – A few lines for her
1 Comment -
Personal
Kedar and Madhumita Wedding Invitation 25 Dec 2010
2 Comments -
Just for fun
Top 10 Suresh Kalmadi-CWG Jokes-Delhi 2010
No Comments -
Review
A User review-Apple IPhone-4: I
No Comments