Date: Sun, 30 Nov 2003 23:27:55 +0100 From: Melvyn Sopacua <freebsd-questions@webteckies.org> To: "'FreeBSD-questions'" <questions@FreeBSD.ORG> Cc: DG <david@fielden.com.au> Subject: Re: MySQL question... Message-ID: <200311302327.56533.freebsd-questions@webteckies.org> In-Reply-To: <002b01c3b78c$f37a2a40$5401a8c0@borg.fielden.com.au> References: <002b01c3b78c$f37a2a40$5401a8c0@borg.fielden.com.au>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] On Sunday 30 November 2003 22:57, DG wrote: > > -----Original Message----- > > From: owner-freebsd-questions@freebsd.org > > [mailto:owner-freebsd-questions@freebsd.org]On Behalf Of > > Melvyn Sopacua > > Sent: Monday, 1 December 2003 3:54 AM > > To: FreeBSD-questions > > Cc: Xpression > > Subject: Re: MySQL question... > > <snip> > > > All databases will go under /var/db/mysql and the quick and > > dirty answer is: > > mysql -e "GRANT ALL ON $dbname.* TO '$dbuser'@'localhost' > > IDENTIFIED BY > > '$userpasswd'" > > > > -- > > Melvyn > > Something I've wondered is why the default location for the MySQL databasi > is /var/db/mysql? Yes /var/db seems to make sense, but most /var > filesystems would be fairly small. By tradition /var is for 'variable data'. By tradition, /var has been used for mail and news and as such do not require large partitions unless you run binary newsgroups. Therefore most /var partitions are small. However - I agree that the chosen default is not up-to-par with the use of MySQL, especially since you would take smaller fragment size for a /var partition if you have a busy mail- or newsserver and that certainly won't benefit MySQL. > Is it generally common practice to create a symbolic link to somewhere on, > say, /usr to store the databasi? If you know beforehand that you're going to run a mysql database with large databases (or use innodb which will never shrink!), than it's wise to create a large partition /var/db/mysql on boot. Otherwise you can set the DB_DIR variable during installation of MySQL to f.e.: /usr/local/var/mysql which is not unheard of. On my workstation I use /usr/db/mysql, but on my workstation I also have a 15G /usr partition. Whichever you choose, it's best to choose a DB_DIR ending in /mysql, so you can always decide to add another disk and mount that as $DB_DIR. By the way: don't underestimate the size of the binary logs, especially with large inserts. -- Melvyn ======================================================= FreeBSD sarevok.webteckies.org 5.2-BETA FreeBSD 5.2-BETA #1: Sat Nov 29 00:15:33 CET 2003 root@sarevok.webteckies.org:/usr/obj/usr/src/sys/ SAREVOK_NOFW_DBG i386 ======================================================= [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQA/ym7sOv9JNmfFN5URAhcrAJ48sSaZUIxZGpsP1M9i3pC/IiSSpACeIJ7Z jP80c6oOoVmR84TJ2f+VCpA= =LC9C -----END PGP SIGNATURE-----help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200311302327.56533.freebsd-questions>