Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  Hi guys, Today I want to talk about performance issues on MongoDB. As a dba you may informed by users or developers that the …

MySQL Workbench Workbench is the MySQL official GUI tool to access the MySQL database engine. The tool is very user friendly and a DBA does …

Sysaux tablespace is an auxiliary tablespace to the SYSTEM tablespace. If SYSAUX tablespace becomes unusable database functionality will remain operational. Occupants of the SYSAUX tablespace …

  Yesterday in one of our mongodb databases developer asked for unshard a sharded collection. Yes it is possible to unshard a sharded collection but …

  Before restoring database dumps to new servers we need to install MongoDB on each system. Step 1: Installation: [crayon-677f388eb7bcd251273988/]   inside it: [crayon-677f388eb7bd1430647559/] [crayon-677f388eb7bd2865868998/] …

  In sharded replicas before backup process you need to disable balancer and when backup finishes you need to enable the balancer. This process doesn’t …

  In MongoDB we can take backups with database dumps or filesystem snapshots. In large databases it is recommended to use file system snapshots rather …

  You can login to a remote Linux server without entering password in 3 simple steps using ssky-keygen and ssh-copy-id as explained in this article. …

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 …

  1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-677f388eb8822436773820/] 3.dum tran with truncate only if still …