Change Is Inevitable: Recent Episodes
None
AI tools like ChatGPT, GROK, Meta and Gemini are taking off, and as parents, it’s easy to feel the pressure to keep our kids up to speed. The message out…
The post AI tools – technology and kids first appeared on Change Is Inevitable.
In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at…
The post Podcast: Duplicate Indexes in MySQL first appeared on Change Is Inevitable.
Hello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand…
The post MySQL Podcast – Practical Learning & Training first appeared on Change Is Inevitable.
In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a…
The post MySQL Change Buffer – What When and FAQ first appeared on Change Is Inevitable.
Interpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome. In this blog, we’ll explore the significance of pt-upgrade return codes and how…
The post Understanding Return Codes of pt-upgrade: A quick guide first appeared on Change Is Inevitable.
If you’ve encountered the “Encryption can’t find master key” error while starting MySQL, you’re likely facing issues with the keyring plugin. I recently faced a similar issue on my server,…
The post Troubleshooting MySQL: Encryption can’t find Master Key first appeared on Change Is Inevitable.
These days MySQL consultants around me are busy assisting with MySQL 8 upgrades for those who couldn’t board the train before EoL.I was recently involved in one of the MySQL…
The post MySQL 8 upgrade may fail using checkForServerUpgrade first appeared on Change Is Inevitable.
Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.
The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable.
I encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench. In this blog I’ll share my experience, reveal the fix, and help…
The post MySQL Benchmarking and error in my_thread_global_end() first appeared on Change Is Inevitable.
MySQL 8 is around us for 5 years now. I believe you’re surely considering an upgrade. But if you’re on AWS and still on an older version of MySQL, this…
The post How to save money in AWS RDS – Upgrade to MySQL 8 first appeared on Change Is Inevitable.
In this blog I share how MySQL binary logs get their unique numbers after noting my observations with MySQL binary logs sequencing. Recently I noted an odd binary log sequencing…
The post How MySQL Binary Log Gets Its Number first appeared on Change Is Inevitable.
Recently I noted a strange MySQL replication error in a Percona XtraDB Cluster (PXC) node replicating from a standard MySQL instance. “Node has dropped from cluster”. This is a quick blog…
The post Node has dropped from cluster error in Galera Cluster first appeared on Change Is Inevitable.
The year 2023 surely was a successful year in MySQL blogging. I managed to publish 24 MySQL blogs in total both personal and Percona blog. This post is a reflection…
The post A year in MySQL Blogging – top blogs, summary and review first appeared on Change Is Inevitable.
The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…
The post How to filter MySQL slow queries using pt-query-digest first appeared on Change Is Inevitable.
Welcome to the ultimate guide for MySQL issues debugging — your comprehensive MySQL checklist for tackling MySQL database environment challenges. This checklist for MySQL debugging is as useful to a…
The post What do you need to debug MySQL issues – a checklist first appeared on Change Is Inevitable.
This blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30. This will save you from performance bottlenecks due to tables without Primary Key. If…
The post How to get MySQL Primary Keys in one minute first appeared on Change Is Inevitable.
Do you know what lies inside your MySQL Data Directory? This article is a quick guide about the files stored inside MySQL data directory. Data managed by the MySQL server…
The post Quick Look – MySQL Data Directory Files first appeared on Change Is Inevitable.
Are you planning an upgrade for your Percona XtraDB Cluster (PXC)? Upgrading to PXC 8.0 can be a smooth process, but sometimes challenges arise that require careful troubleshooting. In this…
The post How to Percona XtraDB Cluster 8.0 Upgrade issues first appeared on Change Is Inevitable.
The post How to Percona XtraDB Cluster 8.0 Upgrade issues appeared first on Change Is Inevitable.
In this blog post, I want to share my experience and learning after challenging myself on my MySQL blog writing spree in recent past. I invite you to comment on…
The post One MySQL blog a day challenge first appeared on Change Is Inevitable.
This blog is about a very odd case of a Federated table error causing unable reach the remote MySQL server and causing to error. I’ll share the approach I tool…
The post How to fix MySQL federated table error first appeared on Change Is Inevitable.
“How can we replicate without using binary logs” just a thought popped up in my brain during a casual discussion. This blog post is a brain dump of the possible…
The post How to replicate without binary logs in MySQL first appeared on Change Is Inevitable.
In a MySQL database, fragmentation can occur over time as data is inserted, updated, and deleted. Fragmentation refers to the inefficient storage and organization of data within database objects, such…
The post MySQL fragmentation and how to defragment first appeared on Change Is Inevitable.
MySQL, a widely-used database management system, may show the warning “[Warning] Connection attributes of length 571 were truncated” in its error log. In this blog, we will explore the reasons…
The post How to Fix Connection attributes of length xxx were truncated first appeared on Change Is Inevitable.
I was attempting to download the MySQL slow query logs to perform a slow query review. In this blog we will explore the issue I faced while downloading the slow…
The post How to overcome Throttling and Rate Exceeded Errors in DownloadDBLogFilePortion first appeared on Change Is Inevitable.
Bugs in database management systems can be a nightmare for administrators and developers. In my recent experiments, I discovered a Signal 11 bug in multiple versions of MariaDB, resulting in…
The post How to meet Signal 11 bug in MariaDB first appeared on Change Is Inevitable.
This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on Ubuntu. The post includes instructions for installation using…
The post How To Install specific version of MySQL 8 on Ubuntu first appeared on Change Is Inevitable.
Setting up replication in MySQL is a common DBA task. The replication could be traditional binary log replication or based on GTID replication. This blog is a work log and…
The post How to MySQL Replication setup, Master GTID & SSL Encryption first appeared on Change Is Inevitable.
This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS. The post includes instructions for installation using…
The post Install exact version of Percona Server for MySQL on CentOS first appeared on Change Is Inevitable.
A friend needed to analyze slow queries and for that he decides to use pt-query-digest tool. Though he got stuck at exporting slow queries from slow logs in RDS for…
The post MySQL Slow query log export and review in RDS first appeared on Change Is Inevitable.
In this blog, I will share the steps I took to debug an error ‘ERROR 1030 (HY000): Got error 168 – ‘Unknown (generic) error from engine’ from storage engine’ while…
The post 1030 Unknown generic error from engine in MySQL first appeared on Change Is Inevitable.
A friend’s application started failing with MySQL causing error about timestamp columns and it needs urgent fixing from the database side. A timestamp column was not accepting the null values and they were sort of down. In this blog we will learn how MySQL is telling you, to follow what you say. When you define […]
The post MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp first appeared on Change Is Inevitable.
In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a feedback on my previous blog about MySQL Interview with ChatGPT. Here is a video recording of the steps described below for restoring single table from xtrabackup. Create a compressed MySQL backup using Xtrabackup xtrabackup --backup --compress --compress-threads=8 --target-dir=/root/backupdir Output in backup directory [root@ip-172-31-83-17 ~]# ls -lhtr /root/backupdirtotal 3.1M-rw-r-----. 1 root root 164K Dec 14 17:11 ibdata1.qpdrwxr-x---. 2 root root 31 Dec 14 17:11 sysdrwxr-x---. 2 root root 23 Dec 14...
The post Restore single MySQL table from Xtrabackup (video demo) first appeared on ..::CHANGE is INEVITABLE::...
Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant position. This blog post is a result of that interview, during which I asked ChatGPT a range of questions related to MySQL and other relevant topics. As I expected, the interview candidate performed well on the theoretical questions, but some of their answers to the practical questions were incorrect and could potentially cause significant damage to a database. This blog post only includes a portion of the full interview conversation....
The post MySQL Interview – ChatGPT is not your DBA first appeared on ..::CHANGE is INEVITABLE::...
This ProxySQL post is sourced from an error I faced recently handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE(): [ERROR] ProxySQL Error: Access denied for user ProxySQL has become one of the popular choice as the “proxy” for MySQL databases. This post is tipping you off for debugging connectivity issue and fixtures around it for a specific use-case. ProxySQL Connectivity Ofcourse while […]
The post Can not connect to ProxySQL: reasons and fixtures first appeared on ..::CHANGE is INEVITABLE::...
In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to […]
The post Providing Friday Proofs to MySQL Consultants first appeared on ..::CHANGE is INEVITABLE::...
MySQL is one of the top used database system and with highly active community. Though without proper configuration you may not squeeze the most out of it.This will be a talk about the low hanging fruits to get the best outcome preferably in a short time or with small efforts. This will include configuration, performance […]
The post The Low Hanging Fruits of MySQL – Percona Live Community 2022 first appeared on ..::CHANGE is INEVITABLE::...
Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again, it will work. That’s it, that’s the blog. Should you choose to spend some more time, go ahead. A new MySQL 5.7 GTID replication chain […]
The post 2 many dots can break your replication only once first appeared on ..::CHANGE is INEVITABLE::...
This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux. We will set-up MySQL backup using mysqldump and automate it with Holland backup framework on Ubuntu. Towards the end of the post, you have the steps to be executed in a single block which includes steps […]
The post MySQL Backup setup, automation using Holland, mysqldump on Ubuntu first appeared on ..::CHANGE is INEVITABLE::...
Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In this post, we’ll discuss our encounter with binlog_error_action and likely bad default. The incident started with an alert from our monitoring platform that a check […]
The post Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR? first appeared on ..::CHANGE is INEVITABLE::...
This post covers Proxysql start up process, Layers and configuration file.
The post ProxySQL Configuration File & Startup Process Explained first appeared on ..::CHANGE is INEVITABLE::...
This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The backup shell script works as follows: – The script takes backup using mysqldump and compresses it. – Upon success, it will attempt to ship the […]
The post mysql database backup shell script with status email first appeared on ..::CHANGE is INEVITABLE::...
दुर्गे दुर्घट भारी – श्री देवीची आरती Durge Durghat Bhari दुर्गे दुर्घट भारी तुजविण संसारी ।अनाथनाथे अंबे करुणा विस्तारी ॥वारी वारीं जन्ममरणाते वारी ।हारी पडलो आता संकट नीवारी ॥ १ ॥ जय देवी जय देवी महिषासुरमथनी ।सुरवरईश्वरवरदे तारक संजीवनी ॥ धृ. ॥ त्रिभुवनी भुवनी पाहतां तुज ऐसे नाही ।चारी श्रमले परंतु न बोलावे काहीं ॥साही […]
The post दुर्गे दुर्घट भारी – श्री देवीची आरती | Aarti Durge Durghat Bhari | Marathi first appeared on ..::CHANGE is INEVITABLE::...
This blog post gives an introduction to resource groups in MySQL 8 and dynamical allocation to threads, as well as a related bug report.
The post MySQL 8 Resource Group – introduction and dynamic allocation first appeared on ..::CHANGE is INEVITABLE::...
In this post we will see a case study of a Galera Cluster migration to AWS Aurora and quick solution to the replication issue. A friend received an error in a Master-Master replication as follows: Could not execute Write_rows event on table _database._table; Duplicate entry '65eJ8RmzASppBuQD2Iz73AAy8gPKIEmP-2018-08-03 08:30:03' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; […]
The post Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY first appeared on ..::CHANGE is INEVITABLE::...
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.
The post Restore A Table / Database From Full Backup – Yet Another Way first appeared on ..::CHANGE is INEVITABLE::...
Today lets talk a little about converting a MySQL table to CSV (Excel). My friend was looking to export MySQL to Excel, I saw couple of questions for export MySQL tables to CSV on forums. Since I saw the question often, I thought of writing out all the ways I can think of for exporting […]
The post Export MySQL database table to CSV (delimited / Excel) file first appeared on ..::CHANGE is INEVITABLE::...
I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator detected the issue and what he did to resolve it. A day in MySQL Database Consultant’s day was taking its shape while a friend called […]
The post A tale of Corrupt InnoDB table, MySQL crash & recovery first appeared on ..::CHANGE is INEVITABLE::...
In this post we will see how to pause (suspend) and start a linux process using signals (SIGTSTP and SIGCONT) via kill command.
The post Linux shell script: Pause (Suspend) a process with kill signals first appeared on ..::CHANGE is INEVITABLE::...
In this post we will understand how to decode Seibel Audit Trail using PLSQL. Siebel Audit Trail is feature in Siebel CRM which allows customer to track changes to important UI fields. Though it is very useful feature, the changes are stored in encoded text in DB. We are aiming to decode this complex data […]
The post Decoding Siebel Audit Trail with PLSQL first appeared on ..::CHANGE is INEVITABLE::...
Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB )
The post Reset root password on Galera Cluster (Percona or MariaDB) first appeared on ..::CHANGE is INEVITABLE::...
This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics. (root@localhost) [test]>insert into app values (1); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Little background: We needed to work on migrating the […]
The post MySQL to Galera Cluster Migration, Deadlock, Back to basics first appeared on ..::CHANGE is INEVITABLE::...
Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.
The post Restoring MySQL Database from xtrabackup – facepalm moments first appeared on ..::CHANGE is INEVITABLE::...
This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads
The post corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads” first appeared on ..::CHANGE is INEVITABLE::...
This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync
The post Fixing inconsistency on MySQL Slave of Galera Cluster first appeared on ..::CHANGE is INEVITABLE::...
This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.
The post Setting-up second mysql instance & replication on Linux in 10 steps first appeared on ..::CHANGE is INEVITABLE::...
This post discuss the pt-table-checksum & error "Waiting to check replicas for differences: 0% 00:00 remain" with a use-case and solution.
The post pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain first appeared on ..::CHANGE is INEVITABLE::...
We already have seen two articles for setting up MySQL Monitoring with Nagios and Percona Monitoring Tools for Nagios. Those posts covers configuration of nagios on single instance. Though following questions came to me: Do you need to setup Nagios again on all servers that we want to monitor? How do you add another MySQL […]
The post How to Add Remote MySQL Server to Nagios Monitoring first appeared on ..::CHANGE is INEVITABLE::...
MySQL ERROR 1018 (HY000): Can't read dir of './sakila/' (errno: 13 - Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it's fix for SELinux.
The post MySQL 1018 (HY000): Can’t read dir errno: 13 – Permission denied first appeared on ..::CHANGE is INEVITABLE::...
It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should see suggestions for: Monitoring Holland MySQL Backup Monitoring mysqldump backups Monitoring Xtrabackup using log Monitoring Backups using Nagios Usually we can have our backup script […]
The post Monitoring MySQL Database Backups first appeared on ..::CHANGE is INEVITABLE::...
Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log of Nagios and Percona Monitoring Plugins setup steps here for some-one who’s looking for the same! Install Nagios on Ubuntu – steps: (skip to Percona […]
The post Install Percona Monitoring Tools for Nagios – MySQL Plugins first appeared on ..::CHANGE is INEVITABLE::...
UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DIR for changing the database directory and file permissions from it's default to what we need.
The post UMASK & UMASK_DIR – changing default MySQL file dir permissions first appeared on ..::CHANGE is INEVITABLE::...
Often we come across requirement for Siebel to integrate with external applications. Siebel provides various ways to integrate through EAI (Enterprise Application Integration) like EIM, Prebuilt connectors, various queues like MSMQ, JMS, WebSphere MQ. Also Web service based integration using SOAP. Siebel also supports RESTful based integration using Fusion Middleware. One important feature of Siebel […]
The post XML to JSON converter in Siebel first appeared on ..::CHANGE is INEVITABLE::...
Setting up a database backup is a primary task for database administrators and we see perl and shell scripts wrapped around few of the backup-tools in practice. With right tools things can look easy and today we shall look into one of that! MySQL Database backup can be done with mysqldump, mysqlhotbackup, xtrabackup, lvm / […]
The post Setup and configure MySQL backup using Holland and Xtrabackup first appeared on ..::CHANGE is INEVITABLE::...
FATAL: Cannot connect to MySQL server on 'localhost': Cacti Error - Solution to the issue while setting-up.
The post Cannot connect to MySQL server on ‘localhost’: Cacti Error first appeared on ..::CHANGE is INEVITABLE::...
This post will answer how to extract database, tables etc from mysqldumpsplitter utility.
The post How-to extract from mysqldump | mysql-dump-splitter recipes first appeared on ..::CHANGE is INEVITABLE::...
Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.
The post MySQL:The user specified as a definer does not exist (error 1449)-Solutions first appeared on ..::CHANGE is INEVITABLE::...
10+ useful code snippets of Linux shell scripts for how-to color, sendmail, log, change dir, parse parameters, loop, configuration file, switch..case and more.
The post 10 useful shell script code snippets | Linux first appeared on ..::CHANGE is INEVITABLE::...
In this post I will share a recovery scenario of a MySQL database restore from the binary logs. Recently someone accidentally dropped an important MySQL database and the backup was not present! As we know the the binary log contains DMLs to table data and that’s where our hope lies. Luckily the binary log retention […]
The post Restore / Recover dropped MySQL database from binary logs first appeared on ..::CHANGE is INEVITABLE::...
The MySQL grant syntax allows you to specify dynamic database names using the wildcard characters. This article explains the usecase of dynamic section of mysql grants.
The post MySQL grant syntax & dynamic database using wildcards first appeared on ..::CHANGE is INEVITABLE::...
A Percona Xtradb (Galera) Cluster node may fail to join it due to many possible mistakes causing SST to fail. It could be a configuration item or purely setup requirement. In this article we will be troubleshooting step by step the SST issues faced.
The post Debugging Percona Xtradb (Galera) Cluster node startup / SST errors first appeared on ..::CHANGE is INEVITABLE::...
Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.
The post MariaDB slave restore using GTID & xtrabackup bug first appeared on ..::CHANGE is INEVITABLE::...
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 and ran into issues following standard commands (assuming no changes): To prepare the backup I used apply-log as follows: $] innobackupex-1.5.1 --defaults-file=/usr/local/mysql/data/backup-my.cnf --apply-log /usr/local/mysql/data --ibbackup […]
The post xtrabackup_51: not found & no ‘mysqld’ group in MySQL options first appeared on ..::CHANGE is INEVITABLE::...
“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 discussed and explained at a lot many places and a lot many times, but this is not what we’re here for. I happened to face […]
The post Why we need a tester / QA – Software testing first appeared on ..::CHANGE is INEVITABLE::...
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 of otherwise though. If innodb_flush_method is set to O_DIRECT it’d avoid double buffering and reduce swap pressure and helps improving performance. innodb_flush_method has been covered […]
The post MySQL variable innodb_flush_method – summarized first appeared on ..::CHANGE is INEVITABLE::...
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 backup your MySQL user privileges? One can easily forget to backup the user privileges but it is much easier to do and you should backup […]
The post Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants first appeared on ..::CHANGE is INEVITABLE::...
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 following for you: mysql> select Give_Me_Dates_Days(1,'2012-09-01','2012-10-01') as All_Sundays; +--------------------------------------------------------+ | All_Sundays | +--------------------------------------------------------+ | 2012-09-02,2012-09-09,2012-09-16,2012-09-23,2012-09-30 | +--------------------------------------------------------+ The function parameters are as follows: Give_Me_Dates_Days(DAY_IDENTIFIER,START_DATE,END_DATE) Sunday […]
The post MySQL function returns dates of specified day & between date range first appeared on ..::CHANGE is INEVITABLE::...
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 they’re not free. At-times you’ll write scripts to generate data but those will be table specific. I hate generating dummy data, yes I do and […]
The post Generate random test data for MySQL using routines first appeared on ..::CHANGE is INEVITABLE::...
“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 Agent K. And I have only 24 hours to do the stuff and return home safely!! ” O Yeah!! Will Smith Just told me the […]
The post Men in Black-3 (MiB-3) – Xtreme Movie Review first appeared on ..::CHANGE is INEVITABLE::...
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 looks something like this: Company1 Street Name City, MyState 8582 (999)999-999 another_Company Another Street 2 New City, NWSTATE 8582 (111)111-1111 So how’d you go about […]
The post Load columnar text file into MySQL table first appeared on ..::CHANGE is INEVITABLE::...
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 tables having foreign key constraints. SQL for tables used in example: create database temp;use temp; drop table if exists city; drop table if exists country; […]
The post MySQL – Alter table-change datatype of column with foreign key first appeared on ..::CHANGE is INEVITABLE::...
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 QuickTest Professional (QTP) are often compared for their features, usability usecases and differences. Whether Selenium or QTP is a better automation tool or tool of […]
The post Selenium vs QTP differences and usage-quick reference first appeared on ..::CHANGE is INEVITABLE::...
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 you about security aspects of stored routines by means of example. By the definition of a Stored Routine, – DEFINER clause specifies the creator of […]
The post Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY first appeared on ..::CHANGE is INEVITABLE::...
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 make you feel the word “Agneepath”. The movie, as promoted, has lived on REVENGE and lived upto the mark. Sanjay Dutt as ‘Kancha’, Hritik Roshan […]
The post Xtreme Movie Review: Agneepath Agneepath Agneepath (2012) first appeared on ..::CHANGE is INEVITABLE::...
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 expanded Globally thanks to JaxtrSMS. JaxtrSMS enables you to cross the horizons of communication. JaxtrSMS gives power to you to reach anyone anywhere around the […]
The post JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java first appeared on ..::CHANGE is INEVITABLE::...
What is a software quality and what attributes are used to measure it? A very common question you might have faced during Testing or QA Interviews. Many of the Software Testers or Software Quality Analyst don’t know about the attributes at all. This post would help you understand the attributes in simple and sober words. […]
The post Software Quality Attributes-Parameters Explained first appeared on ..::CHANGE is INEVITABLE::...
In Software Testing, deciding how important the defect is and how soon the defect should be fixed is as important as finding a defect! This depends on how you actually place the defect into Priority-Severity matrix. I have come across a lot many test engineers, who get confused between priority and severity of a defect. […]
The post Bug / Defect Priority vs Severity Matrix first appeared on ..::CHANGE is INEVITABLE::...
What music mean to you? Well, surealy this is one of those questions for which you know the answer but you just can’t describe satisfactorily. So, here is my try. I’m a music lover n’ my friends know that. I’m not a great muzician or a singer but I have quite a good taste. I […]
The post What Music mean to you? first appeared on ..::CHANGE is INEVITABLE::...
Dhing chika, Dhing chika, Dhing chika… This is what I got from singham, a ringtone… I hated Dabangg even more when it got National Award! Don’t want to continue it in a post dedicated to Singham anyways! if ( you like dabangg) { Just go and enjoy Singham! This is pretty much mindless fun & […]
The post Extreme Movie Review: Singham (2011) Ajay Devgn first appeared on ..::CHANGE is INEVITABLE::...
It always feels good to have a capable camera and it feels even better to explore new capacities of my Sony DSC-HX1 🙂 After entering into manual mode and understanding a bit of photography basics, I turned exploring something really creative and exciting in photography. Light Writing… quite self explanatory, writing with the light source […]
The post Light Writing or Painting Photography with Sony DSC HX1 first appeared on ..::CHANGE is INEVITABLE::...
“Auto mode is for kids and manual is for photographers” Well, One must take out time to learn & for those owning camera, this is definitly a must do thing. I’ve started capturing through Manual modes and I’m pretty much amongst those beginners & learners. Charity and photography begins at home (it’s kitchen in my […]
The post Capturing with Manual Mode – Sony DSC HX1 Photography first appeared on ..::CHANGE is INEVITABLE::...
And finally, Rohan Sippy’s “Dum Maaro Dum” ended the series of poor movies in 2011. The best parts of the movie are Direction & Music, alongwith the good mixture of new characters and cool set of dialogues / one-liners. The way of story-telling and great back-ground music (by Midival Punditz) have added to it a […]
The post Extreme Movie Review – Dum Maro Dum (2011) first appeared on ..::CHANGE is INEVITABLE::...
Sundarvan – A Nature Discovery Centre is like a small zoo located in the heart of the city Ahmedabad. I heard about and decided to appear personally. How to reach Sundarvan: Located at very odd place, I mean on a regular Satellite road you will never even notice anything like “Sundarvan” exists. Things to do: […]
The post Weekend at Nature Discovery Centre – Sundarvan, Ahmedabad first appeared on ..::CHANGE is INEVITABLE::...
Yeh Saali Zindagi… Hmm… So how do you feel if I start my review from the time when the director decided to make ‘Yeh Saali Zindagi’!! That’s what happened with me; it takes too long to start the “actual”: Yeh Saali Zindagi & till that time I had lost my interest. The movie is a […]
The post Extreme Movie Review-Yeh Saali Zindagi (2011) first appeared on ..::CHANGE is INEVITABLE::...
There are a lot of speculations around WWE and its effect on kids. I personally love watching the Stars and their action and dedication towards the World Wrestling Entertainment! Though many people out there do oppose the game. They say, it increases the violence in people and fan following. The show do warn every-time: ‘Don’t […]
The post Mad WWE Fan Destroying Kid With Chokeslam | Don’t try this first appeared on ..::CHANGE is INEVITABLE::...
This post is dedicated to blog performance and statistics by analytical numbers. So, how did the blog perform in 2010? Below is the simple statistics to explain the blog performance throughout the year. Where did the readers came from? Country or Territory Visits United States 10,950 India 10,166 United Kingdom 2,628 Canada 1,395 Germany 1,286 […]
The post Kedar’s Blog Performance Statistics-Year 2010 first appeared on ..::CHANGE is INEVITABLE::...
Do 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 and Issue: Yes, that can create big issues when you have to deal with systems having different case sensitivity. E.g. on linux you can create […]
The post Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitiviy first appeared on ..::CHANGE is INEVITABLE::...
:Life at rest: Oh my Dear, insomniac for ur sleep, u’r awesome when its deep, pale skin, nighty hair, mighty life and u’r so near… warm breath, and ur charm, makes me wait, till u wake, while u sleep, lemme gaze, beauty like u and i await…. sun wont rise, birdz wont sing, oh dear, […]
The post Life At Rest – A few lines for her first appeared on ..::CHANGE is INEVITABLE::...
Dear God, You’re almighty and kind. You know everything about me and us. Still I’m writing this formally to you. With blessings of our parents we’ve decided to “join” each other forever on 25th December 2010. (You know who) Please execute below commands on our wedding day 🙂 GRANT ALL PRIVILEGES ON madhumita.* TO 'kedar'@'%' […]
The post Kedar and Madhumita Wedding Invitation 25 Dec 2010 first appeared on ..::CHANGE is INEVITABLE::...
Okay! 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 [refer: http://www.mysqludf.org/] Extract and Install: [root@localhost kedar]# tar -xzvf lib_mysqludf_sys_0.0.3.tar.gz install.sh lib_mysqludf_sys.c lib_mysqludf_sys.html lib_mysqludf_sys.so lib_mysqludf_sys.sql Makefile [root@localhost kedar]# sh install.sh Compiling the MySQL UDF gcc […]
The post Using LOAD DATA INFILE with Stored Procedure Workaround-MySQL first appeared on ..::CHANGE is INEVITABLE::...
Nagios 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 Database Server. Let’s unleash the power step by step: Installing and configuring Nagios Step-1 : Install required stuff: yum install httpd yum install gcc yum […]
The post 10 Steps: MySQL Monitoring through Nagios: Install & Configure first appeared on ..::CHANGE is INEVITABLE::...
If you are a Stock Market Addict and a Techie; normally working on Linux(es); this post will interest you as you still can get quote of your stock on your Linux prompt. Consider, we have Google Finance url for Tata Consultancy Services Stock: http://www.google.com/finance?q=NSE:TCS So, how do you get above stock price while you’re on […]
The post How to Get Stock Quote on Linux using Google ,Curl, Grep, Awk first appeared on ..::CHANGE is INEVITABLE::...
Recently 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 is to verify the Mac OS X’s current version to decide MySQL Installation file to be downloaded. For example for Mac version: 10.4 you should […]
The post Installing MySQL On Mac OS X (Darwin Kernel) first appeared on ..::CHANGE is INEVITABLE::...
A lot of SMSes and Jokes I’ve received and read online about Mr. Suresh Kalmadi and CWG. Well, it’s quite a bit serious matter but such a huge mess gave us chance to make fun of CWG. Well as far as I see Mr. Kalmadi’s work profile I really doubt someone who has worked in […]
The post Top 10 Suresh Kalmadi-CWG Jokes-Delhi 2010 first appeared on ..::CHANGE is INEVITABLE::...
Friends, I saw movie dabangg and this is what I think about it. Dabangg…It’s a bad movie… I don’t understand how come it became so “popular”…It’s typical South Indian styled mindless, over-‘hero centric’, senseless and pitiful storied movie… I’ll prefer to watch a South Indian movie than this. I didn’t even like action!! Damn… And […]
The post Extreme Movie Review n Poll – Salman's Dabangg 2010 first appeared on ..::CHANGE is INEVITABLE::...
Recently 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 udfs might be ready, but I decided to write my own. I wrote this simple function mainly based on SELECT CASE to convert dates in […]
The post MySQL Function to Convert Date To Words first appeared on ..::CHANGE is INEVITABLE::...
I have already written a post for my list of must have softwares. I’ve now decided to share how I use my machine. In this post I will post my usage and maintenance methods for personal computer. I hope this post will help you in getting great usage experience after following it. I’m a PC […]
The post Computer usage and maintenance-my 10 practices first appeared on ..::CHANGE is INEVITABLE::...
Yesterday I was traveling from Ahmedabad to Vadodara and luckily I carried my DSC HX1 with me. I was even lucky that I was incapable of driving and was on front seat. No doubt my hand and car vibrations helped a bit in getting those designs. 🙂 I decided experiment with shutter speed for my […]
The post Shutter Speed & F-stop: Sony DSC HX1 Photography first appeared on ..::CHANGE is INEVITABLE::...
As soon as I got a pc I start looking at Configuration, Connectivity [;)] and Installations. As for humans Food, Air, Water are basic necessities; for my computer I always make sure I do have perticular softwares installed. In this post I will list my 7 most used free softwares for general usage. WordWeb: Of-course […]
The post My list of must have free softwares-2010 first appeared on ..::CHANGE is INEVITABLE::...
I have a Mathe-crap-matical friend. Who keeps digging into graves of dead formulas and equations and all possible Math related stuffs. Since I started understanding Mathematics (that it’s not my cup of tea), I tried to stay away from it. Now, that enthu creature mailed me his requirement. He says he “eat mathematics”, I prefer […]
The post My worst mathematical program in perl first appeared on ..::CHANGE is INEVITABLE::...
Recently India got it’s own Currency Symbol for Indian Rupee! But do we know, we also got our own “Made in India” browser on 15th July 2010?!! EPIC – Yes it’s the name of the new browser, the first Indian web browser, launched by Hidden Reflex, Banglore. Epic is creation of Indian Engineers using the […]
The post EPIC-First Indian Web browser-Free with Antivirus first appeared on ..::CHANGE is INEVITABLE::...
I hate Luv Stories. No! it’s not a spell mistake, they have intentionally made it “LUV” as they love LOVE stories. Since I heard the name, I started hating the movie and thinking about how ‘d one say: I hate I hate love stories OR I love I hate love stories… 🙂 I felt ‘I […]
The post Extreme Movie Review: I hate Luv Stories-2010 first appeared on ..::CHANGE is INEVITABLE::...
Techie nerds, geeks or even company reviews are quite interesting and have their importance but a “User Review” is something which you won’t like to ignore; you should not. IPhone-4 was a buzz word since it’s release and I decided to provide a user review for IPhone-4. So here you go: iPhone4, Worlds Thinnest Smart […]
The post A User review-Apple IPhone-4: I first appeared on ..::CHANGE is INEVITABLE::...
I always admire Maniratnam … Never doubt his movies… A R Raheman is a Gem – whole world admits… I simply love his music. No one can doubt Gulzar’s capabilities and his poetry, I’m a fan… But seems like this time the “Grahas” of these 3 great Indian personalities was not good this time… About […]
The post Extreme Movie Review-Raavan 2010-Bonus Poster first appeared on ..::CHANGE is INEVITABLE::...
As soon as Prince of Persia name appears I recall my colleage days of P.O.P. 3D the game of Late 2000 Era. I used to play em’ a lot. Later came the Sands of Time and the Warrior Within, two more games in the series of Prince Of Persia. I used to love them playing. […]
The post Extreme Movie Review – Prince of Persia (2010) first appeared on ..::CHANGE is INEVITABLE::...
After a lot of ifs, buts, confusions and questions I’ve bought Sony’s DSC HX1 . Well I’m not that good at photography but yes I like that. Here I will post my some of the photography with new DSC HX1. I’d request your comments and suggestion to improve it. Mind well, the pictures captured and uploaded here […]
The post My Sony DSC HX1 Performance, Learning and Photos – I first appeared on ..::CHANGE is INEVITABLE::...
Prologue: Long back there were golden days of post graduation in the “great” DDIT (Now Dharamsinh Desai University), Nadiad. Assignments, termwork and journals or everything similar was in demand – I attempted a java code as my termwork on Monday, October 03, 2005. [That’s created date of .java file, I don’t remember anything.] A “variable […]
The post Java termwork connect Access Database and operations first appeared on ..::CHANGE is INEVITABLE::...
Housefull!! The best movie, the best comedy, the best dialogues, the best jokes… So in this first line of Housefull review “I’m a joking” Actually it’s totally reverse. If you’ve got little sense of humor, you will not like this at all – just donot go for this movie. Story is about Akshay “the Panauti” […]
The post Extreme Movie Review: Housefull 2010 first appeared on ..::CHANGE is INEVITABLE::...
A 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 I choose the MySQLDump way to generate insert statements. mysqldump -uroot -ppassword –complete-insert –no-create-info DATABASE TABLENAME > TABLENAME.sql But mind is very unstable and hungry, […]
The post MySQL Stored procedure to Generate-Extract Insert Statement first appeared on ..::CHANGE is INEVITABLE::...
In the huge task of selecting a digital camera, one more day has passed. I’m still not decided. Yes, I have now felt an extreme need of purchasing a digital camera and I’m trying hard to wrap-up this chapter by end of this week. I started getting idea from Ashish as he knows much more […]
The post My Digital confusion for Camera first appeared on ..::CHANGE is INEVITABLE::...
Moving, 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 Machine: A. Use RENAME DATABASE Command [MySQL 5.1]. RENAME DATABASE db_name TO new_db_name; B. mysql -uroot -pPASSWORD -e “drop database if exists NEW-DB-NAME; create database […]
The post Steps to Move Copy Rename MySQL Database first appeared on ..::CHANGE is INEVITABLE::...
When have you lastly visited Google Maps? Google have now Introduced Google Earth on Google Maps. Now using Browser you can see 3D maps online; they named it “Earth View”. Till now we were just looking at flat terrains but after installing the Earth View Plugin, you will be able to get actual 3D view. […]
The post Google:Earth View on Google maps first appeared on ..::CHANGE is INEVITABLE::...
The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string. I have already written the basic how to follow that considering additional cases. A lot of questions I have seen for loading separated data to MySQL, […]
The post MySQL Load Data Infile Syntax Generator Tool Download first appeared on ..::CHANGE is INEVITABLE::...
I’m hearing a lot of “NoSQL” these days. To really understand how (and) does it works, I decided to give a try on MongoDB. MongoDB (humongous) is an open source, scalable, high-performance, schema-free, document-oriented database written in the C++ programming language. MongoDB is not a Relational Database Management System. The database manages collections of JSON […]
The post In the world of NoSQL-Hands on Mongodb-1 first appeared on ..::CHANGE is INEVITABLE::...
Think about one day tour and a lot of fun in Mumbai? Alibaug is a good choice. It a normal budget, full day, full fun and great place. Reach Gateway Of India. [20 Mins walk / 5 Mins (Rs. 15) Taxi from Chatrapati Shivaji Terminus / Victoria Terminus] Book a PNP / Ajanta Jetty from booking stalls […]
The post Place to visit Mumbai: Alibaug 1-2 day tour weekend picnic first appeared on ..::CHANGE is INEVITABLE::...
This post covers the basic information of files that MySQL Server uses / creates for various tasks. my.cnf : It is the main configuration file for MySQL. You may find it under base directory in windows or under /etc/. .sock : mysqld creates a socket for programs to connect to and notes in this file. […]
The post MySQL related file types and basic information first appeared on ..::CHANGE is INEVITABLE::...
Earth Hour is a global event organized by WWF (World Wide Fund for Nature). Earth Hour held on the last Saturday of March annually, asking households and businesses to turn off their non-essential lights and other electrical appliances for one hour to raise awareness towards the need to take action on climate change. In 2007, […]
The post Earth Hour March 27 2010-India-Switch off lights for future first appeared on ..::CHANGE is INEVITABLE::...
Editplus is a lot better than the regular text editor, Notepad. From all it’s features I like RegExp Support the most, and than comes the block select feature. Here are the quick lines to carry out regular tasks using regular expression in Editplus. It’s kinda downloadable cheetsheet list. Remove all empty lines: Find: “^\n” (Ignore […]
The post Working with EditPlus Text Editor-Regular Expression How To first appeared on ..::CHANGE is INEVITABLE::...
This post has two batch scripts: 1. Batch script to rename files with zero padded number series-prefix 2. Batch script to remove prefix of perticular length 1. Batch script to rename files with zero padded number series-prefix This script will accept file-type to be searched and lenght of zero-padded prefix to be attached. Usage: RenZeroPad.bat […]
The post batch script to add remove prefix zero pad bulk file rename first appeared on ..::CHANGE is INEVITABLE::...
In mysql we have — , / and /! comments. This post is mainly about very basic c-style comments. /! : C-Style comments in MySQL We normally see comments in MySQLdump as follows: /!40000 ALTER TABLE a DISABLE KEYS /; Or /!50013 DEFINER=root@localhost SQL SECURITY DEFINER */ These are actually C-Style comments which has embeded […]
The post SQL syntax with /*! c-style comments in MySQLdump first appeared on ..::CHANGE is INEVITABLE::...
Yes the video will reveal the top most secret of 2010!! The video will give you the Hero… How can you, I, our friends really trust our selves that what we see on TV and hear on radio is true? How do we know that our openions are really our own? How […]
The post Top Secret of 2010-Got Revealed-Watch video free first appeared on ..::CHANGE is INEVITABLE::...
Assume we’ve a table with 100 rows and we need to select all columns but one. The problem is headache of actually typing out all 99 required columns!! Solutions / Ideas to above problem are: Ignorance is bliss. Select all(*) and ignore the column. Manually type column names or manage it with copy paste! Create […]
The post Ideas for select all columns but one mysql stored procedure first appeared on ..::CHANGE is INEVITABLE::...
Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The query: SELECT DISTINCT fieldname FROM tablename; The error: “NO MORE SPOOL SPACE”. Correct, the problem wasn’t related to MySQL, that was for something called Teradata. Initially, I could see that query should be […]
The post No More Spool Space Teradata Query Solution first appeared on ..::CHANGE is INEVITABLE::...
There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command Options. 1. # OR rehash: Enable automatic rehashing. Do you have long table names, you find it difficult to remember tablenames or you’re just as […]
The post 5 useful MySQL Command Options-pager-prompt-rehash-tee-system first appeared on ..::CHANGE is INEVITABLE::...
QA-Testing Definitions-Interview Questions: III (T – Z): Race Condition: A cause of concurrency problems. Multiple accesses to a shared resource, at least one of which is a write, with no mechanism used by either to moderate simultaneous access. Ramp Testing: Continuously raising an input signal until the system breaks down. Recovery Testing: Confirms that the […]
The post QA-Testing Definitions-Interview Questions: Part-III first appeared on ..::CHANGE is INEVITABLE::...
QA-Testing Definitions-Interview Questions: II (F – S): Data Dictionary: A database that contains definitions of all data items defined during analysis. Data Flow Diagram: A modeling notation that represents a functional decomposition of a system. Data Driven Testing: Testing in which the action of a test case is parameterized by externally defined data values, maintained […]
The post QA-Testing Definitions-Interview Questions: Part-II first appeared on ..::CHANGE is INEVITABLE::...
QA-Testing Definitions-Interview Questions: I (A – I) Acceptance Testing: Testing conducted to enable a user/customer to determine whether to accept a software product. Normally performed to validate the software meets a set of agreed acceptance criteria. Accessibility Testing: Verifying a product is accessible to the people having disabilities (deaf, blind, mentally disabled etc.). Ad Hoc […]
The post QA-Testing Definitions-Interview Questions: Part-I first appeared on ..::CHANGE is INEVITABLE::...
They say, If cricket is a religion Sachin is the God. It’s been 2,961 matches and 39 years when the first ODI was played. On 24th February 2010, Sachin Tendulkar broke the barrier of 200 runs in ODI, set one more standard. Every Indian believes in him and his skills, no matter in what situation […]
The post God-Sachin Tendulkar takes Cricket on New Heights-Records Machine first appeared on ..::CHANGE is INEVITABLE::...
Holi is a major festival in India and most known as Festival of Colors celebrated all over India. People send emails, text messages (sms) to wish Holi and use artificial (and sometimes natural – abir, gulaal) colors and meet our friends and relatives. There prevails many stories behind the festival of Holi. The major was […]
The post Top 5 Questions about Holi-The Festival of Colors first appeared on ..::CHANGE is INEVITABLE::...
Today I found an interesting site which plays your website!! Yep… it’s codeorgan.com. The codeorgan analyzes the body content of any website / webpage and translate that in to music. It uses complex algorithm helps it in defining key, synth style and drum patterns as per page content. [ad#ad-2-300×250] Steps it follow to play your […]
The post codeorgan-give sound to your webpage-website first appeared on ..::CHANGE is INEVITABLE::...
It’s Ash Wednesday today (Feb 17th 2010) !! I learnt that Ash Wednesday derives its name from the practice of placing ashes as a Sign of the Cross on the foreheads of adherents as a sign of repentance. It’s ritual to celebrate this day as a reminder of mortality. Dusting oneself with ashes was the […]
The post Ash Wednesday:Repent, and believe the Gospel and MySQL first appeared on ..::CHANGE is INEVITABLE::...
I’m using Redhat Linux (RHEL 5). Yesterday I saw a bit suspicious activities and data movements under my “home” (/home/username directory). I thought of investigate / audit through my Redhat linux machine and catch the “Right Person” / “Who did it”. Following are the steps I followed: [which if you follow, you may follow.] 1. Retrieve […]
The post Audit-Checking login history-to know WHO DID THAT on Redhat Linux first appeared on ..::CHANGE is INEVITABLE::...
Google announced acquisition of Aardvark – The new kind of social search. Through the “social search” term I thought it has to do something with what Google’s has said earlier in google’s official blog “social search getting more social” ! But that was actually in your google search, you get a saperate result from your […]
The post Buzz: Google buys Aardvark for Social Questioning first appeared on ..::CHANGE is INEVITABLE::...
The Mysqldumpsplitter can extract database, table, all databases, all tables or tables matching on regular expression from a mysqldump. It can produce the compressed output of sqls in specified directories. The tool has undergone a complete rewrite, and there are many more functionalities added. Please follow GitHub Repository for future changes or further improvements. Download […]
The post MyDumpSplitter-Extract split database or tables from mysqldump | MySQL dump splitter first appeared on ..::CHANGE is INEVITABLE::...
This morn one more way of e-socializing introduced by google – Google Buzz. It’s a one of the trending topic on twitter… How to get Google buzz: Well it’s being rolled out in phased manner directly to your Gmail, so if not now, your Gmail inbox should have this feature very soon. To get Google […]
The post Whats New-Google Buzz in Gmail Inbox, Mobile first appeared on ..::CHANGE is INEVITABLE::...
Wikipedia says: “The 2010 FIFA World Cup will be the 19th FIFA World Cup, the premier international football tournament. It is scheduled to take place between 11 June and 11 July 2010 in South Africa. The 2010 FIFA World Cup will be the culmination of a qualification process that began in August 2007 and involved […]
The post FIFA Football World Cup-2010 South Africa-Winner Announced! first appeared on ..::CHANGE is INEVITABLE::...
Here is one more procedure – (this time) for mass renaming of table. Adding and Removing table-name prefixes 🙂 A friend of mine was renaming 100+ tables by using replace methods in notepad. I showed em a bit better editor: Editplus and then I thought of rescue rest of those who are still interested in […]
The post Stored procedure to add-remove prefix by rename table mysql first appeared on ..::CHANGE is INEVITABLE::...
Yesterday a friend came across an oracle query problem: Consider below table: cid cname.... cdata 1 x xxxx 1 x xxxx .. 2 xzzz fjnd 3 a evddd Now the problem was cid is repeated and cdata column is having some extra characters but data is considered same (eg. xxxx & xxxx..). so when he […]
The post Oracle query-eliminate duplicate but one using rowid first appeared on ..::CHANGE is INEVITABLE::...
Barely a week after tragedy hit Haiti in the form of a massive earthquake, my favourites Linkin Park along with many other artists have stepped forward to help the country’s struggling residents with ambitious “Download to Donate for Haiti” project. Project Download to Donate for Haiti will donate whole amount generated by each and every […]
The post How music can rescue-Help for Haiti-Download to Donate campaign first appeared on ..::CHANGE is INEVITABLE::...
It’s been long I have read jokes online, but last week I happen to read a few best jokes. Mostly these are all realted to technology / IT / Computers and persons in those fields but each joke is hilarious. Few are very old and you might have heard em many times but they’re must […]
The post Jokes Fun One-liners: Anti-bored Dose – I first appeared on ..::CHANGE is INEVITABLE::...
Loading csv to MySQL or any delimited data files to MySQL database is a very common task frequently questioned about and almost every-time LOAD DATA INFILE come into rescue. In this article I will explain you about all different scenarios and explain you how to get the data loaded directly from csv to MySQL database […]
The post Load Delimited Data – CSV to MySQL, Excel to MySQL Database first appeared on ..::CHANGE is INEVITABLE::...
Well no doubt I’m a google freak. I’ve learnt a lot through it and I have searched a lot. But I wasn’t much aware about my intencity of googling stuffs. I hope you know there is something called Web History. In case you’re unaware: www.google.com/history/ Google Web History includes: – View and search details across […]
The post My Google Exploitation – Web History Graphs 2009 first appeared on ..::CHANGE is INEVITABLE::...
I have done it for so many times, setting a cronjob. Today I was tring to set a simple cronjob which will output the log file with timestamp attached filename. Hourly running cron entry was: 0 * * perl demo.pl > demo-out_date "+%Y-%m-%d\_%H-%M".log Running the same command on shell prompt was working fine. […]
The post crontab not working with dynamic date filename – rhel linux first appeared on ..::CHANGE is INEVITABLE::...
Well 3 idiot was no doubt one of the best movie of last dacade. But I laughed a lot at speech from Mr. Silencer, where rancho replaced words Chamatkar and Dhan 🙂 Here is the speech – spread it like a virus 🙂 Adarniya sabhapati mahodaya… Atithi vishesh, Shikshan mantri shri R D tripati [tripathi] […]
The post 3 Idiots – Chatur Silencer Speech Chamatkar first appeared on ..::CHANGE is INEVITABLE::...
Are we waiting for another “Avatar”?? As per Hindu mythology, lord Vishnu took 10 different avatars to save our world. As per mythology, lord Vishnu will take avatar when Rakshasas get out of control. Rakshasas will come from PatalLok. Rakshasas will kill innocents to gain power and money. Their guru Shukracharya will promise them that […]
The post waiting for another Avatar – discussion first appeared on ..::CHANGE is INEVITABLE::...
And I looked back and thought of updating this post… Recently Monty has posted again and I completely convinced with whatever Monty has conveyed now or earlier. The explainations he has provided under self-interview, I find sensible enough. I did participated the help-saving-mysql campaign and I’m happy knowing the statistics. I did got convinced about the possible threat about […]
The post Petition – Help saving MySQL – II first appeared on ..::CHANGE is INEVITABLE::...
I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the maximum capacity of the address space is 2^32 bytes and that is where these limits come from. * For MYSQL 5.0: Following are memory (storage) […]
The post MySQL Memory Usage Limits on 32 bit Linux first appeared on ..::CHANGE is INEVITABLE::...
Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) – MySQL 5.0 DBA Part I Certification (CX-310-810) – MySQL 5.0 DBA Part II Certification (CX-310-811) 2. MySQL 5.0 Developer Certification (SCMDEV) – MySQL 5.0 Developer […]
The post MySQL Certification Free Retake: Get TWO chances to get MySQL Certified first appeared on ..::CHANGE is INEVITABLE::...
And I looked back and thought of updating this post… We all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that a business will always seek profit; so will Oracle. And thats where worries and fear for existance of MySQL as an open-source and future growth […]
The post Monty: Help Saving MySQL – The Oracle & EC first appeared on ..::CHANGE is INEVITABLE::...
This procedure will split a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And we want output as follows: So again I wrote a procedure. Procedure will read a data from “tmp” table and will split data by my_delimiter […]
The post MySQL Stored procedure – Split Delimited string into Rows first appeared on ..::CHANGE is INEVITABLE::...
Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to particular table if it exists. Basically I created it to satisfy a need of altering a table if column exists. Now it can be used […]
The post MySQL Stored procedure – Execute query if table or Column exists first appeared on ..::CHANGE is INEVITABLE::...
This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables. It uses information schema database to gather information and storing in a temporary table. Usage: call xplore(database-name); – Procedure will search through information schema for […]
The post Stored procedure to Find database objects first appeared on ..::CHANGE is INEVITABLE::...
Having a colourful display on shell script is something that’d beautify your experience. Using colour text and echos will help you to highlight and distinguish the shell output on a linux prompt. Here’s how you can have colored text in linux shell, try following command on your bash: bash $] tput setaf 1 You will […]
The post How to echo colored text in linux shell script first appeared on ..::CHANGE is INEVITABLE::...
For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for monitoring a master master replication setup. It requires a single shared login id available on both MySQL servers. It will display in tabular format following […]
The post MySQL master master replication monitor with php code first appeared on ..::CHANGE is INEVITABLE::...
Using Vlookup: I have two csv files; File1 has Id and Value Columns and File2 has Id. Problem: I need to compare both files and put respective values to File2 from File1. Solution: VLookup in excel Steps: Open both files in Excel & arrange it vertically (Window >> Arrange; for ease) Click on cell where […]
The post Using VLookup like Batch script to compare two excel / csv first appeared on ..::CHANGE is INEVITABLE::...
I required to make a batch script which needs file / directory to be created with current date / time stamps. Following are the code snipts for formating date / time in a batch script: FOR /F “TOKENS=1* DELIMS= ” %%A IN (‘DATE/T’) DO SET MYDATE=%%B FOR /F “TOKENS=1,2 eol=/ DELIMS=/ ” %%A IN (‘DATE/T’) […]
The post bat – batch file to create formatted date time (ddmmyyyy) directory first appeared on ..::CHANGE is INEVITABLE::...
In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory usage estimation for the present MySQL instance. We have global buffers which are allocated irrespective of connections as and when mysql server is started. Along with […]
The post Calculate Mysql Memory Usage – Quick Stored Procedure first appeared on ..::CHANGE is INEVITABLE::...
Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4, Windows XP, Enough RAM 🙂 Logs: General, Error & irrelevant here though Slow query. Prologue: Administrator performs scheduled backup properly in normal scenario. What I […]
The post Scheduled Backup MySQL Administrator & Windows Scheduler – Odd first appeared on ..::CHANGE is INEVITABLE::...
Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication we know commands like: Show slave status; Show master status; Refer: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-replication.html But when it comes to non-gui interface, it becomes little tedious. With some […]
The post Monitor multiple mysql replication using php: Updated first appeared on ..::CHANGE is INEVITABLE::...
Yes !! It is a Gajab Kahani, the name is perfectly chosen by the director Rajkumar Santoshi but it would have been better if he had taken a better script and had done some lessons on Direction before actually directing this one. I missed at least 20 minutes of the movie in start and it turned […]
The post Movie review: Ajab Prem Ki Gajab Kahani first appeared on ..::CHANGE is INEVITABLE::...
Hi All,I have figured out a way to get Zune HD discounted 15$ … Yes 15 $.What you have to do is go to dell site using following coupon link below:http://2b592ab2.linkbucks.comAdd Zune HD to your CartAnd add following coupon to get the 15$ discountAin’t its Easy??Whats More?? You will get free regular shipping..So shat are you […]
The post Buy Zune HD at Low Rates – Free Discount Coupon $15 first appeared on ..::CHANGE is INEVITABLE::...
This article is a brief step-by-step tutorial on the subject task which is divided into the following main parts: Installing two MySQL Server Instances Setting up master-slave replication Setting up slave-master replication Let’s begin covering those points… Installing Two MySQL Server Instances on Windows: 1. Install MySQL: Download MySQL Binaries from dev.mysql.com. Install normal MSI […]
The post Quick Multi MySQL Server Installation with Master-Master Replication on Same Windows Box first appeared on ..::CHANGE is INEVITABLE::...
“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter in monitoring and maintaining replication. This article explains us a way to monitor replication slave lag time. It also includes a sample batch scripts to […]
The post Replication slave lag monitoring using heartbeat and windows batch scripts first appeared on ..::CHANGE is INEVITABLE::...
Simply tragedic, pityful, disgusting and many words… Movie is far from reality and close to cruelty. The best thing about London Dreams is that it had an end, though nonsense, it ended. Since beginning to end movie makes your mind ask questions… why? how?… But your curiosity dies exactly when movie starts rolling in around […]
The post London dreams – 2009 – xtreme Movie review first appeared on ..::CHANGE is INEVITABLE::...
What will you do if one day some one ask you to find single string in all databases, all tables and in all columns, In MySQL Database? I just read such question and tried to find a “ready made” solution. Reusability is Key Concept 😉 !! But I ended up finding no “copy-paste” material. Some of the posts […]
The post Search / find through all databases, tables, columns in MySQL first appeared on ..::CHANGE is INEVITABLE::...
In this post we will see importance of replication related variables auto_increment_increment & auto_increment_offset with respect to MySQL Master Master setup. Consider we’ve already set a master-master replication. Now create following table on Server1: id int(10) NOT NULL auto_increment, PRIMARY KEY (id) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; The table will will get replicated on Mysql […]
The post MySQL Master Master Replication and auto_increment_increment / auto_increment_offset first appeared on ..::CHANGE is INEVITABLE::...
Ganapati Aarti: Sukhkarta Dukhharta ।। श्री गणेशाय नमः ।। सुखकर्ता दुखहर्ता वार्ता विघ्नाची |नुरवी पूर्वी प्रेम कृपा जयाची |सर्वांगी सुंदर उटी शेंदुराची |कंठी झळके माळ मुक्ताफळाची || १ || जय देव जय देव जय मंगलमूर्ती |दर्शनमात्रे मनकामना पुरती ||रत्नखचित फरा तूज गौरीकुमरा |चंदनाची उटी कुंकुमकेशरा |हिरे जडित मुकुट शोभतो बरा |रुणझुणती नुपुरे चरणी घागरिया || 2 || […]
The post Ganapati Aarti: Sukhkarta Dukhharta – With English Translation | download mp3 first appeared on ..::CHANGE is INEVITABLE::...
This is an online birthday card wish to my dear brother. Click to view the Online Birthday Card: Happy Birthday Kaushik. Most people find it little difficult to guess the “Functionality” of this birthday wishing card/page. It’s slow and steady will win the wish kinda birthday page 🙂 My bro liked it, and I know […]
The post Unique birthday card wishes for My dear Brother first appeared on ..::CHANGE is INEVITABLE::...
This is a LAN Messenger which allows you to chat with friends on local network. The Dos based chat program is just like a chat program but only for LAN. What you need to have is: This tool, a desire for communication and an IP / Machine Name. In one line, its a “batch program […]
The post The Dos Chat – Lan Messenger first appeared on ..::CHANGE is INEVITABLE::...
Oscar Fingal O’Flahertie Wills Wilde!! Oscar Wilde is well known for his biting wit. And he has an extraordinary way of representing the things. Here is some collection of famous quotes of Oscar Wilde: A cynic is a man who knows the price of everything but the value of nothing. A dreamer is one who […]
The post Selected Oscar Wilde Quotes first appeared on ..::CHANGE is INEVITABLE::...
Its been long since i’ve heard such contentful, meaningful, provoking and great lyrics with such gr8 musical representation.The lines they’ve written are just mind-blowing. Music is awesome and vocals as well.Now I’ve got very high-expectations from Gulaal.The very first song I heard was – 1) SHEHER by Piyush Mishra/Swanand Kirkirehe.. ek bakhat ki baat bataein, ek […]
The post Gulaal movie – music and lyrics first appeared on ..::CHANGE is INEVITABLE::...
Characters Character Description Example Any character except [\^$.|?+() All characters except the listed special characters match a single instance of themselves. { and } are literal characters, unless they’re part of a valid regular expression token (e.g. the {n} quantifier). a matches a \ (backslash) followed by any of [\^$.|?+(){} A backslash escapes special characters […]
The post Regular Expression Basics – Quick Reference first appeared on ..::CHANGE is INEVITABLE::...
About Subversion: Subversion, also known as svn, is a version control system much like the Concurrent Versions System (CVS). Version control systems allow many individuals (who may be distributed geographically) to collaborate on a set of files (typically source code). Subversion has all the major features of CVS, plus certain new features that CVS users […]
The post Quick look at subversion / svn commands – overview first appeared on ..::CHANGE is INEVITABLE::...
Delhi 6…It was a regular weekend and as usual i was expecting a good time with Delhi 6! Movie starts with a “Kala Bandhar” [monkey-man] fear in Delhi. A parallel shot was of Abhishek’s Grandma getting closer to death and was interested to live rest of her life in Delhi. “Kala-bandhar” was all over the plot with […]
The post Delhi 6 – Movie review first appeared on ..::CHANGE is INEVITABLE::...
Hi all,I don’t know why but just wanted to talk about the movie dev-d. I a lot of fun.TOI reports were 5-stars and we were damn eager to know the reason… I’ll give it 3.5-Star.. actually I loved et’ 🙂The way of representation and direction was gr8. and script was different!!! Some scenes i wont […]
The post Dev D – Movie review first appeared on ..::CHANGE is INEVITABLE::...
Amdahl’s Law: The speed-up achievable on a parallel computer can be significantly limited by the existence of a small fraction of inherently sequential code which cannot be parallelised. (Gene Amdahl) Augustine’s Second Law of Socioscience: For every scientific (or engineering) action, there is an equal and opposite social reaction. (Norman Augustine) Benford’s Law: Passion is […]
The post Funny Computer laws – quotes first appeared on ..::CHANGE is INEVITABLE::...
Collection of insulting one-liners: A demitasse would fit his head like a sombrero. (Thanks, Chris Cole) A guy with your IQ should have a low voice too! A half-wit gave you a piece of his mind, and you held on to it. A sharp tongue is no indication of a keen mind. After meeting you, […]
The post Collection for insulting – one liners first appeared on ..::CHANGE is INEVITABLE::...
Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite simple code with two php files one to display and one to upload. For Image Upload code, I’ve added code download link upload-image-mysql-demo.zip at the […]
The post Upload Image to MySQL using PHP first appeared on ..::CHANGE is INEVITABLE::...
This article explain a way to get a mail as soon as the disk usage reaches to its critical level to avoid issues later. To set a simple monitor on Linux / Unix, I have two simple scripts: DSAlert.sh : Shell script for retrieving disk space percentages and put in to a cron job. DiskSpace_Alert.pl : Perl script for sending an […]
The post Simple Shell Script to Monitoring Disk Space on a Linux Machine first appeared on ..::CHANGE is INEVITABLE::...
Following are linux commands, tricks for doing regular tasks. Rename files: replace space by _ in linux: for files in ; do mv "$files" echo $files | tr ' ' '\_'; done Change case of multiple file names: for files in ; do mv $files echo $files | tr '[:upper:]' '[:lower:]'; done Find files having […]
The post Linux Shell Commands – quick how-tos first appeared on ..::CHANGE is INEVITABLE::...
MyISAM InnoDB Default since version 3.23 Relatively newer Files storage: FRM: table definition, MYD: Actual Data MYI: Index File FRM: table definition .ibd file (concept of table space) or single huge .ibdataX No transation, Foreign key ACID Transactions, Foreign key, Rollback Low disk and memory utilisation Relatively high storage requirements (Almost 3 times disk space) […]
The post Difference MyISAM and InnoDB Storage Engines Mysql first appeared on ..::CHANGE is INEVITABLE::...
You’d never forget the those beautiful moments when you feel loved and feel blessed with the presence of the one of your life. Looking at above capture of my dear ones, I jotted down a few lines and that’s my first attempt. I call it (my) Life At Rest. insomniac for your sleep, you’re awesome […]
The post life at rest – my first poem first appeared on ..::CHANGE is INEVITABLE::...
Oscar Fingal O’Flahertie Wills Wilde!! Oscar Wilde is well known for his biting wit. And he has an extraordinary way of representing the things. Here are some collection of famous quotes of Oscar Wilde: A cynic is a man who knows the price of everything but the value of nothing. A dreamer is one who […]
The post Selected Oscar Wilde Quotes first appeared on ..::CHANGE is INEVITABLE::...
After reading at a lot of places for the the single repeatative question, “What engine shall I choose – MyISAM or Innodb?”, this is what I’ve got. Following are points of consideration for MyISAM – MySQL storage engine: Tables are really fast for select-heavy loads Table level locks limit their scalability for write intensive multi-user […]
The post Choosing between MyISAM and INNODB – MySQL Storage Engines first appeared on ..::CHANGE is INEVITABLE::...
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. Downloading MySQLTuner: wget http://mysqltuner.com/mysqltuner.pl chmod +x mysqltuner.pl Using MySQLTuner Script for Lampp systems: Just […]
The post Using MySQLTuner – MySQL Optimization Tool first appeared on ..::CHANGE is INEVITABLE::...
The perl script is mainly created to avoid manual Mysql Server Maintenance. The script uses Perl module DBI. You need to provide access credentials and database name(optional). Regarding Analyse, Optimize and Repair you may ofcourse refer dev.mysql.com. OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you […]
The post Perl Script for Analyze – Optimize – Repair Mysql Databases first appeared on ..::CHANGE is INEVITABLE::...