Tag Archives: General

Oracle Atonomous

Last month Oracle – (Larry Ellison, CTO and Executive Chairman) has introduced Oracle Autonomous database for OLTP system Oracle has already introduced Autonomous on OLAP system in early this year. This way it is shows that Oracle on Cloud can … Continue reading

Posted in Cloud, Future DBA, News, oracle, Others, RDBMS, Whats New | Tagged , , , , | Leave a comment

What is MemSQL

yeah, MemSQL for me its a combination of RDBMS and NOSQL and more of flexibility of both per our choice, most of the RDBMS going with such concept. NOSQL is compromise with ACID property and flexible for developers it has … Continue reading

Posted in Future DBA, NoSQL, Others, RDBMS, What I learned today, Whats New | Tagged , , , | Leave a comment

Fog Computing

Its been introduced by CISCO On November 19, 2015, system which helps cloud computing to reduce the response time from cloud computing to send-receive the information. i think as it is more like a product/Concept might be the reason not … Continue reading

Posted in Cloud, Computers and Internet, Future DBA, General, Others | Tagged , , , | Leave a comment

Microsoft Acquire GitHub after Linkedin

Microsoft acquires GitHub is a very big news after LinkedIn… that way now Microsoft will grow like anything as considering the information it has at GitHub, it will have a great help of open source information at GitHub will provide … Continue reading

Posted in Basic, News, Others, Whats New | Tagged , , | Leave a comment

Day 14 MySQL sys Schema

MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as it works on Performance Schema the Performance Schema must be enabled for the sys database. Following some of the important tables: sys_config: … Continue reading

Posted in MySQL, Others, Performance Tuning, What I learned today | Tagged , , , | Leave a comment

Day 13 MySQL Performance_Schema

performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear. This database has its own storage engine –“performance_schema” Even you may have this database but it could be possible that … Continue reading

Posted in MySQL, Others, Performance Tuning, What I learned today | Tagged , , , , | Leave a comment

Day 12 INFORMATION_SCHEMA database

Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because it is not stored any data directly, it provides information about metadata and other information which mysql has – data … Continue reading

Posted in General, MySQL, Others, What I learned today | Tagged , | Leave a comment

Day 11 MySQL System Database

Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are some system database MySQL has which will also contains very important information. Now on we will spend some time on … Continue reading

Posted in General, MySQL, Others, What I learned today | Tagged , , | Leave a comment

Day 10 Option file

So far we have discussed various mays to configure MySQL, Environmental Variables, Global Variable, Session Variables, Status Variable and Server Variables. All this variables are important and set the variable some of them dynamically affects the system and some required … Continue reading

Posted in MySQL, Others, What I learned today | Tagged , | Leave a comment

Day 9 Variables

In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing on other variables, there are Global Variables and Session/Local Variables which reflects the state of the MySQL and we can … Continue reading

Posted in Basic, MySQL, Others, What I learned today | Tagged , , , | Leave a comment