Tags » Innodb

Backup And Restore Multiple Databases In MYSQL

In this post we will learn how to perform backup of multiple databases and restore them in MySQL server.

To perform multiple database backup execute below command. 172 more words

MySQL

Change Engine Of MySQL Tables in Bulk

In this post we will learn how to change engine of MySQL tables in bulk. suppose we have a requirement where we have to change engine from MyISAM to InnoDB for all the tables in database , to do so follow below steps. 249 more words

MySQL

Optimizing innodb queries

optimizing innodb queries

  1. to tune the queries on innodb tables have a set of appropriate indexes on each table.
  2. do not specify too many or too long column in primary key because the values are getting duplicated in each secondary index…

  3. 413 more words
MySQL

Bulk Loading For InnoDB Tables.

1. when inserting bulk tables in innodb tables make autocommit=0 because it performas log flush for every inserts.
to disable it follow below procedure

set autocommit=0… 154 more words

MySQL

Duplicates Records in Multiple Fields with MySql

Retrieving count of Duplicated Records

SELECT firstname, lastname, COUNT(*)
FROM staff
GROUP BY firstname, lastname
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC;

Retrieving The Individual Duplicated Records… 38 more words

MySQL

MySQL - 1

이 포스트는 쓸모없이 내용이 깁니다. 틀린 내용이 있을 수도 있구요. 다음과 같은 내용을 정리했었습니다. 가공없이 출력합니다.

  • InnoDB Table and Index Structures
  • MySQL Consistent Nonlocking Reads…
  • 1,646 more words
All

What is difference between MYISAM and InnoDB?

 am writing this article to all those PHP follower to understand the difference between MYISAM and INNODB.
MYISAM:
1. MYISAM supports Table-level Locking
2. MyISAM designed for need of speed… 100 more words

PHP