percona 5.6 - ubuntu 12.04.03 problem

MySQL & MariaDB Other MySQL® Questions
1

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

[URL]http://www.percona.com/doc/percona-server/5.5/installation/apt_repo.html[/URL]

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 :slight_smile:

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

3

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.

4

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?