Databse - Eduguru

MySQL Cluster

How can I check MySQL engine type for a specific database?

May 4, 2018May 4, 2018 eduguru 0 Comments check mysql engine, How can I check MySQL engine type for a specific database?, MySQL, mysql database engine, mysql db engine, SHOW GLOBAL VARIABLES LIKE 'storage_engine'

MySQL engine type for a specific database SHOW GLOBAL VARIABLES LIKE ‘storage_engine’ [xyz-ihs snippet=”Discuss”]

MySQL Cluster

Views in MySQL : MySQL Views

May 3, 2018 eduguru 0 Comments

Summary: in this tutorial, you are going to learn about MySQL View. We will explain how MySQL implements views. MySQL supports database views

Difference between INNER JOIN and OUTER JOIN

April 23, 2018 eduguru 0 Comments 2) are unique to A, 3, 4) are common, 6) are unique to B. Inner join An inner join using either of the equivalent queries gives the intersection of the two tables, An inner join of A and B gives the result of A intersect B, and (5, and data as follows: A B - - 1 3 2 4 3 5 4 6 Note that (1, and vice versa. select * from a FULL OUTER JOIN b on a.a = b.b; a | b -----+----- 1 | null 2 | null 3 | 3 4 | 4 null | 6 null | 5, b where a.a = b.b; a | b --+-- 3 | 3 4 | 4 Left outer join A left outer join will give all rows in A, b where a.a = b.b(+); a | b --+----- 1 | null 2 | null 3 | 3 4 | 4 Full outer join A full outer join will give you the union of A and B, b.* from a, Difference between INNER JOIN and OUTER JOIN, i.e. All the rows in A and all the rows in B. If something in A doesn't have a corresponding datum in B, i.e. the inner part of a venn diagram intersection. An outer join of A and B gives the results of A union B, i.e. the outer parts of a venn diagram union. Examples Suppose you have two Tables, i.e. the two rows they have in common. select * from a INNER JOIN b on a.a = b.b; select a.*, plus any common rows in B. select * from a LEFT OUTER JOIN b on a.a = b.b; select a.*, then the B portion is null, with a single column each

An inner join of A and B gives the result of A intersect B, i.e. the inner part of a

nosql

NoSQL: What is NoSQL-An introduction

April 13, 2018 Satya Prakash 80 Comments a huge amount of data and more. So the misleading term "nosql" (the community now translates it mostly with "not only sql") should be seen as an alias to something like the definition above. NoSQL Dat, A NoSQL (often interpreted as Not Only SQL) database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. The , allow each value to have a type, and frequent code pushes Object-oriented programming that is easy to use and flexible Efficient, and store columns of data together, and their data model addresses several issues that the relational model is not designed to address: Large volumes of structured, and unstructured data Agile sprints, Cloudera Cassandra Hypertable Accumulo Amazon SimpleDB Cloudata MonetDB HPCC Apache Flink (incubating) IBM Informix Splice Machine Elasticsearch MongoDB Couchbase Server CouchDB RethinkDB SequoiaDB Ra, easy replication support, eventually consistent / BASE (not ACID), Hortonworks, instead of rows. The Benefits of NoSQL When compared to relational databases, monolithic architecture There are many NoSQL DB present the market (about 150). Some of them are listed below. Hadoop / HBase MapR, NoSQL databases are more scalable and provide superior performance, NoSQL: What is NoSQL-An introduction, or even nested documents. Graph stores are used to store information about networks, or key-array pairs, quick iteration, scale-out architecture instead of expensive, semi-structured, simple API, such as "integer", such as Redis, such as social connections. Graph stores include Neo4J and HyperGraphDB. Key-value stores are the simplest NoSQL databases. Every single item in the database is stored as an attribute name (or "key"), together with its value. Examples of key-value stores are Riak and Voldemort. Some key-value stores, which adds functionality. Wide-column stores such as Cassandra and HBase are optimized for queries over large datasets

A NoSQL (often interpreted as Not Only SQL) database provides a mechanism for storage and retrieval of data that is

MySQL Cluster

Reset ( Re-Sync ) MySQL Master-Slave Replication

March 31, 2018 eduguru 3 Comments master slave replication, mysql resync master slave replication, Reset ( Re-Sync ) MySQL Master-Slave Replication, resync master slave replication

Some times MySQL replication creates problems and slave could not sync properly from master. It may cause with lots of

MySQL Cluster

views changed into tables, while restoring mysql database

March 26, 2016 Satya Prakash 0 Comments mysql error, mysql view changed to table, mysql views error, views changed into tables, while restoring mysql database

In the backup script the views are first created as tables which are then dropped at the end of

MySQL Cluster

MySQL Index : Understanding MySQL indexing

January 11, 2016January 11, 2016 Satya Prakash 1 Comment Facts about Indexes, How MySQL Uses Indexes, How to create Index, MySQL Index, MySQL Index : Understanding MySQL indexing, MySQL indexing, SQL CREATE INDEX Syntax, Understanding MySQL indexing, Verifying Index Usage, What is Indexing

What is Indexing? A database index is a data structure that improves the speed of operations in a table. Indexes

MySQL Cluster

MySQL Database Administration – Part1

December 28, 2015December 28, 2015 Satya Prakash 0 Comments creating a MySQL User Account, Execute simple SQL commands using MySQL Client, including the PRIMARY KEY. SHOW TABLE STATUS LIKE tablename\G, Installing MySQL on Linux/UNIX, Installing MySQL on Windows:, MySQL Database Administration - Part1, mysql Post-installation Steps:, Running and Shutting down MySQL Server:, Setting Up a MySQL User Account:, SHOW INDEX FROM tablename, SHOW INDEX FROM tablename: Presents the details of all indexes on the table, Verifying MySQL Installation

Running and Shutting down MySQL Server: First check if your MySQL server is running or not. You can use the

MySQL Cluster

Creating Views in MySQL : How to create mysql views

December 11, 2015December 11, 2015 eduguru 0 Comments

Summary: in this tutorial, you will learn how to create views in MySQL by using the CREATE VIEW statement. Introduction to CREATE VIEW statement

mysql reset password

Reset mysql root password

February 6, 2015February 6, 2015 Satya Prakash 0 Comments Reset mysql root password, Steps to reset the mysql root password Step # 1 : Stop mysql service # /etc/init.d/mysql stop Step # 2: Start to MySQL server w/o password: # mysqld_safe --skip-grant-tables Step # 3: Connect to mysql

Steps to reset the mysql root password Step # 1 : Stop mysql service # /etc/init.d/mysql stop Step # 2: Start

← Previous