-
Daily Popular
- Xtreme Movie Review: Agneepath Agneepath Agneepath (2012)
- JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java
- Load Delimited Data (csv, excel) into MySQL Server
- Collection for insulting – one liners
- 10 Steps: MySQL Monitoring through Nagios: Install & Configure
- Unique birthday card wishes for My dear Brother
- Working with EditPlus Text Editor-Regular Expression How To
- MyDumpSplitter-Extract tables from Mysql dump-shell script
- Place to visit Mumbai: Alibaug 1-2 day tour weekend picnic
- 3 Idiots – Chatur Silencer Speech Chamatkar
-
MySQL Archive
-
MySQL Stored procedure – Split Delimited string into Rows
Posted on December 5, 2009 | 17 CommentsMore...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... -
MySQL Stored procedure – Execute query if table or Column exists
Posted on December 5, 2009 | 2 CommentsMore...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... -
MySQL master master replication monitor with php code
Posted on December 4, 2009 | 2 CommentsMore...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... -
Calculate Mysql Memory Usage – Quick Stored Proc
Posted on November 16, 2009 | No CommentsMore...While going through mysql doc and MySQL Server Memory Usage, I noted following quick points regarding how mysql uses memory. We have global buffers which are allocated irrespective of connections... -
Scheduled Backup MySQL Administrator & Windows Scheduler – Odd
Posted on November 12, 2009 | 3 CommentsMore...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,... -
Monitor multiple mysql replication using php: Updated
Posted on November 11, 2009 | 7 CommentsMore...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... -
Quick Multi MySQL Server Installation with Master-Master Replication on Same Windows Box
Posted on November 4, 2009 | No CommentsMore...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... -
Replication slave lag monitoring using heartbeat and windows batch scripts
Posted on November 4, 2009 | No CommentsMore...“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... -
Search-find through all databases, tables, columns in mysql
Posted on October 29, 2009 | 3 CommentsMore...What will you do if one day some one ask you to find single string in all databases, all tables and in all columns? I just read such question and tried to find... -
Problem with Master Master Replication and Auto Increment
Posted on September 20, 2009 | 2 CommentsMore...Consider we’ve already set a master-master replication. Now create following table on Server1: CREATE TABLE `temp` ( `id` int(10) NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;...