Browsing Category

MySQL-Articles

78 posts

MySQL related blog posts

Scheduled Backup MySQL Administrator & Windows Scheduler – Odd

Kedar
November 12, 2009

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,…

View Post

Install 2 MySQL Server instances replication on Windows

Kedar
November 4, 2009

At times you need to install multiple MySQL instances on same machine. This article is a brief step-by-step tutorial on the subject task which is divided into the following main…

View Post

MySQL Master Master Replication and auto_increment_increment / auto_increment_offset

Kedar
September 20, 2009

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…

View Post

Difference MyISAM and InnoDB Storage Engines Mysql

Kedar
January 4, 2009

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…

View Post

Choosing between MyISAM and INNODB – MySQL Storage Engines

Kedar
January 1, 2009

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…

View Post

Using MySQLTuner – MySQL Optimization Tool

Kedar
January 1, 2009

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…

View Post