Archive : MySQL

Innotop is an excellent command line program, similar to ‘top command‘ to monitor local and remote MySQL servers running under InnoDB engine. Innotop comes with many features and different types of modes/options, which helps to monitor different aspects of MySQL performance and also helps database administrator to find out what’s wrong going with MySQL server. For example, Innotop helps in monitoring mysql replication status, user...

This howto guide explains you’ll how to install Apache Server with latest MySQL 5.5.30 and PHP 5.4.12 versions with php required following modules on RHEL 6.4/6.3/6.2/6.1/6.0/5.9/5.8/5.6, CentOS 6.4/6.3/6.2/6.1/6.0/5.9/5.8/5.6 and Fedora 12,13,14,15,16,17,18 systems using Remi repository via Yum tool.Install Apache MySQL PHPWhat is Apache? Apache is an open source freely available HTTP web server that runs on most UNIX-based operating systems...

MySQL administration via command-line in Linux is much difficult job for any newbie system administrator or database administrator, because it contains numerous commands which we cannot remember in our daily life. To make MySQL administration much easier we’re introducing a newly released web based MySQL administration tool called PhpMyAdmin 3.5.7, with the help of this tool you can control and manage your database administration via browser...

This how-to guide is to install or upgrade your MySQL version on RHEL/CentOS 6-5 and Fedora 18,17/16/15/14/13/12 using Remi repository via YUM utility. But before moving into further steps let’s understand little bit about MySQL. What is MySQL? MySQL is an open source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any single server by providing multi-user...

This howto guide explains more deeply on how to install LEMP (Linux, Nginx, MySQL, PHP) on pre-installed Linux servers and installation instructions can be used on various Linux distribution such as RHEL 6.2/6.1/6/5.8, CentOS 6.2/6.1/6/5.8 and Fedora 12,13,14,15,16,17,18 servers using Remi and Nginx repositories with YUM command. In this guide we use latest MySQL 5.5.29 and PHP 5.4.11 versions with PHP-FPM modules with Nginx. So, before moving further...

Cherokee is a cross-platform feature rich and flexible, light-weight and high-performance open source Web Server/Reverse proxy server that was released under GNU (General Public License). The Cherokee project was developed using C language and was made available for all major Operating System like Linux, Mac OS X and Windows. One of the main feature of Cherokee web server is it offers graphical admin interface from where you can manage web server...

SQL Buddy is one of my all time favorite tool, that I’ve use daily for accessing and managing MySQL administration of servers. SQL Buddy is an open source web based tool was written in PHP language that intended to manage SQLite and MySQL administration via web browsers like Firefox, Chrome, Safari, Opera and IE+ (Internet Explorer). SQL Buddy is an simple, lightweight and super fast application that offers a well-designed interface with a comprehensive...

Mytop is an open source and free monitoring program for MySQL databases was written by Jeremy Zawodny using Perl language. It is much similar in look and feel of the most famous Linux system monitoring tool called top. Mytop program provides a command-line shell interface to monitor real time MySQL threads, queries per second, process list and performance of databases and gives a idea for the database administrator to better optimize the server to...