BACKUP AND RECOVERY IN MySQL. What is backup ? Backup is nothing copying the data into another location . Why we need backup ? If you’re storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups… Read More
Oracle vs MySQL DBA Checklist/Tasks Note : Proper Documentation which is very important in order to save time and act on issue immediately. DB health check list for Day to Day Activities. Differences between Oracle and MySQL SNO ORACLE MySQL 1 –> Check Alert… Read More
DIFFERENCE BETWEEN ORACLE AND MySQL -05 Please refer my previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -04 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 In Oracle ,we need to write Parameters to set (or)… Read More
DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous article . DIFFERENCE BETWEEN ORACLE AND MySQL -03 In this article will see few more differences between ORACLE and MySQL. Differences between Oracle and MySQL SNO ORACLE MySQL 1 How to check metadata of table ? SYS>> desc <objectname> “;”… Read More
In this article will have a look on different database editions in ORACLE & MySQL . DATABASE EDITIONS IN ORACLE : ENTERPRISE EDITION (EE) : Most powerful with a vast array of tools and features of the largest corporation. STANDARD EDITION (SE) : Oracle SE… Read More
DIFFERENCE BETWEEN ORACLE AND MySQL. Please refer previous articles. DIFFERENCE BETWEEN ORACLE AND MySQL -01 In this article will see few more differences between ORACLE and MySQL. ORACLE … Read More
DIFFERENCE BETWEEN ORACLE AND MySQL. The Oracle Database is an object-relational database management system (ORDBMS). MySQL is an open source relational database management system (RDBMS). Both the Oracle Database and MySQL are database management systems currently produced and managed by the Oracle Corporation. The Oracle… Read More
Table Maintenance in MySQL. This page contains several commands you will use to optimize, analyse and repair tables. It also presents the mysqlcheck command line tool. Table maintenance will separated in five ways .They are : Check Table Repair Table Analyse Table Optimise Table mysqlcheck … Read More
SECURITY AND USER MANAGEMENT IN MySQL. SECURITY RISKS IN MySQL. When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: Comes with multiple users or… Read More
STORAGE ENGINES IN MySQL We covered MyISAM & InnoDB in previous article. STORAGE ENGINES IN MySQL (Article -12) In this article we will cover one more important storage engine called MEMORY STORAGE.ENGINE. MEMORY STORAGE ENGINE : Memory storage engine creates tables in memory. It is… Read More
