This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password. MySQL Safe Mode Sometime you …
Read More »
This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password. MySQL Safe Mode Sometime you …
Read More »1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-67d4aa298ef7f006062349/] 3.dum tran with truncate only if still …
Read More »In this article I will explain some information about SQL Server System databases. System databases are created automatically when you install SQL Server. The …
Read More »What is Teradata: Teradata is a relational database management system (RDBMS) that is: an open system, running on a UNIX MP-RAS or Windows server platform. capable of …
Read More »The prevalent influence of technology has resulted in a widespread use of a variety of devices such as cell phones, sensors, web API’s and …
Read More »Replication lag Typically, in our replica sets, we monitoring the replication lag, that is a measure of who far a secondary is behind the primary: …
Read More »Error : The DBSNMP user is locked after a certain period of time. Reason: An application (possibly an application in EM) is trying to login …
Read More »Description: Drop tables is such a common content of a DBA’s daily work. Drop a small table( such as less than 100 Mega Bytes ), we …
Read More »With using triggers in PostgreSQL, you can trigger another event before an event occurs (BEFORE TRIGGER). Or you can trigger another event after it …
Read More »Description: Recently, when i checked my data on two MySQL servers( version: 5.7.17 ), i found data differences between to servers, which surprised me. Because …
Read More »