Tag Archive for mysql

MySQL DML stats per table

MySQL provides a level of statistics for your INSERT, UPDATE, DELETE, REPLACE Data Manipulation Language (DML) commands using the STATUS output of various Com_ variables, however it is per server stats. I would like per table stats.

You can achieve this with tools such as MySQL Proxy and mk-query-digest, however there is actually a very simple solution that requires no additional tools.
The following 1 line Linux command (reformatted for ease of reading) gave me exactly what I wanted, and it had ZERO impact on the database.
Read more

Install MySQL 5.5.16 on Fedora 15/14, CentOS/Red Hat (RHEL) 5.6/6

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is guide, howto install or upgrade MySQL Community Server latest and greatest version 5.5.16 on Fedora 15, (14 13, 12, 11, 10, 9, 8), CentOS 5.6 and Red Hat (RHEL) 5.6/6.
Note: If you are upgrading MySQL (from earlier version), then make sure that you backup (dump and copy) your database and configs. And remember run mysql_upgrade command.
Read more

Postfix + Postfixadmin + Dovecot + SASL — CentOS

PostfixAdmin Installation:

    Download PostfixAdmin from sourceforge.net

    	tar xvfz postfixadmin_2.3.tar.gz.tar.gz -C /usr/share/
    	yum install php-imap.i686
    	/etc/init.d/httpd restart
    	vi /usr/share/postfixadmin-2.3/config.inc.php
    

    Read more

Страниц: 1 2 3 4