LinuxForum.Fans
Тема

MySQL

Автор: zenon 19 сообщений 5426 просмотров
#227366

Вчера не глядя обновился, пришла mysql 5.5.20, плин намаялся с ней, демон стартовать перестал, ну да ладно решил снести и восстановить из бэкапа..., но скрипт mysql_install_db напрочь отсутствовал, .... как завел уже запутался, но наверное так:

text
emerge -av mysql mysql++ mysqltcl mysqltuner

Хотя вроде достаточно mysql всегда было поставить.
Так вот сейчас в портеже примерно так:

text

[i] dev-db/mysql++
     Available versions:  
    (0)    2.2.2-r1 2.3.2
    (3)    (~)3.0.5 (~)3.0.9
     Installed versions:  3.0.9(3)(20:47:31 05.02.2012)
     Homepage:            http://tangentsoft.net/mysql++/
     Description:         C++ API interface to the MySQL database

[i] dev-db/mysql Available versions: 4.0.27-r1 4.1.22-r1 5.0.91 (~)5.0.92 5.1.51 (~)5.1.52 (~)5.1.52-r1 (~)5.1.53 5.1.56 (~)5.1.56-r1 (~)5.1.57 (~)5.1.58-r1 (~)5.1.59 5.1.61 (~)5.5.19 (~)5.5.20 {berkdb big-tables cluster +community debug embedded extraengine latin1 max-idx-128 minimal pbxt (+)perl profiling raid selinux ssl static systemtap test xtradb} Installed versions: 5.5.20(20:47:01 05.02.2012)(berkdb community perl ssl -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -profiling -selinux -static -systemtap -test) Homepage: http://www.mysql.com/ Description: A fast, multi-threaded, multi-user SQL database server.

[i] dev-db/mysql-init-scripts Available versions: 1.2 2.0_pre1-r2 Installed versions: 2.0_pre1-r2(16:48:30 05.02.2012) Homepage: http://www.gentoo.org/ Description: Gentoo MySQL init scripts.

* dev-db/mysql-super-smack Available versions: *1.2 1.3-r2 {(+)mysql postgres} Homepage: http://vegan.net/tony/supersmack/ Description: MySQL Super Smack is a benchmarking, stress testing, and load generation tool for MySQL & PostGreSQL.

[i] dev-db/mysql-workbench Available versions: (~)5.2.34 5.2.35 (~)5.2.36 (~)5.2.37 {debug doc nls readline static-libs} Installed versions: 5.2.37(21:01:36 05.02.2012)(nls -debug -doc -static-libs) Homepage: http://dev.mysql.com/workbench/ Description: MySQL Workbench

[i] dev-db/mysqltuner Available versions: 1.1.1 1.2.0 Installed versions: 1.2.0(20:47:41 05.02.2012) Homepage: http://www.mysqltuner.com Description: MySQLTuner is a high-performance MySQL tuning script

[i] dev-perl/DBD-mysql Available versions: 4.01.7 (~)4.20.0 {embedded} Installed versions: 4.20.0(16:52:47 05.02.2012)(-embedded) Homepage: http://search.cpan.org/dist/DBD-mysql/ Description: The Perl DBD:mysql Module

* dev-python/mysql-python Available versions: 1.2.3 Homepage: http://sourceforge.net/projects/mysql-python/ http://pypi.python.org/pypi/MySQL-python Description: Python interface to MySQL

[i] dev-ruby/mysql2 Available versions: (0.2) (~)0.2.7 (~)0.2.13 (~)0.2.17 (~)0.2.18 (0.3) (~)0.3.2 (~)0.3.6 (~)0.3.7 (~)0.3.11 {elibc_FreeBSD ruby_targets_ree18 ruby_targets_ruby18 ruby_targets_ruby19 test} Installed versions: 0.3.11(0.3)(21:01:51 05.02.2012)(ruby_targets_ruby18 -elibc_FreeBSD -ruby_targets_ree18 -ruby_targets_ruby19 -test) Homepage: https://github.com/brianmario/mysql2 Description: A modern, simple and very fast Mysql library for Ruby - binding to libmysql.

[i] dev-tcltk/mysqltcl Available versions: *2.40 (~)2.50 3.05 Installed versions: 3.05(20:47:38 05.02.2012) Homepage: http://www.xdobry.de/mysqltcl/ Description: TCL MySQL Interface

* sec-policy/selinux-mysql Available versions: [M]2.20110726-r1 Homepage: http://www.gentoo.org/proj/en/hardened/selinux/ Description: SELinux policy for mysql

[i] virtual/mysql Available versions: 4.0 4.1 5.0 5.1 (~)5.2 (~)5.3 (~)5.5 {embedded minimal static} Installed versions: 5.5(20:47:08 05.02.2012)(-embedded -minimal -static) Description: Virtual for MySQL client or database

И что есть mysqltcl, mysql++ и mysql2?

#227368
newzenon написал:
И что есть mysqltcl, mysql++ и mysql2?

ты что, совсем обленился дескрипшн прочесть? или по ссылкам пройти?
ведь белым по чёрному написано:
mysql++ - библиотека биндингов для С++
mysqltcl - библиотека биндингов для tcl
mysql2 - библиотека биндингов для ruby

#227369
newzenon написал:
И что есть mysqltcl, mysql++ и mysql2?

Description: TCL MySQL Interface
Description: C++ API interface to the MySQL database
Description: A modern, simple and very fast Mysql library for Ruby - binding to libmysql.
...или я не правильно понял вопрос?

#227372
newzenon написал:
Вчера не глядя обновился, пришла mysql 5.5.20,

У меня эта версия hard-masked oO

#227374

Fat-Zer, не кричи. Я просто потерял вчера mysql_install_db и забодался понимать почему его нет.

#227377

вроде как это баг

#227541
Lupo Alberto написал:
[quote=newzenon]Вчера не глядя обновился, пришла mysql 5.5.20,

У меня эта версия hard-masked oO[/quote]
Да, в Funtoo актуальная 5.5.16, хотя тоже вроде ~amd64, тестинг gentoo и funtoo разные...

#227543

newzenon,

text
gentoo-laptop ~lupo # uname -a                                                                                        [gentoo-laptop][12:01]
Linux gentoo-laptop 3.2.2-funtoo-r0a #1 Thu Feb 2 21:40:28 FET 2012 i686 Genuine Intel(R) CPU T1350 @ 1.86GHz GenuineIntel GNU/Linux
gentoo-laptop ~lupo # eix -e mysql                                                                                    [gentoo-laptop][12:24]
[i] dev-db/mysql
     Available versions:  [M]4.0.27-r1 [M]4.1.22-r1 [M]5.0.91 [M](~)5.0.92 [M]5.1.51 [M](~)5.1.52 [M](~)5.1.52-r1 [M](~)5.1.53 5.1.56 (~)5.1.56-r1 (~)5.1.57 (~)5.1.58-r1 (~)5.1.59 (~)5.1.61 [M](~)5.5.19 [M](~)5.5.20 {berkdb big-tables cluster +community debug embedded extraengine latin1 max-idx-128 minimal pbxt (+)perl profiling raid selinux ssl static systemtap test xtradb}
     Installed versions:  5.1.61(23:57:51 31.01.2012)(berkdb community perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -pbxt -profiling -selinux -static -test -xtradb)
     Homepage:            http://www.mysql.com/
     Description:         A fast, multi-threaded, multi-user SQL database server.

[i] virtual/mysql Available versions: [M]4.0 [M]4.1 [M]5.0 5.1 [M](~)5.2 [M](~)5.3 [M](~)5.5 {embedded minimal static} Installed versions: 5.1(14:06:04 08.08.2011)(-embedded -minimal -static) Description: Virtual for MySQL client or database

Found 2 matches.

text
gentoo-home lupo # uname -a                                                                                             [gentoo-home][12:26]
Linux gentoo-home 3.2.2-gentoo-r0a #1 SMP PREEMPT Mon Feb 6 06:49:30 FET 2012 x86_64 Pentium(R) Dual-Core CPU E6500 @ 2.93GHz GenuineIntel GNU/Linux
gentoo-home lupo # eix -e mysql                                                                                         [gentoo-home][12:26]
[u] dev-db/mysql
     Available versions:  [M]*3.23.58-r1[2] [M]4.0.27-r1 [M]4.0.27-r1[2] [M]4.1.22-r1 [M]4.1.22-r1[2] [M]5.0.54[2] [M]5.0.70-r1[2] [M](~)5.0.72[2] [M](~)5.0.72-r1[2] [M](~)5.0.76[2] [M](~)5.0.76-r1[2] [M](~)5.0.83[2] [M](~)5.0.84[2] [M]5.0.84-r1[2] [M](~)5.0.87[2] [M](~)5.0.88[2] [M](~)5.0.90[2] [M](~)5.0.90-r1[2] [M]5.0.90-r2[2] [M]5.0.91 [M]5.0.91[2] [M](~)5.0.91[3] [M](~)5.0.92 [M](~)5.1.39-r1[2] [M](~)5.1.44[2] [M](~)5.1.44-r1[2] [M](~)5.1.44-r2[2] [M](~)5.1.44-r3[2] [M](~)5.1.45[2] [M](~)5.1.45-r1[2] [M](~)5.1.46[2] [M](~)5.1.49[2] [M](~)5.1.49-r1[2] [M]5.1.50[2] [M]5.1.50-r1[2] [M](~)5.1.50-r2[3] [M](~)5.1.50-r3[3] [M]5.1.51 [M]5.1.51[2] [M](~)5.1.51[3] [M](~)5.1.51-r1[3] [M](~)5.1.52 [M](~)5.1.52[2] [M](~)5.1.52-r1 [M](~)5.1.52-r1[2] [M](~)5.1.52-r2[3] [M](~)5.1.53 [M](~)5.1.53[2] [M](~)5.1.53-r1[3] 5.1.56 (~)5.1.56-r1 (~)5.1.57 (~)5.1.58-r1 (~)5.1.59 5.1.61 (~)5.4.3_beta[1] (~)5.4.3_beta[2] [M](~)5.5.1_alpha_pre2[2] [M](~)5.5.1[1] [M](~)5.5.4_alpha_pre3[3] [M](~)5.5.19 [M](~)5.5.20 {berkdb big-tables cluster +community debug embedded extraengine innodb latin1 lib32 max-idx-128 minimal pbxt (+)perl profiling raid readline selinux ssl static systemtap tcpd test xtradb}
     Installed versions:  5.1.61(10:50:56 06.02.2012)(berkdb community perl ssl -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -pbxt -profiling -selinux -static -test -xtradb)
     Homepage:            http://www.mysql.com/
     Description:         A fast, multi-threaded, multi-user SQL database server.

[u] virtual/mysql Available versions: [M]4.0 [M]4.0[2] [M]4.1 [M]4.1[2] [M]5.0 [M]5.0[2] [M](~)5.0[3] 5.1 5.1[2] (~)5.1[3] [M](~)5.2 [M](~)5.2[3] [M](~)5.3 (~)5.4[2] (~)5.4[3] [M](~)5.5 [M](~)5.5[2] [M](~)5.5[3] {embedded lib32 minimal static} Installed versions: 5.1(20:59:04 25.06.2011)(-embedded -minimal -static) Description: Virtual for MySQL client or database

Found 2 matches.

#227546

Lupo Alberto, ACCEPT_KEYWORDS="~amd64"?

#227551

newzenon, в первом случае ACCEPT_KEYWORDS="~x86", во втором — ACCEPT_KEYWORDS="~amd64".
Разве при установке не сообщалось, что версия hard-masked?
[console]gentoo-home lupo # emerge -pv '=dev-db/mysql-5.5.20' [gentoo-home][12:26]

These are the packages that would be merged, in order:

Calculating dependencies... done!
[ebuild U #] dev-db/mysql-5.5.20 [5.1.61] USE="berkdb community perl ssl -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -profiling (-selinux) -static -systemtap% -test (-big-tables%) (-pbxt%) (-xtradb%)" 23,737 kB
[ebuild U #] virtual/mysql-5.5 [5.1] USE="-embedded -minimal -static" 0 kB

Total: 2 packages (2 upgrades), Size of downloads: 23,737 kB

The following mask changes are necessary to proceed:
#required by =dev-db/mysql-5.5.20 (argument)
# /usr/portage/profiles/package.mask:
# Jorge Manuel B. S. Vicetto <jmbsvicetto@gentoo.org> (28 Jul 2011)
# A new update of the mysql / mariadb mask
# Robin H. Johnson <robbat2@gentoo.org> (01 Feb 2010)
# Mask 5.5/6.0 series that are alpha and and crazy experimental.
# Mask 5.2/5.3 virtual that exists in the overlay as well (it is MariaDB only)
=dev-db/mysql-5.5.20
#required by media-libs/gmyth-0.7, required by media-plugins/gst-plugins-mythtv-0.10.22, required by media-plugins/gst-plugins-meta-0.10-r7[mythtv], required by media-libs/phonon-gstreamer-4.5.1, required by media-libs/phonon-4.6.0-r1[gstreamer], required by kde-base/phonon-kde-4.8.0, required by kde-base/kdebase-startkde-4.8.0, required by @selected, required by @world (argument)
# /usr/portage/profiles/package.mask:
# Jorge Manuel B. S. Vicetto <jmbsvicetto@gentoo.org> (28 Jul 2011)
# A new update of the mysql / mariadb mask
# Robin H. Johnson <robbat2@gentoo.org> (01 Feb 2010)
# Mask 5.5/6.0 series that are alpha and and crazy experimental.
# Mask 5.2/5.3 virtual that exists in the overlay as well (it is MariaDB only)
=virtual/mysql-5.5

NOTE: The --autounmask-keep-masks option will prevent emerge
from creating package.unmask or ** keyword changes.[/console]

#227552

newzenon, что у вас за профиль?

#227558
text
$ eselect profile list
Available profile symlink targets:
  [1]   default/linux/amd64/10.0
  [2]   default/linux/amd64/10.0/selinux
  [3]   default/linux/amd64/10.0/desktop *
  [4]   default/linux/amd64/10.0/desktop/gnome
  [5]   default/linux/amd64/10.0/desktop/kde
  [6]   default/linux/amd64/10.0/developer
  [7]   default/linux/amd64/10.0/no-multilib
  [8]   default/linux/amd64/10.0/server
  [9]   hardened/linux/amd64
  [10]  hardened/linux/amd64/selinux
  [11]  hardened/linux/amd64/no-multilib
  [12]  hardened/linux/amd64/no-multilib/selinux
$ uname -a
Linux ztux 3.1.6-zen+ #1 ZEN SMP PREEMPT Sat Dec 31 23:16:57 MSK 2011 x86_64 AMD Phenom(tm) II X4 945 Processor AuthenticAMD GNU/Linux
text
$ eix --installed mysql
[i] dev-db/mysql++
     Available versions:  
    (0)    2.2.2-r1 2.3.2
    (3)    (~)3.0.5 (~)3.0.9
     Installed versions:  3.0.9(3)(20:47:31 05.02.2012)
     Homepage:            http://tangentsoft.net/mysql++/
     Description:         C++ API interface to the MySQL database

[i] dev-db/mysql Available versions: 4.0.27-r1 4.1.22-r1 5.0.91 (~)5.0.92 5.1.51 (~)5.1.52 (~)5.1.52-r1 (~)5.1.53 5.1.56 (~)5.1.56-r1 (~)5.1.57 (~)5.1.58-r1 (~)5.1.59 5.1.61 (~)5.5.19 (~)5.5.20 {berkdb big-tables cluster +community debug embedded extraengine latin1 max-idx-128 minimal pbxt (+)perl profiling raid selinux ssl static systemtap test xtradb} Installed versions: 5.5.20(20:47:01 05.02.2012)(berkdb community perl ssl -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal -profiling -selinux -static -systemtap -test) Homepage: http://www.mysql.com/ Description: A fast, multi-threaded, multi-user SQL database server.

[i] dev-db/mysql-init-scripts Available versions: 1.2 2.0_pre1-r2 Installed versions: 2.0_pre1-r2(16:48:30 05.02.2012) Homepage: http://www.gentoo.org/ Description: Gentoo MySQL init scripts.

[i] dev-db/mysql-workbench Available versions: (~)5.2.34 5.2.35 (~)5.2.36 (~)5.2.37 {debug doc nls readline static-libs} Installed versions: 5.2.37(21:01:36 05.02.2012)(nls -debug -doc -static-libs) Homepage: http://dev.mysql.com/workbench/ Description: MySQL Workbench

[i] dev-db/mysqltuner Available versions: 1.1.1 1.2.0 Installed versions: 1.2.0(20:47:41 05.02.2012) Homepage: http://www.mysqltuner.com Description: MySQLTuner is a high-performance MySQL tuning script

[i] dev-perl/DBD-mysql Available versions: 4.01.7 (~)4.20.0 {embedded} Installed versions: 4.20.0(16:52:47 05.02.2012)(-embedded) Homepage: http://search.cpan.org/dist/DBD-mysql/ Description: The Perl DBD:mysql Module

[i] dev-ruby/mysql2 Available versions: (0.2) (~)0.2.7 (~)0.2.13 (~)0.2.17 (~)0.2.18 (0.3) (~)0.3.2 (~)0.3.6 (~)0.3.7 (~)0.3.11 {elibc_FreeBSD ruby_targets_ree18 ruby_targets_ruby18 ruby_targets_ruby19 test} Installed versions: 0.3.11(0.3)(21:01:51 05.02.2012)(ruby_targets_ruby18 -elibc_FreeBSD -ruby_targets_ree18 -ruby_targets_ruby19 -test) Homepage: https://github.com/brianmario/mysql2 Description: A modern, simple and very fast Mysql library for Ruby - binding to libmysql.

[i] dev-tcltk/mysqltcl Available versions: *2.40 (~)2.50 3.05 Installed versions: 3.05(20:47:38 05.02.2012) Homepage: http://www.xdobry.de/mysqltcl/ Description: TCL MySQL Interface

[i] virtual/mysql Available versions: 4.0 4.1 5.0 5.1 (~)5.2 (~)5.3 (~)5.5 {embedded minimal static} Installed versions: 5.5(20:47:08 05.02.2012)(-embedded -minimal -static) Description: Virtual for MySQL client or database

Found 9 matches.

text
$ cat /etc/make.conf
ACCEPT_KEYWORDS="~amd64"
CHOST="x86_64-pc-linux-gnu"
CFLAGS="-march=amdfam10 -O2 -pipe"
CXXFLAGS="${CFLAGS}"
MAKEOPTS="-j5"
CC=gcc
CXX=g++
AUTOCLEAN="yes"
PORTAGE_ELOG_CLASSES="warn error log qa"
PORTAGE_ELOG_SYSTEM="save"
FEATURES="parallel-fetch userfetch buildsyspkg candy metadata-transfer sandbox"
LINGUAS="ru en"
VIDEO_CARDS="nvidia" #nv vdpau  # vesa nouveau fbdev v4l
INPUT_DEVICES="evdev keyboard mouse"
ACCEPT_LICENSE="*"

EMERGE_DEFAULT_OPTS="--verbose --keep-going --jobs=1 --backtrack=30 --with-bdeps=y"

MMEDIA="alsa audio v4l v4l1 v4l2 v4l3 mpg123 vdpau mac mad vidix flac faac mp3 m3u mp4 xvid x264 aac dvd win32codecs gstreamer ffmpeg ogg vorbis matroska xvfb wav sip nv nvidia xv xvid real"

USE="unicode utf8 ${MMEDIA} \ xinerama aware pear bash-completion zsh-completion -gdbm \ opengl udev dbus locale jpeg jpeg2k gif tiff png svg python \ zsh man-db real minizip hardened cleartype type1 nano sqlite \ ntfs fat ext4 e2fsprogs btrfs-progs reiserfsprogs reiser4progs ntfsprogs dosfstools \ 3dnowext 3dnow bash-completion xtables-addons iptables l7-protocols -bluetooth \ -dirac -hal -ipv6 -httpd-php -phpmyadmin -apache2 -semantic-desktop -networkmanager \ jfsutils app-misc/mc X acpi alsa -introspection"

XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip \ fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac \ delude chaos account checksum dnetmap echo gradm"

NGINX_MODULES_HTTP="access auth_basic autoindex browser charset empty_gif fastcgi geo \ gzip limit_req limit_zone map memcached proxy referer rewrite scgi \ split_clients ssi upstream_ip_hash userid uwsgi addition cache_purge \ dav degradation flv geoip gzip_static headers_more image_filter \ perl push random_index realip secure_link slowfs_cache \ stub_status sub upload upload_progress xslt mp4" NGINX_MODULES_MAIL="imap pop3 smtp"

PATCH_OVERLAY=/etc/portage/autopatch GENTOO_MIRRORS="http://mirror2.corbina.ru/gentoo-distfiles/ http://mirror.yandex.ru/gentoo-distfiles/ http://gentoo.bloodhost.ru/"

# source /var/lib/layman/make.conf

QEMU_SOFTMMU_TARGETS="x86_64 arm i386" QEMU_USER_TARGETS="arm i386 x86_64"

#227560

newzenon, при установке опцию --autounmask-keep-masks случайно не использовали?

#227561
Lupo Alberto написал:
newzenon, при установке опцию --autounmask-keep-masks случайно не использовали?

Нет.

#227562

В /etc/portage/{package.keywords,unmask} никаких изменений не делали?

#227565
text
$ cat /etc/portage/package.keywords
x11-drivers/nvidia-drivers
sys-boot/grub:2

$ cat /etc/portage/package.unmask sys-kernel/zen-sources sys-boot/grub:2

$ ls /etc/portage autopatch/ modules package.mask package.use savedconfig/ bin/ package.keywords package.unmask postsync.d/

#227569

Кстати почему-то в zsh не запускается конфигуратор мускула:
[console]$ emerge --config =dev-db/mysql-5.5.20
zsh: dev-db/mysql-5.5.20 not found
$ bash
john # emerge --config =dev-db/mysql-5.5.20


Configuring pkg...

* You have already a MySQL database in place.
* (///var/lib/mysql/*)
[/console]

#227763

В zsh надо так:
emerge --config '=dev-db/mysql-5.5.20'

#227809
angry_vincent написал:
В zsh надо так:
emerge --config '=dev-db/mysql-5.5.20'

Спс. взял на земетку.

Войдите или зарегистрируйтесь, чтобы ответить.