Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Percona is a company that features their compilation of MySQL with emphasis on performance. That MySQL software is best known as Percona Server. They have downloads for MySQL 5.5, 5.1, 5.0, and MariaDB.

162 questions
4
votes
2 answers

MySQL Socket configuration issue in my.cnf

I've got an issue that's causing very long "time in database" in my application. The DB is Percona MySQL 5.5.35. The application works perfectly, and can read/write from the database just fine. The issue is that I have extraordinarily long DB…
i-CONICA
  • 648
  • 1
  • 9
  • 22
4
votes
1 answer

Percona Xtrabackup incremental backup based on prepared full backup

I want to create an hourly backup of our MySQL database to a staging system using Percona XtraBackup. Is it possible to prepare the $BACKUPBASE and then use this prepared backupbase as base for the following incremental backup (using the…
PaulSmecker
  • 43
  • 1
  • 5
4
votes
4 answers

How to migrate from regular MySQL to Percona Server in production?

I'm running MySQL 5.0 in production on CentOS. How do I migrate to Percona Server 5.1 safely? The documentation of Percona Server doesn't include any information on migrating. Any help is greatly appreciated.
Continuation
  • 3,080
  • 5
  • 30
  • 38
3
votes
4 answers

Percona XtraBackup: Getting an error regarding "Too many open files", how can I solve this issue?

I'm trying to backup using Percona XtraBackup and getting the following error: [root@ads-dev1 ~]# innobackupex /root/db InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affiliates 2009-2013. All…
Itai Ganot
  • 10,644
  • 29
  • 93
  • 146
3
votes
1 answer

MySQL memory usage - Periodically need to run FLUSH TABLES or memory usage keeps growing with large-pages turned on

After switching our rather memory + physical core rich database server to large-pages, we have noticed a small issue. The memory usage almost looks like there is some sort of memory leak. But running FLUSH TABLES purges about 10gigs of used memory…
anonymous-one
  • 1,018
  • 7
  • 27
  • 43
3
votes
1 answer

Percona: Got an error writing communication packets

Since a few days, two of our php-applications (symfony2) are reporting the following errors in mysql-logs: [Warning] Aborted connection 253 to db: '$appname' user: '$appname' host: 'localhost' (Got an error writing communication packets) One or two…
user196611
  • 197
  • 3
  • 10
3
votes
3 answers

Percona MySQL unable to start - ERROR! The server quit without updating PID file

BACKGROUND: I installed Percona Server on a fresh Centos 6.4 minimal. Prior to this, I have never installed MySQL (though I'm not sure if Centos 6.4 minimal came with MySQL?) Anyway, here are the commands I used: rpm -Uhv…
Honey Badger
  • 829
  • 3
  • 11
  • 15
3
votes
3 answers

What can I really do with percona toolkit's pt-table-sync?

I have been looking for a tool to synchronize tables from 2 different databases and found pt-table-sync. I read the documentation and got confused: they mostly use examples referring to a replicated environment, but I thought the whole point of…
Max
  • 3,523
  • 16
  • 53
  • 71
3
votes
1 answer

How to upgrade percona mysql on debian squeeze

Was running an apt upgrade and The following packages have been kept back: libmysqlclient18 percona-server-client-5.5 percona-server-server-5.5 I'm currently running percona mysql 5.5.15-55-log Trying sudo apt-get install percona-server-server-5.5…
Poe
  • 321
  • 1
  • 5
  • 18
2
votes
2 answers

Mysql backup of remote server in local machine using percona xtrabackup

I have percona xtrabackup installed in my ubuntu client machine. My local machine IP address is 192.168.0.100. The database that i need to backup is in 192.168.0.200. Is it possible to do the backup of remote server in local server using percona…
ram
  • 21
  • 1
  • 2
2
votes
0 answers

MYSQL: Aborted connection to db: 'unconnected' user: debian-sys-maint' host: 'localhost' (Got timeout reading communication packets)

I recently migrated all my logs to a new service, where I could see a recurring bug in mysql. The message is the following: Aborted connection to db: 'unconnected' user: debian-sys-maint' host: 'localhost' (Got timeout reading communication…
Gonzalo
  • 121
  • 1
  • 5
2
votes
1 answer

mysqladmin not waiting for full shutdown (or debian init.d script broken?)

I'm running Percona MySQL server 5.6 (from packages) on debian wheezy (same behavior on jessie). Unfortunately I always get this: # service mysql stop [FAIL] Stopping MySQL (Percona Server): mysqld failed! I can say about my configuration…
turbophi
  • 71
  • 4
2
votes
1 answer

Percona XtraDB Cluster 5.6 does not start

All the good days. I want to run for test purposes Percona XtraDb Cluster on ubuntu 14.04. The basis here took these two articles https://habrahabr.ru/post/152969/ https://www.percona.com/doc/percona-xtradb-cluster/5.6/manual/bootstrap.html I came…
dlarchikov
  • 121
  • 4
2
votes
0 answers

mysql Alter table to compress data fails with "Duplicate entry"

I was trying to compress few tables, but one of them caused this error alter table MY_table row_format=compressed, algorithm=INPLACE, LOCK=NONE; Query OK, 0 rows affected (0.00 sec) ERROR 1062 (23000): Duplicate entry '740003820' for key…
DBAd
  • 21
  • 2
2
votes
2 answers

Percona DB not starting: initscript mysql, action "start" failed

After I installed Percona server I got this message: * Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit. * Run the following commands to create these functions: mysql -e "CREATE FUNCTION…
jnbdz
  • 927
  • 5
  • 24
  • 46
1
2
3
…
10 11