1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problem with Percona...

Discussion in 'Server Configuration and Hosting' started by Sheratan, Dec 18, 2013.

  1. Sheratan

    Sheratan Well-Known Member

    I'm trying to learn more about Percona.

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

    Code:
    service mysql reload
    Works. But everytime I do
    Code:
    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
    Code:
    service mysql status
    Percona is down. But when I see...
    Code:
    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?
     
  2. Slavik

    Slavik XenForo Moderator Staff Member

    Get rid of debian :D
     
  3. Sheratan

    Sheratan Well-Known Member

    :ROFLMAO:

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

    Slavik XenForo Moderator Staff Member

    Never had any problems.
     
  5. jwright

    jwright Active Member

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

    Code:
    cat /var/lib/mysql/`hostname`.err
     
    Sheratan likes this.
  6. Sheratan

    Sheratan Well-Known Member

    Ooh! I got it.

    First, you cannot restart percona from
    Code:
    service mysql restart
    You need to use init.d for it
    Code:
    /etc/init.d/mysql restart
    Second, there is some mistake in Percona Tools Wizard. By default, you got this:
    Code:
    [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:

    Code:
    [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:
    Code:
    ps aux |grep mysql
     
  7. Tracy Perry

    Tracy Perry Well-Known Member

    Did you follow ALL the instructions and PIN percona in the /etc/apt/preferences.d
    Code:
    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.

    Code:
    service mysql restart
    works just fine on all 6 of the Debian boxes that I have.
    Code:
    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 likes this.
  8. Sheratan

    Sheratan Well-Known Member

    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?
     
  9. Tracy Perry

    Tracy Perry Well-Known Member

    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.
     
  10. Sheratan

    Sheratan Well-Known Member

    Not a problem but makes my spidey sense tingling!

    Code:
    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?
     
  11. Floren

    Floren Well-Known Member

    Heh. :giggle:
     
  12. Moshe1010

    Moshe1010 Well-Known Member

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

    Sheratan Well-Known Member

    My forum server is a live test server. :D
     

Share This Page