Shows the MySQL commands consuming the greatest time. By default, only non-sleeping threads are shown, the –idle option shows idle threads. While running several keys will affect the operation of mtop. Hitting h or ? will show the available options. Normally, run as a console program this will allow you to see errant or badly [...]

When a new threads connects to mysqld, mysqld will span a new thread to handle the request. This thread will first check if the hostname is in the hostname cache. If not the thread will call gethostbyaddr_r() and gethostbyname_r() to resolve the hostname. If the operating system doesn’t support the above thread-safe calls, the thread [...]

We can install MySQL and Apache/PHP (Apache and PHP are needed by phpMyAdmin) with a single command: yum install mysql mysql-server httpd php php-mysql php-mbstring Then we create the system startup links for MySQL and Apache (so that both start automatically whenever the system boots) and start both services: chkconfig –levels 235 mysqld on/etc/init.d/mysqld start [...]

This howto describes how to install and configure Cacti quickly on a CentOS server. Cacti packages are available from the RPMforge repository. Read this for information about the RPMForge repository. But beware, some repositories do not mix well. The rest of this HOWTO assumed that your system is set up to use the RPMforge repository. For those who [...]

SHOW STATUS provides server status information. This information also can be obtained using the mysqladmin extended-status command. The LIKE clause, if present, indicates which variable names to match. Partial output is shown here. The list of names and values may be different for your server. The meaning of each variable is given in Section 5.1.7, “Server Status Variables”. mysql> [...]

Installing MySQL 5 Server on Ubuntu is a quick and easy process. It almost feels like it should be more difficult. Open a terminal window, and use the following command: sudo apt-get install mysql-server If you are running PHP you will also need to install the php module for mysql 5: sudo apt-get install php5-mysql To [...]

“MySQL Server Has Gone Away “ A common error for almost all the developers and DB Admins, spend lots of  time to solve this problem, This is an unusual behavior of MySQL server and can happen in many circumstances.  Last few days i was searching on the net as we got this problem when we run Our Cron [...]

Bugzilla is a Web-based general-purpose bugtracker and testing tool originally developed and used by the Mozilla project, and licensed under the Mozilla Public License. Released as open source software by Netscape Communications in 1998, it has been adopted by a variety of organizations for use as a defect tracker for both free software and proprietary [...]

You may notice that you can start MySQL correctly only once under Fedora Core 1. All subsequent attempts result in the message “Timeout error occurred trying to start MySQL Daemon.”. [root@bigboy tmp]# /etc/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] [root@bigboy tmp]# This is caused by the MySQL startup script [...]

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. [...]

FLUSH flush_option [,flush_option] You should use the FLUSH command if you want to clear some of the internal caches MySQL uses. To execute FLUSH, you must have the reload privilege.flush_option can be any of the following:   HOSTS Empties the host cache tables. You should flush the host tables if some of your hosts change [...]

Smbind is a PHP-based tool for managing DNS zones for BIND via the web. Supports per-user administration of zones, error checking, and a PEAR DB database backend. Demo and screenshots available. During normal operation, smbind manipulates it’s zone and record data in a PEAR DB database backend which is managed using a PHP web interface. [...]

A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port number. A Unix socket file connection is faster than TCP/IP, but can be used only when connecting [...]

Here are some ideas, how you can monitor the database performance of your MySQL installation. Monitoring is always an iterative and continuous process. You need to learn what patterns are OK for your database and what are the signs of slight problems or even dangerous situations. Below are the main items you can use to [...]

PowerDNS is a versatile DNS server, written in C++ and licensed under the GPL. It runs on most Unix derivatives and on Microsoft Windows. PowerDNS features a large number of different backends ranging from simple BIND style zonefiles to relational databases and load balancing/failover algorithms. A DNS recursor is also included as a separate program. [...]