Tag Archives: Internal

Day 21 NDB Storage Engine (Cluster)

Posted on May 21, 2018 by Vinay

MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase” NDB Cluster required 3 Nodes required complete the setup: Management node(mgmd): … Continue reading →

Posted in Disaster Recovery, High Avaliability, Isolation Level, MySQL, Others | Tagged , , , | Leave a comment

Day 19 MyIASM Storage engine

Posted on May 19, 2018 by Vinay

MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it is used for Read intensive operations. As described in yesterday this Engine was default till MySQL 5.5 and is widely … Continue reading →

Posted in General, History, Internal, MySQL, Others | Tagged , , , , | Leave a comment

Day 18 Storage engine

Posted on May 18, 2018 by Vinay

MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has many storage engine as per the developer/application requirements. With this good part is that MySQL can work multiple storage engine … Continue reading →

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

Day 14 MySQL sys Schema

Posted on May 14, 2018 by Vinay

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

Posted on May 13, 2018 by Vinay

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 11 MySQL System Database

Posted on May 12, 2018 by Vinay

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 9 Variables

Posted on May 9, 2018 by Vinay

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

More IMPORTANT miscellaneous info

Posted on April 19, 2012 by Vinay

This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff. Okay, continue with Miscellaneous Info here is some more important stuff/ information about sql server. >>Ghost cleanup task runs every 5minuts … Continue reading →

Posted in Basic, Experts, Limitation, Others | Tagged , | Leave a comment

Last updated datetime of Sql Server files

Posted on January 18, 2012 by Vinay

*This is related to physical file size of a MDF or LDF file not internal allocation. One of our user asked that the ldf file is not changing, on checking the last modified date time, user was asking this. Its … Continue reading →

Posted in General, Internal, Transaction Log, What I learned today | Tagged , | Leave a comment

Day 11: Error 823 Device is not ready

Posted on November 11, 2011 by Vinay

Description: Below alerts are very critical alerts but its depends on the hardware, when external hard disk (SAN) is unplugged or handled in properly and sql server could not located the drive you may get error like this. Alert description: … Continue reading →

Posted in Internal, Troubleshooting | Tagged , | Leave a comment