Tag Archives: Internal

Day 21 NDB Storage Engine (Cluster)

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

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

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

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

More IMPORTANT miscellaneous info

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

*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

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