Database Engine for MySQL


Today I come across an article database engine for MySQL. Its interesting and I brief some of them.

  1. What are database engines?
  • Also known as storage engines.
  • Software component of the database management. System that actually stores, retrieves, modifies and deletes data.

2. Why do we need different database engines?

  • Every applications has different requirement.
  • For some applications performance is major issue.
  • For some applications frequent read/write are more important than frequent updates.
  • For some application searching is major issue compared to the read/write/update.

3. Types of database Engines?

InnoDB,MYISAM,BerkleyDB etc., Every database engines has its different pros and cons.

          MYISAM:

  • Designed for database are frequently read not updated.
  • High performance and good for frequent read operations.
  • Locks table while updating.

          InnoDB:

  • Designed for database those are frequently updated not read.
  • InnoDB is transaction-safe.
  • Data Integrity is maintained throughout the entire query process.
  • Allow multiple updates on single table. Locks only row not table.

4. When to use what database engines?

  • More updates less read
  • More performance
  • Bank
  • Social networking website.

 

This storage engine is used for tables and not to database.

To set the default storage engine according to our requirement, go to /etc/mysql/my.cnf; (the path may vary to different distros. Here I am using Ubuntu)

Add a new line in [mysqld]

Default-storage-engine = innodb

Save the my.cnf file and restart MySQL service.

Advertisements

One Response to Database Engine for MySQL

  1. ost to pst says:

    Have you ever thought about publishing an ebook or guest authoring on other websites?
    I have a blog based on the same information you
    discuss and would really like to have you share some stories/information.
    I know my visitors would appreciate your work. If you’re even remotely interested, feel free to send me an e-mail.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: