MySQL processes slowing down host server

Site is overloading the server MySQL InnoDB database with approx 2gb data. Quite a few sleeping MySQL processes that could be the cause. Before drilling down in code I would like to make few tweaks to mysql db configuration.Reduce the MySQL wait_timeout value to 3 seconds and increasing the number of allowed connections.Apparently, persistent connections […]

MySQL on Mac OS X

MySQL on Mac OS X 10.7.3 Installation & configuration Download the mac based tar or dmg from MySQL website Add group mysql Add user mysql who’s group is mysql shell> cd /usr/local shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz shell> cd mysql shell> chown -R mysql . shell> chgrp -R mysql . shell> scripts/mysql_install_db –user=mysql shell> chown -R […]

Start using PostgreSQL now….

Spend 10 minutes and have PostgreSQL on your own lilo flavor Purpose of this article to give jump starts to install and performed basic PostgreSQL (pgsql) administrator / user job. Download binaries from this location tar -xzvf postgresql-8.3.1.tar.gz ./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su – postgres /usr/local/pgsql/bin/initdb […]

Sybase iSQL ASE 12.5 drive

This article will get you up and running with Sybase database commands. I personally refer it many times when I need  specific command. I kept it comprehensive reference material for anyone to jump start. What is difference between SQL & T-SQL? SQL- set of sqls are submitted individually to the database server. T-SQL- the batch […]

MYSQL replication in the same box

MYSQL replication in the same box   MYSQL 5.0.17 standard (SLAVE) – MYSQL 4.1.1 standard (MASTER) – MASTER running on port 3306 SLAVE running on port 3308 MASTER (my.cnf) server-id = 1 log-bin SLAVE (my.cnf) [mysqld] server-id = 2 master-host = localhost master-user = root master-password = mysql master-port = 3306 replicate-do-db = […]