Start with Why: How Great Leaders Inspire Everyone to Take Action
Advertisements
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 Disaster Recovery, High Availability, Internal, MySQL
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
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 Cluster, Internal, MySQL, OLAP, Storage
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 General, Internal, MySQL, Performance Tuning
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 General, Internal, MySQL, Performance Tuning, Troubleshooting
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 General, Internal, MySQL
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 General, Internal, MySQL, Storage
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
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 General, Internal
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
