-
Popular Posts
- Load Delimited Data (csv, excel) into MySQL Server
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- MySQL Stored procedure – Split Delimited string into Rows
- No More Spool Space Teradata Query Solution
- Working with EditPlus Text Editor-Regular Expression How To
- Selected Oscar Wilde Quotes
- Collection for insulting – one liners
- The Dos Chat – Lan Messenger
- How to echo colored text in linux shell script
- Ganapati Aarti: Sukhkarta Dukhharta – With English Translation | download mp3
-
MySQL Archive
-
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 | 17 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...