[MySQL]: Storage Engines
6.1 Comparing Transaction and Nontransaction Engines Transaction-safe tables (TSTs) have several advantages over nontransaction-safe tables (NTSTs): They are safer. Even if MySQL crashes or you get hardware problems, the database will be in a consistency form. You can combine many…
[MySQL]:User Account Management
We can create User Accounts in two ways. By using CREATE USER or GRANT statements. (Recommended Method) By manipulating the mysql grant tables with statements like INSERT and DELETE. Using CREATE USER and GRANT statements: Creating a User: By…
[MySQL]: Installation
Installing MySQL from RPM Packages on Linux For non-RPM Linux distributions, you can install MySQL using a .tar.gz package. MySQL-server-VERSION.glibc23.i386.rpm The MySQL server. You need this unless you only want to connect to a MySQL server running on another…
[MySQL] : Overview of Database Management System
MySQL is a database management system A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add,…
[MySQL]: Instance Manager
MySQL Instance Manager MySQL Instance Manager is been deprecated in MySQL 5.1 and is removed in MySQL 5.5. Using mysqld_multi for Managing Multiple MySQL Servers mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix…
[MySQL]: General security issues
General Security Guidelines Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql database! This is critical. Learn the MySQL access privilege system. The GRANT and REVOKE statements are used for controlling…
[MySQL]: Optimization
Optimization is a complex task because ultimately it requires understanding of the entire system to be optimized. Although it may be possible to perform some local optimizations with little knowledge of your system or application, the more optimal you want…
[MySQl]: Partitioning
Overview of Partitioning in MySQL A partition is a division of a logical database or its constituting elements into distinct independent parts. Database partitioning is normally done for manageability, performance reasons. The partitioning can be done by either…
[MySQL] : Information schema
INFORMATION_SCHEMA Tables INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are…
[MySQL]: Purpose of Profiler in MySQL
MySQL Profiler: The SQL Profiler is built into the database server and can be dynamically enabled/disabled via the MySQL client utility. To begin profiling one or more SQL queries, simply issue the following command: mysql> set profiling=1; Two…