on Computer Science and Programming

Posts in category Databases

MySQL optimization – 2

Dec06
2010 Written by

[client]
#password       = your_password
port            = 3306
socket          = /var/lib/mysql/mysql.sock

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
#skip-networking
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-locking
key_buffer = 128M
max_allowed_packet = 256M
table_cache =  512
sort_buffer_size = 512M
net_buffer_length = 8K
read_buffer_size = 1M
read_rnd_buffer_size = 256M
myisam_sort_buffer_size = 512M
query_cache_size= 512M
log-slow-queries = /var/log/mysqlslow.log
long_query_time = 5
max_connections = 500

##Inno DB
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
innodb_log_arch_dir = /var/lib/mysql
innodb_file_per_table
# You can set .._buffer_pool_size up to 50 – 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 1G
innodb_additional_mem_pool_size = 24M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
# Write to log but don’t flush on commit (it will be flushed every “second”)
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50
innodb_support_xa = 1
# innodb_doublewrite
innodb_fast_shutdown = 1

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# required unique id between 1 and 2^32 – 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id=1217616777

# Replication Slave (comment out master section to use this)
#master-host=<hostname>
#master-user=<username>
#master-password=<password>
#master-port=<port>

# Point the following paths to different dedicated disks
#tmpdir         = /tmp/
#log-update     = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 64M
#bdb_max_lock = 100000

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Tagged

MySQL Optimization Configuration

Dec06
2010 Written by

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#old_passwords=1

skip-locking
skip-innodb
skip-bdb

key_buffer = 512M
max_allowed_packet = 64M

max_connections=50
wait_timeout=1000

table_cache =  256
sort_buffer_size = 128M
myisam_sort_buffer_size = 128M

net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 32M

query_cache_size= 128M
thread_cache_size =64

long_query_time=5
log-slow-queries=/var/log/log-slow-queries.log

wait_timeout=15
connect_timeout=10

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
quick
max_allowed_packet=16M

Tagged

Php Singleton database connection with zend framework, database helper class for connecting and closing database connections

Apr10
2010 Leave a Comment Written by

Below if a php class that you can use to create singleton database connections with php, zend framework and mysql. Singleton design pattern ensures that there is only a single instance of the object. 

database);
			self::$connection->setFetchMode(Zend_Db::FETCH_OBJ);
		}catch(Exception $e){
			echo $e->getMessage();
		}
	}

	public static function getConnection(){

		if(self::$connected == false){
			if(self::$connection == null){
				$db = new DBHelper();
			}
			self::$connected = true;
			return self::$connection;
		}else{
			return null;
		}

	}

	public static function closeConnection($connection){
		try{
			$connection->close();
		}catch(Exception $e){
			echo $e->getMessage();
		}
	}

}
?>
Posted in Programming - Tagged ,

Current wr0k, Spring Break, exams and etc.

Mar29
2010 Leave a Comment Written by

Lately, I have been enhancing the web service that I have been working for a while. Developing web services using C#.Net is really easy and fast. I have built documentation using Doxygen for web service invokers.

Yet another project I m working on is populating data of an application and saving the results in a data warehouse. So that Pentaho will analyze the data and generate reports.

I m almost done with another project for Huge Inc, which is a Flex FTP Client.

School is in Spring break. Last Thursday I had two midterms on the same day which was a disaster. from 9.30 am to 2 pm. Certainly, the PhD program could schedule better exam dates. :-/

Writing a paper on data center network design. Interesting topic. Not easy.

Posted in Networking, Programming, Uncategorized - Tagged ,

The Cassandra Distributed Database

Mar14
2010 Leave a Comment Written by

Cassandra is a scalable distributed database. Several large companies are using Cassandra for scaling.

http://www.slideshare.net/jericevans/the-cassandra-distributed-database

Cassandra surely looks interesting and offers several advantages over conventional database management systems.

Posted in Programming, Scalability - Tagged

Objectivity new Database installation

Jan27
2010 Leave a Comment Written by

ooinstallfd -fdfilepath FullPathTo-Fdb-file -lockserverhost firat-pc -fdfilehost firat-pc databaseserver.boot

This is the command to install a federated objectivity database.

How to install mysql 5 on centos 5

Jan02
2010 Leave a Comment Written by

How to install mysql 5 on centos 5

yum install php-mysql mysql mysql-server
/sbin/chkconfig –levels 235 mysqld on
/etc/init.d/mysqld start

Posted in Linux - Tagged
Newer Entries →