MySQL Memory Usage Limits on 32 bit Linux
Kedar
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…
Browsing Category
MySQL-Articles
79 posts
MySQL related blog posts
Scheduled Backup MySQL Administrator & Windows Scheduler – Odd
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,…
Install 2 MySQL Server instances replication on Windows
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…
MySQL Master Master Replication and auto_increment_increment / auto_increment_offset
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…
Difference MyISAM and InnoDB Storage Engines Mysql
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…
Choosing between MyISAM and INNODB – MySQL Storage Engines
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…