Top 10 SQL Performance Tips I

mysql Top 10 SQL Performance Tips IToday Google show me interesting link :

Top 10 SQL Performance Tips – MySQL Forge

Right now it’s consist of 84 tips, I can understand some of them but many I don’t know what it means icon smile Top 10 SQL Performance Tips I

one of them :

“partition your database when you have real data”

Hmm, I’m totally agree

I have to mysql server that serve almost 2000 account (it’s huge for me)

By seperate the data directory, I can optimize input/output process, maintenance HD etc.

By doing symlink to special partition in unix server all hard work working seamlesly.

-bash-2.05b$ cd /var/db
-bash-2.05b$ ls -l
total 26118
drwx—— 2 operator operator 512 Nov 21 11:44 entropy
drwx—— 2 root wheel 512 Jan 11 2004 ipf
-r–r–r– 1 nobody wheel 12771235 Nov 18 04:30 locate.database
-rw-r–r– 1 root wheel 153183 Aug 23 17:52 mergemaster.mtree
-rw-r–r– 1 root wheel 0 Oct 27 2004 mountdtab
lrwxr-xr-x 1 root wheel 15 Aug 20 11:49 mysql -> /data2/db/mysql
drwxr-xr-x 3 nobody nobody 512 Feb 2 2005 ntop
-rw-r–r– 1 root wheel 13708288 Sep 5 06:55 pflog.db
drwxr-xr-x 133 root wheel 4096 Nov 18 08:56 pkg
-rw-r–r– 1 root wheel 9 Jan 11 2004 port.mkversion
drwxr-xr-x 28 root wheel 512 Nov 1 07:22 ports
drwxr-xr-x 2 root wheel 512 Oct 30 2005 portsnap

mysql folder symlink to /data2/db/mysql