Physical location of datafiles in PostgreSQL

In this article, we will discuss finding the physical location of data files for a particular database.In the logical structure, we can see different databases and tables or any other objects under it but as DBA we should also be aware of how...

Read More

Basic Operations on MySQL Users

In this article we are going to discuss about different operations on mysql user like lock, unlock, grant, revoke etc.Lock-unlockExpire-unexpiredCheck privilegesRevoke privilegesChange passwordRename user (single user, multiple user)Drop userUser list can be fetched using query mentioned below in the databaseselect user,host,authentication_string,password_expired,account_locked...

Read More

Oracle : STATISTICS_LEVEL parameter

In Oracle as we gather and view statistics though different views or tables can be controlled by instance level parameter STATISTICS_LEVEL This particular parameter has below three possible settings BASIC TYPICAL ALL The parameter controls automatic gathering of statistics at two levels  Instance statistics : statistics accumulate withing...

Read More

Transferring file from one server to another server [FTP, SFTP, SCP etc]

There are number of ways to transfer file from one server to another server, below are the few methods to to achieve the same ftp sftp scp windows software (Filehippo, WinScp , FileZilla etc) We will discuss these in details 1. FTP transfer File Transfer Protocols basically is set of rules on computer network to communicate with one another....

Read More

MongoDB : Capped Collections

There are two types of collections normal collection and capped collection In comparison to the normal collection, capped collections are created in advance and are fixed in size  Normal collections are created dynamically and...

Read More

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

In previous articles, we have learned about user creation and grants in MySQL in detail, but there are a few privileges called global privileges that are meant to be granted to DBA accounts only for example PROCESS privileges is a global privilege.  we will try to grant it to user tech_user on author database mysql>grant process...

Read More

MySQL: pid-file (process id file)

In previous articles have gone through options available with mysql_safe, one of the option is pid file i.e. process identifier file The server writes its process id into pid file when mysql services are started and removes file when stopped. The pid file is the means by which a server allows itself to be found by other processes. Location default...

Read More

Aggregation Function in MySQL

There are number of functions available in MySQL library, in this particular article we will  discuss aggregation function Aggregation function s are generally used with SELECT statements containing GROUP BY clauses, however these may be used without group by clauses as well. Below table describes aggregation functions available in MySQL...

Read More