How to repair and optimise MySQL databases


If you are using MySQL database a lot, it never hurts to check for any errors, repair the tables and optimize them occasionally. The post is about repairing and optimizing all MySQL Databases easily using a single query.

How to Read More →

Install chive for MySQL on CentOS/RHEL, Debian, Ubuntu


Chive is a free, open source, web-based database management tool, designed to bring joy to web developers - with easy administration, super fast UI and state of the art web technologies. If you are looking for an alternative to phpmyadmin Read More →

Install MySQL 5.5.30 on RHEL/CentOS 6 or 5


MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL, Read More →

Install RockMongo for mongodb on CentOS, RHEL, Debian, Ubuntu


If you are looking for a phpadmin like tool for mongodb, RockMongo is your best bet. It is one of the best PHP MongoDB Administrator tool available today. It lets you create database, collections and insert and fetch documents using Read More →

Basic commands mongodb show tables, views, databases, create users and more.


Everytime I have to work with a new database I struggle, specially if the database is bit different from rest of its siblings. Mongodb is a new kid in town and doesn't understand SQL one bit because its a NOSQL Read More →

Install Mongodb on CentOS, RHEL, Debian, Ubuntu


MongoDB is an open-source, document-oriented database designed for ease of development and scaling. Some of mongodb features include high performance, high availability. document-oriented, easy scalability, rich query language. Source

Install Mongodb on CentOS, RHEL, Debian, Read More →

Install Postgres 9.2 on CentOS, RHEL, Debian 6


PostgreSQL is another popular open source database which continues to grow in popularity as an alternative to MySQL database server. The latest release of postgresql is 9.2, this post helps one setup postgresql on CentOS, Debian and RHEL.

Install Postgres 9.2 Read More →

Monitor mysql instance using mytop on CentOS/RHEL, Fedora, Debian, Ubuntu


If you are a dba looking for a top like utility for a database instance which can provide you real time performance view, running threads and slow queries, you can count on mytop. Mytop is a neat little utility that Read More →

Find the database size in MySQL


MySQL is unarguably one of the most popular databases being used by top IT companies like Google and Facebook. If you are one such hotshot dba working with MySQL databases, at some point in time you may need to figure Read More →

postgresql show tables, views, databases and more.


If you work in a small shop chances are you work as a Linux plus database administrator. Even if you work for a big company where there are database administrators to look for any db related issues, having knowledge of Read More →
Back to top