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
2
votes
0 answers

MySQL Enterprise Backup GUI (or a live backup alternative)

I am looking into MySQL Enterprise backup solution. I am interested in a non-blocking mysql backup (live and incremental). MySQL Enterprise provides this solution (we have the subscription already). But from what I see it's only a console…
geoaxis
  • 491
  • 1
  • 6
  • 18
2
votes
2 answers

MySQL: Headers and client library minor version mismatch

I have this error when I try to connect to database using PHP: mysql_connect(): Headers and client library minor version mismatch. Headers:50147 Library:50501 And this warning in phpmyadmin: Your PHP MySQL library version 5.5.1-m2 differs from your…
NARKOZ
  • 998
  • 3
  • 15
  • 23
2
votes
0 answers

Debugging Active Directory Login with MongoDB

I am trying to log into MongoDB using an active directory username. We're using Percona for MongoDB but I believe this really should be pretty similar to regular MongoDB 5.x authentication. We've tried variation after variation. Here's the most…
Brad
  • 619
  • 1
  • 10
  • 28
1
vote
0 answers

Mysql docker on centos not working

I use centos as server and I use docker-compose like: mysql: build: ./DockerFiles/Mysql ports: - ${LOCAL_PHP_IP}:${MYSQL_PORT}:3306 privileged: true environment: MYSQL_ROOT_PASSWORD: root volumes: -…
Alireza Rahmani Khalili
  • 111
  • 3
1
vote
0 answers

What is the alternative for innodb_track_changed_pages in Debian 10/MariaDB 10.3

So we have been using Debian 9 with MariaDB 10.1. For faster backups (total DB size across three DBs is > 1TB) we have enabled innodb_track_changed_pages. However, that feature has gone away on MariaDB 10.3 because they changed (back) from XtraDB to…
Stefan Seidel
  • 722
  • 1
  • 8
  • 20
1
vote
2 answers

Tune Percona Server 5.7

I am using a 4 core ubuntu cloud server with 8gb and ssds. There I have only one database for a Magento store which is about 2GB size. Last month after some changes I made it seems that database performing as it should. Percona server 5.7 After…
G. G.
  • 143
  • 7
1
vote
2 answers

Enabling Encryption at Rest for MongoDB Generates Error

Running Percona Server for MongoDB server version: v3.6.8-2.0. I am attempting to enable encryption at rest using the procedure outlined in the…
Adam
  • 141
  • 1
  • 8
1
vote
1 answer

mysql tries to connect to localhost at startup, [Note] Access denied for user 'root'@'localhost' (using password: NO)

When I start/restart the mysql service, I always see this row in the log: 2017-07-19T17:35:02.379166Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO) What is it trying to do? And how can I set the user/password/host for…
the_nuts
  • 430
  • 6
  • 19
1
vote
1 answer

Is there a way to load large BLOBs without restarting MySQL?

I'm trying to move the last few databases off an older mysql server, but one in particular has me stumped: ERROR 1118 (42000) at line 595: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the…
jldugger
  • 14,342
  • 20
  • 77
  • 129
1
vote
0 answers

Installing php-mysql on centos 6.5 fails due to conflicts when percona client 5.5 also installed

Some background: I'm writing a Chef cookbook to set up a LNMP stack for local development. It requires the php-mysql library for PHP 5.4 (using the php package). We're using the yum-remi repository for installing these. For local development of our…
Derek
  • 111
  • 4
1
vote
2 answers

Percona cluster signal 11

We have a percona cluster that is randomly getting signal 11's on different cluster nodes. I've exhausted everthing I know. Here's the .err file with the signal 11. We're running Server version: 5.6.22-72.0-56 Percona XtraDB Cluster (GPL), Release…
BradleyH
  • 21
  • 3
1
vote
1 answer

InnoDB “Table xx Is Full” during database alterations

I am running Percona Mysql Server 5.6.14-56 on CentOS 6.3 64bit. Server has plenty ram (96gb) and storage free. File system type: ext4 dev/sda6 ext4 1093623528 56576512 981494148 6% /mysqlstorage I tried to make some alterations to a table…
Mr.Boon
  • 1,471
  • 4
  • 24
  • 43
1
vote
1 answer

Percona startup fails: mysql can't access directory for file creation

I found a few questions and suggestions for similiar problem, unfortunately nothing seems to work for me, so please excuse me if this is double (and point to right source)... Server is Fedora Beefy Miracle, percona mysql server installed. I do not…
zencodism
  • 265
  • 1
  • 5
  • 9
1
vote
0 answers

MySQL SSL Problems

I need to configure SSL for a MySQL server. I've read all of the directions for doing self-signed certs but it's preferred that I sign and use the certs from a different CA running AD Certificate Services. Is this a possibility? I've generated the…
user165222
  • 125
  • 3
  • 9
1
vote
0 answers

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The hardware; Originally, I had a powerful but oversubscribed…
i-CONICA
  • 648
  • 1
  • 9
  • 22
1 2 3
…
10 11