Search Results for: MySqlAdmin

How to Install and Configure mtop – Shows top mysql threads

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(…)

How MySQL uses DNS

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(…)

How to Install MySQL And Apache/PHP on Centos

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(…)

How to Install Cacti on CentOS 4.x

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(…)

How to use the SHOW STATUS command in MySQL

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>(…)

How to Install MySQL Server 5 on Ubuntu

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(…)

How to install Bugzilla under Redhat/Centos

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(…)

“Timeout error occurred trying to start MySQL Daemon.”.

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(…)

List of Basic MySQL Commands

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 syntax (clearing caches) – MySQL

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(…)

How to Install and Configure Smbind

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.(…)