Posts

Showing posts from October, 2006

Speed up MySQL connection

According to:

http://forums.mysql.com/read.php?24,23390,23395#msg-23395

Slow connection is mainly due to slow DNS resolve process. Other than adding a host-IP value pair in Linux /etc/hosts file, I added the following line in /etc/my.cnf :

[mysqld]
skip-name-resolve

It can definitely make your mysql connection instantaneous! The only drawback is that you can only connect to your mysql databases using IP but not host name.

Hope it helps.

Is it possible to make a backup automatically apart from doing it manually from the management server ?

Run this in crontab:

#> echo "START BACKUP" | ndb_mgm

Ref: http://archive.netbsd.se/?ml=mysql-cluster&a=2005-03&t=699920

How to disable beep sound in Ubuntu command line?

To disable beep in terminal, type the following in bash shell:

echo "set bell-style none">> ~/.inputrc

Ref: http://bamanzi.blogeden.cn/post/110848/1069