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 […]Read More MySQL processes slowing down host server
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 […]Read More MySQL on Mac OS X
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 ftp://ftp.postgresql.org/pub/source/v8.3.1/postgresql-8.3.1.tar.gz 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 […]Read More Start using PostgreSQL now….
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 […]Read More Sybase iSQL ASE 12.5 drive
MYSQL replication in the same box MYSQL 5.0.17 standard (SLAVE) – 10.0.0.1 MYSQL 4.1.1 standard (MASTER) – 10.0.0.2 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 = […]Read More MYSQL replication in the same box