mysql structure

[Elan Ruusamäe]

hi

is there reason of such complicated deep directory structure for mysql?

$ cat /etc/mysql/clusters.conf
mysql.conf=/www/mysql

so the data has to be in subdir mysqldb/db/DBNAME, ie
/www/mysql/mysqldb/db/mysql/

why can't it be simple, ie, /www/mysql
ok i could understand the 'db' subdir, to have pid,socket,config separately 
from data, but now there's one more subdir.

ps: what about having mysql sockets in /var/run/mysql, so if i want allow user 
connecting to mysql via socket, i don't have to give it access to mysql 
clusters directory

ie, i could have
# la -d /www/mysql
drwx------  4 mysql mysql 27 Dec  3 11:39 /www/mysql//

and
# la -d /var/run/mysql/{,ap.sock}
drwxr-xr-x  2 mysql root  20 Dec  3 12:00 /var/run/mysql//
srwxrwxrwx  1 mysql mysql  0 Dec  3 12:00 /var/run/mysql/ap.sock=


-- 
glen