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
0
votes
1 answer

CentOS6 box: yum remove Percona-Server-shared-51 dependencies

I want to install Percona 5.7, but when I run the relevant yum command it tells me that 57 clashes with Percona-Server-shared-51. I don't really know why I even have that installed, since I also have Percona-Server-shared-56. rpm -qa | grep…
Codemonkey
  • 1,086
  • 4
  • 19
  • 41
0
votes
1 answer

PerconaDB cant run without innodb_recovery 4

My Percona 5.7.11-4 crashed without cause. Now I can run only with innodb force recovery = 4. Here is backtrace from log. Can you help? Thank you. > Thread pointer: 0x0 Attempting backtrace. You can use the following > information to find out where…
Pavel
  • 417
  • 1
  • 7
  • 17
0
votes
1 answer

docker: Percona how to populate mysql server with initial data

I have created percona container in the following way: docker run --name=sql -v /path/to/dump:/tmp/dump:ro -d -e MYSQL_ALLOW_EMPTY_PASSWORD=True -e MYSQL_DATABASE=config percona:5.6 mysqld --max-allowed-packet=100M Where the /tmp contains all…
Oleg
  • 47
  • 1
  • 1
  • 14
0
votes
0 answers

Home became 主页

After I ran software upgrade "apt-get upgrade" on DB server, chinese characters become weird Joomla 2.5.16 PHP 5.5.9-1ubuntu4.14 with fpm-fcgi/php5-fpm nginx 1.4.6 mysqld (Percona XtraDB Cluster) 5.6.26-74.0 I had tried setting default charset to…
grepmaster
  • 143
  • 2
  • 4
  • 14
0
votes
1 answer

MySQL creates huge files every night, bringing down the server

I have an Ubuntu 12.04 LEMP server with shop app ontop, running MySQL 5.5 as DB (currently since this problem started I've already switched to Percona with no success). So, current facts: every night my monitoring tells me that the server is not…
TiGR
  • 121
  • 4
0
votes
0 answers

Error enabling TokuDB - Percona Server not running with jemalloc enabled

I have installed: Ubuntu 14.04.3 LTS (GNU/Linux 3.13.0-63-generic x86_64) Percona Server 5.6.26-74.0-1.trusty Percona Server TokuDB 5.6.26-74.0-1.trusty libjemalloc1 3.6.0-2.trusty In /etc/mysql/my.cnf under [mysqld_safe] I have added: malloc-lib…
Patrick
  • 1
  • 2
0
votes
1 answer

XtraBackup restore gives duplicates on slaving?

We've recently upgraded a MySQL 5.0 master-master setup to Percona 5.6. Slaving went b0rken due to some failures on our side, but we thought we could simply fix it by using xtrabackup to create a backup from the running server and importing it to…
Tim Stoop
  • 588
  • 5
  • 20
0
votes
1 answer

Percona: What are the implications of changing repl.commit_order?

I'm currently doing some trials of Galera Cluster with Percona 5.6. I've progressed to testing a 2 node cluster on baremetal. With repl.commit_order set to 0 (off) the TPS performance as measured with sysbench is comparable to that of a standalone…
phil-lavin
  • 590
  • 1
  • 3
  • 15
0
votes
1 answer

How do I install mysql2 gem with percona 5.6 on Ubuntu 14.04 Trusty?

I've setup percona-server-server and percona-server-client packages as per the instructions on the percona website, but when I try to install the mysql gem, I see the following message: Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem…
robd
  • 141
  • 1
  • 1
  • 5
0
votes
0 answers

MySQL/Percona Server sudden CPU usage spikes

I've got some trouble with Percona Server 5.5: suddenly abnormous MySQL CPU usage caused the system to become unresponsive as it was eating up all CPU with a large number of threads. It's a 24 core system with 64GB RAM that's usually idle (avg load…
Tsolen
  • 23
  • 1
  • 7
0
votes
1 answer

Cacti - Interpreting values for Network statistics

I've downloaded and installed the Percona Linux template. I noticed the values for tx-drop had values of 'm' and 'u' and don't quite understand why I'm getting values of micro and milli. I was expecting reading to simply be the number of packet…
supmethods
  • 287
  • 4
  • 16
0
votes
1 answer

MySQL backups/Replication using xtrabackup and Native Mysql Replication

This aspect of using Percona Xtrabackup over Native Replication has been in my head for sometime now and I just cant seem to find an answer to this, I am posting this as a last resort seeking advice from you experts. I went through the process of…
niroshan.l
  • 165
  • 1
  • 6
0
votes
1 answer

Percona Server & MySQL server on the same server on different ports

I have MySQL installed from ports, running and listening on port 3306. On the same server I have Percona Server compiled from sources, running and listening on port 3307. Here are the process list for percona & mysql: #mysql processes bin/sh…
Kirzilla
  • 563
  • 3
  • 9
  • 21
0
votes
0 answers

Percona MySQL and my.cnf (Ubuntu 12.04)

So I am trying to move the database following the directions here: https://stackoverflow.com/questions/11069422/what-to-do-when-mysql-has-no-space-left/11070334#11070334 (option #3 in the long post that describes the process in detail) and I know…
jon
  • 1
0
votes
1 answer

New nagios/cacti monitoring setup, should I use a dedicated VM?

Currently we have 4 bare metal servers and one small VM server (all running centos6) and I'm looking at setting up monitoring for the Percona MySQL db server and replication slave (bare metal), as well as the remaining 3 which are app…
xref
  • 273
  • 3
  • 14
1 2 3
…
10 11