Nitty-witty - nitty-witty.com - ..::CHANGE is INEVITABLE::..
General Information:
Latest News:
xtrabackup_51: not found & no ‘mysqld’ group in MySQL options 27 May 2013 | 10:46 am
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...
Why we need a tester / QA – Software testing 4 Mar 2013 | 12:40 pm
“Why Testing”, “Importance of Software testing”, “Scope of testing”, “How to become a tester”, “Training for software quality assurance / software testing” … Stop there… Above are the topics well...
MySQL variable innodb_flush_method – summarized 10 Jan 2013 | 04:21 pm
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 th...
Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants 17 Dec 2012 | 05:48 pm
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...
MySQL function returns dates of specified day & between date range 13 Sep 2012 | 12:49 pm
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...
Generate random test data for MySQL using routines 5 Jul 2012 | 12:51 pm
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...
Men in Black-3 (MiB-3) – Xtreme Movie Review 26 May 2012 | 06:51 pm
“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...
Load columnar text file into MySQL table 4 May 2012 | 04:21 am
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...
MySQL – Alter table-change datatype of column with foreign key 24 Apr 2012 | 12:08 am
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...
Selenium vs QTP differences and usage-quick reference 18 Mar 2012 | 04:20 am
This article will describe you about QTP vs Selenium point by point in a easy to understand way. In the field of Software Quality Assurance (QA) automation tools, Selenium and...
