GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

percona 5.6 - ubuntu 12.04.03 problem

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • percona 5.6 - ubuntu 12.04.03 problem

    Hi
    I installed percona 5.6 in Ubuntu 12.04.03 and generated my.cnf for 5.6 verseion but it seems that it generated wrong data, wrong point to mysql.sock and mysql.pid i changed it to /var/run/mysqld/mysql.sock and /var/run/mysqld/mysql.pid and it started, but i don't know if it is normal that when i list processes it showed me mysql_safe? Why?

    ​ps aux|grep mysql
    root 4464 0.1 0.0 2240 624 pts/0 S 11:55 0:00 /bin/sh /usr/bin/mysqld_safe
    mysql 4909 4.8 32.5 1924124 669796 pts/0 Sl 11:55 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
    root 5061 0.0 0.0 4392 832 pts/0 S+ 11:55 0:00 grep --color=auto mysql


    on other boxes when i have got mysql i got only mysqld
    ps aux|grep mysql
    mysql 7451 0.0 4.1 887312 63372 ? Ssl Oct09 7:54 /usr/sbin/mysqld
    root 17534 0.0 0.0 9452 944 pts/0 S+ 13:55 0:00 grep --color=auto mysql

    This problem is annoying because i tried to install percona 5.6 on ubuntu 13.04 and when it happened i installed 12.04 and thre is the same bug and can't start mysql daemon unlil change to properly sock,pid, but problem still happen i gues because there are mysql_safe running (for what)?

    I installed percona in this way, but change do variables from 5.5 to 5.6

    http://www.percona.com/doc/percona-s.../apt_repo.html



    I am trying percona on XEN box
    Can you help?

  • #2
    Hi,

    By default Percona Server 5.6 does not create any /etc/mysql/my.cnf file. All you should get is new /etc/mysql/debian.cnf.
    So this is not a bug, you just apparently had a my.cnf coming from other installation, where you had different paths.

    Also the mysqld_safe is a wrapper/control script for mysqld which existed always. One of it's task is to restart mysqld if needed. In Ubuntu it was replaced by upstart script and in Fedora by systemd one. But I still trust the mysqld_safe more

    Note that Percona Server on Ubuntu is not controlled by upstart, but by the standard init.d.

    Comment


    • phuiberts
      phuiberts commented
      Editing a comment
      useful answer, but where do I make config changes? Do I create a my.cnf in /etc/mysql or has Percona another location and name for the config file?

  • #3
    Originally posted by przemek View Post
    Hi,

    By default Percona Server 5.6 does not create any /etc/mysql/my.cnf file. All you should get is new /etc/mysql/debian.cnf.
    So this is not a bug, you just apparently had a my.cnf coming from other installation, where you had different paths.

    Also the mysqld_safe is a wrapper/control script for mysqld which existed always. One of it's task is to restart mysqld if needed. In Ubuntu it was replaced by upstart script and in Fedora by systemd one. But I still trust the mysqld_safe more

    Note that Percona Server on Ubuntu is not controlled by upstart, but by the standard init.d.
    hi there, i have mosly some problem when isttal percona server 5.6 on debian wheezy
    here message when instalation stopped:

    insserv: script mysql: service mysql already provided!
    insserv: exiting now!
    update-rc.d: error: insserv rejected the script header
    dpkg: error processing percona-server-server-5.6 (--configure):
    subprocess installed post-installation script returned error exit status 1
    Errors were encountered while processing:
    percona-server-server-5.6
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    would you like to give me explanation what wrong with my installation proccess please?
    Thanks.

    Comment

    Working...
    X