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

Fresh 12.04 Install - mySQL not starting

I have a freshly installed Ubuntu 12.04 x64 server and I installed Percona server from their official repositories. Trouble is it will not start! mysql-error.log shows nothing obvious. 121129 12:16:54 mysqld_safe Starting mysqld daemon with…
Lee Armstrong
  • 149
  • 7
0
votes
1 answer

Which repo and version of Percona for Natty?

I'm wanting to drop in Percona instead of MySQL (5.1) on my Natty ubuntu server. I've added the keys and the repos. I've added a natty repo, even though it's not supposed to exist and it seems to be fine. The problem is when I go an apt-get install…
thefella
  • 1
  • 2
0
votes
1 answer

MySQL too many connections during normal conditions (Percona, InnoDB)

We're getting too many connections errors in normal conditions, so I'm assuming it's a configuration issue. Four webservers, not using persistant connections partly because that triggers to the too many connections error too quickly. See more about…
Jonathan Hendler
  • 282
  • 1
  • 4
  • 10
0
votes
2 answers

Shorter alias for domain name

I need to create a shorter name for my Mysql database endpoint to be accessed from linux box. Clearly said, my mysql end point is rdsbench.c2wfqsdsqd.us-east-1.rds.amazonaws.com and I would like to create a shorter name, let's say mybenchdb, so I…
PapelPincel
  • 325
  • 6
  • 18
0
votes
2 answers

Installed Percona mySQL on CPanel but getting an error

I installed Percona mySQL on my fresh CPanel server (no databases yet) according to: http://www.ecommy.com/linux/install-...el-environment Everything seemed to be OK and the server also starts fine, except some commands return this…
user1227914
  • 147
  • 6
0
votes
4 answers

Percona-xtrabackup hot backup issue with MyIsam Engine

We are running with the MyIsam Engine and Percona-xtrabackup is throwing the following error as the inndb engine is skipped [ my.cnf skip-innodb]. How could I resolve this issue with out enabling the inndb engine? percona-xtrabackup-2.0.0/bin:#…
arn
  • 91
  • 2
  • 7
0
votes
1 answer

Percona MySQL 8.0.25-15 filling up slow log with headers only

Has anyone experienced an issue where when the slow log is enabled with the following options: root@(none)> show global variables like "%slow_query%"; +-----------------------------------+-------------------------------+ | Variable_name …
Vladimir
  • 321
  • 1
  • 12
0
votes
0 answers

pt-kill match against query ID/digest?

There's a specific large query that gets run and I'd like pt-kill to match based on the query ID/digest ideally. I don't see a way to do that though in the docs. I also tried to match by the query fingerprint but that wasn't working either. Can…
Rob Olmos
  • 2,240
  • 1
  • 15
  • 26
0
votes
1 answer

Error: Nothing to do while installing percona server on centos 7?

Can't install percona on centos 7 yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm Output: Loaded plugins: fastestmirror, langpacks percona-release-0.1-3.noarch.rpm …
achhainsan
  • 123
  • 7
0
votes
0 answers

pt-query-digest on large slowlog files runs slow - only singlethread

I have large slowlogfiles generated by percona 5.7 packed by zstd. Its for test, logging all queries, query time is set to 0s I need it process quickly than in 12 hrs :) The pt-query-digest is probably only singlethread app in default setting and in…
Petr Schönmann
  • 11
  • 4
0
votes
0 answers

Installing XtraBackup on Centos 6

I’m trying to install XtraBackup on centos 6 using this guid but i get these errors: Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base) Requires: libmysqlclient.so.16()(64bit) Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64…
h0mayun
  • 99
  • 2
0
votes
0 answers

Big performance gap between two similar servers in mysql-percona 5.6 ubuntu

I cannot figure out reason of performance difference between two (three?) similar percona 5.6 instances. I prepared some tpcc-like benchmarking using sysbench and among 3 similar servers, one is making 30-40% better result. As far benchmark it is…
atapidriver
  • 1
  • 1
0
votes
1 answer

how to take mysql xtrabackup to a remote server

I have a server running with mysql with huge db of 1 TB. Now, I want to take full backup through percona xtra backup, because incremental backup is easy with percona xtrabackup. Now,if I initiate taking backup in that server,storage is getting…
Ravi Teja RVN
  • 1
  • 3
0
votes
1 answer

MySQL 8 replication via non-ssl connecion

I'm trying to setup tiny master-slave environment with percona-server-server.x86_64-8.0.27-18.1.el8. A plan is to use non-ssl connections between the nodes as the servers will communicate in the LAN only. But following error is received on…
varas
  • 1
0
votes
0 answers

Automate Percona Server installation

I'm installing Percona Server 8.0 on Ubuntu using ansible, so it's non-interactive. I'm trying to run the post-install mysql_secure_installation program, but that's not much good without interaction. Is there some way I can set its properties such…
Synchro
  • 3,148
  • 6
  • 27
  • 38
1 2 3
…
10
11