Problem with Percona...

[Sheratan]

I'm trying to learn more about Percona.

Installing Debian 7 with Percona 5.6 in VMWare, i realize I can't restart percona.

service mysql reload

Works. But everytime I do

service mysql restart

Percona failed to restart. I had to reboot to make percona up again.

The weird thing is... when I check percona status

service mysql status

Percona is down. But when I see...

lsof -i -P

There is mysql runing as mysqd.

Another problem, percona failed to up if I put .cnf from Percona Tools wizard. Even rebooting cannot make percona up.

So... any suggestion?

 

[Slavik]

So... any suggestion?

Get rid of debian

 

[Sheratan]

Get rid of debian

Do you had any problem with percona in centos? Because a lot of people got same problem in debian...

 

[Slavik]

Do you had any problem with percona in centos? Because a lot of people got same problem in debian...

Never had any problems.

 

[JonathanW]

Can you give us the output (at least last 100 lines or so) from the log file? I'm not sure where this is on Debian but in CentOS the following command would work (it will probably work for Debian as well):

cat /var/lib/mysql/`hostname`.err

 

[Sheratan]

Ooh! I got it.

First, you cannot restart percona from

service mysql restart

You need to use init.d for it

/etc/init.d/mysql restart

Second, there is some mistake in Percona Tools Wizard. By default, you got this:

[mysql]

# CLIENT #
port                           = 3306
socket                         = /var/lib/mysql/mysql.sock

[mysqld]

# GENERAL #
user                           = mysql
default-storage-engine         = InnoDB
socket                         = /var/lib/mysql/mysql.sock
pid-file                       = /var/lib/mysql/mysql.pid

But the truth is... if you install percona from their official repo, you got this:

[mysql]

# CLIENT #
port                           = 3306
socket                         = /var/lib/mysqld/mysqld.sock

[mysqld]

# GENERAL #
user                           = mysql
default-storage-engine         = InnoDB
socket                         = /var/lib/mysqld/mysqld.sock
pid-file                       = /var/lib/mysql/*your_host_name_or_something.pid

Check your PID with:

ps aux |grep mysql

 

[TPerry]

Do you had any problem with percona in centos? Because a lot of people got same problem in debian...

Did you follow ALL the instructions and PIN percona in the /etc/apt/preferences.d

Package: *
Pin: release o=Percona Development Team
Pin-Priority: 1001

The only time I've seen that happen was when it wasn't pinned and the system upgraded/installed the default (shipping) mySQL also and there were some conflicts. And yes, it got me once when I forgot to do it and there was a mySQL update out that aptitude update/aptitude safe-upgrade was ran and picked up and cratered Percona. Once I uninstalled the shipping version, pinned the Percona version and then installed Percona again never had any more problems.

service mysql restart

works just fine on all 6 of the Debian boxes that I have.

root@centauri:/etc/apt# service mysql restart
[ ok ] Stopping MySQL (Percona Server): mysqld.
[ ok ] Starting MySQL (Percona Server) database server: mysqld . . ..
[info] Checking for corrupt, not cleanly closed and upgrade needing tables..

 

[Sheratan]

Did you follow ALL the instructions and PIN percona in the /etc/apt/preferences.d

Package: *
Pin: release o=Percona Development Team
Pin-Priority: 1001

Forgot about it. Thanks for tellling me. But I'm not upgrading from stock mysql.

Did I need to reinstall percona again for this Pin?

 

[TPerry]

Forgot about it. Thanks for tellling me. But I'm not upgrading from stock mysql.

Did I need to reinstall percona again for this Pin?

If you are on the stock (shipped with Debian) mySQL then you don't need to do that. If you are running Percona then you need to pin it by creating (in the /etc/apt/preferences.d) a file called 00percona.pref (those are zero's at the lead) and then place the info into that file.

 

[Sheratan]

Not a problem but makes my spidey sense tingling!

adminaccount@hostname:~# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be DOWNGRADED:
  libmysqlclient18.1
0 upgraded, 0 newly installed, 1 downgraded, 0 to remove and 0 not upgraded.
Need to get 946 kB of archives.
After this operation, 1,024 B disk space will be freed.

Latest Debian 7 64, Percona 5.6.15-63.0-log.

Any information about this?

 

[Floren]

Get rid of debian

Heh.

 

[Moshe1010]

Why 5.6? I've seen many benchmarks (with different systems/configurations) that show 5.5 is faster.

 

[Sheratan]

My forum server is a live test server.