Gentoo Archives: gentoo-user

From: Francesco Riosa <vivo@g.o>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] slotted mysql ready for testing (~arch)
Date: Wed, 01 Feb 2006 17:12:29
Message-Id: 43E0EA80.2000202@gentoo.org
In Reply to: [gentoo-user] slotted mysql ready for testing (~arch) by Francesco Riosa
1 Some of the problems reported and fixed until now:
2
3 - 'eselect set mysql 1' - wrong command order - user error.
4 = it is "eselect mysql set 1"
5
6 - running the correct eselect command gets this strange output to
7 stderr: 'find: mysql: No such file or directory'. I've got the strace
8 output, but I can't find WHERE find is being called from.
9 = fixed, app-admin/eselect-mysql-1.0.0-r1
10
11 - Same user as the last item, the /etc/mysql and /etc/init.d/mysql-500
12 symlinks were NOT created.
13 = fixed, app-admin/eselect-mysql-1.0.0-r1
14
15 - If the service name is /etc/init.d/mysql-$VER, please make it look in
16 /etc/mysql-$VER/ for it's configuration by default, instead of
17 /etc/mysql/.
18 = mysql installed files already do this, if you have a previous
19 /etc/mysql directory
20 eselect-mysql can't symlink /etc/mysql-500 to /etc/mysql, rename
21 /etc/mysql to
22 something else and run "eselect mysql set 1 " again .
23
24 - Error that shows up in building:
25
26 ...
27 Unpacking mysql-4.1.16.tar.gz to /t/portage/mysql-4.1.16-r30/work
28 Unpacking mysql-extras-20060115.tar.bz2 to /t/portage/mysql-4.1.16-r30/work
29 /usr/portage/eclass/mysql_fx.eclass: line 57: local: `,': not a valid
30 identifier
31 * using "010_all_slot-my-print-default-r1.patch"
32 ...
33 = NEED MORE INFO
34
35 Another two.
36 - innodb seems to act weird, because of this stuff
37 #GENTOO#innodb_buffer_pool_size = 16M
38 As the defaults that are actually used because of the commenting don't
39 match the current settings.
40 fixed, INCVS, to avoid reinstall edit the /etc/mysql-500/my.cnf and remove
41 every occurence of "#GENTOO#" string.
42
43 - User has a 60Gb MySQL database . They arranged 60Gb of space to try and
44 make the dump into, but even as mysqldump | bzip2 -9 >file.bz2, it didn't
45 fit into the 60Gb of space. How safe is moving the data directory?
46
47 = This is because dump are ascii data, bigger than binary tables unless
48 u have _huge_ indices.
49 switching say from dev-db/mysql-5.0.18 to dev-db/mysql-5.0.18-r30 is
50 _totally_ safe
51 do one of these two things:
52 a) stop the databases, then _move_ the data from /var/lib/mysql to
53 /var/lib/mysql-500
54 or
55 b) change "datadir" value in "/etc/mysql-500/my.cnf to" "/var/lib/mysql"
56
57
58 --
59 gentoo-user@g.o mailing list