Stack Overflow
Stack Overflow

Questions tagged [percona]

Percona builds free and open source database software that includes: Percona Server for MySQL®, Percona Server for MongoDB, Percona XtraDB Cluster, Percona XtraBackup, Percona Monitoring and Management, and Percona Toolkit. The widely installed Percona Server for MySQL is a drop in replacement for MySQL, and includes XtraDB, an enhanced version of the InnoDB storage engine.

Percona builds free and open source database software that includes:

  • Percona Server for MySQL® a free, fully compatible, enhanced, open source drop-in replacement for MySQL which includes XtraDB, an enhanced version of the InnoDB storage engine.
  • Percona XtraDB Cluster an active/active high availability and high scalability open source solution for MySQL ® clustering.
  • Percona XtraBackup a free, open source, complete online backup solution for all versions of Percona Server for MySQL, MySQL ® and MariaDB®.
  • Percona Monitoring and Management a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance.
  • Percona Toolkit a collection of advanced open source command-line tools that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually.
  • Percona Server for MongoDB a free, enhanced, fully compatible, open source, drop-in replacement for the MongoDB® Community Server that includes enterprise-grade features and functionality
647 questions
9
votes
2 answers

Taking backup remotely using innobackupex

I am trying to take backup from a remote machine using innobackupex. ./innobackupex --host= --user= . Its failing as it is unable to locate a directory in the server. (Errcode: 2 - No such file or directory) I…
user3351750
  • 927
  • 13
  • 24
9
votes
1 answer

MariaDB vs Drizzle vs Percona Server vs MySQL

I've been a MySQL user for a long time now. I'd like to start using all the different variations between the most popular forks. The problem is that I can't find any good comparison between them, and I'll end up just trying all of them. My concerns…
santiagobasulto
  • 11,320
  • 11
  • 64
  • 88
8
votes
1 answer

Mysql UDF is installed (but doesn't exist?)

Here's a crazy one: mysql> CREATE FUNCTION PREG_REPLACE RETURNS STRING SONAME 'lib_mysqludf_preg.so'; ERROR 1125 (HY000): Function 'PREG_REPLACE' already exists mysql> DROP FUNCTION preg_replace; ERROR 1305 (42000): FUNCTION (UDF) preg_replace does…
Josh
  • 177
  • 1
  • 11
8
votes
2 answers

Mysqldump broken CREATE VIEW export

My database backup through mysqldump get created with wrong source SQL query for all database views. All source columns are always "1". I can export view definition using mysql workbench and the same db user just fine. Here is example of view…
user2237890
  • 91
  • 3
7
votes
4 answers

Pipeline process 5 (iteration) caused an error: Redundant argument in sprintf at /usr/bin/pt-query-digest line 2556

I am using percona-toolkit for analysing mysql-slow-query (logs). So the command is pretty basic: pt-query-digest slowquery.log Now the result(error) is: 18.2s user time, 100ms system time, 35.61M rss, 105.19M vsz Current date: Thu Jul 7 17:18:43…
Sagar Suri
  • 73
  • 5
7
votes
2 answers

mysql error: Can't create a new thread (errno 11)

I have a db server running Percona Xtradb server, and 5 slaves. I always get the error mysql error: Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug Though…
Kevin Nguyen
  • 1,759
  • 2
  • 16
  • 14
6
votes
1 answer

Trying to isolate pt-query-digest per host

I'm having some difficulty coming up with correct syntax to pull in specific host information for my slow query log file: I'm using the following: sudo pt-query-digest mysql-slow.log --since "2017-05-07 22:00:00" --until "2017-05-08 22:00:00"…
JimRomeFan
  • 407
  • 6
  • 19
6
votes
1 answer

Percona 5.7 Slow on many Joins

We recently upgraded our percona 5.5 sql server to percona 5.7. Works out fine so far. unfortunately we have a huge query, which is extremly slower under 5.7. Under 5.5. it takes less than a second, even with sql_no_cache. With Percona 5.7. it takes…
tom
  • 84
  • 5
6
votes
2 answers

MySQL error 1236 When using GTID

I want to create a replica to my Percona Server with GTID enabled, but got this error when i show slave status: Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'The slave is connecting using CHANGE MASTER TO…
The Georgia
  • 1,005
  • 7
  • 23
  • 59
6
votes
1 answer

Why didn't MySQL GRANT create associated user accounts?

I installed Percona Toolkit to use pt-show-grants but it's not showing up all the grants. When I run it I see the following output: -- Grants dumped by pt-show-grants -- Dumped from server Localhost via UNIX socket, MySQL 5.5.43-log at 2015-06-11…
LeonardChallis
  • 7,759
  • 6
  • 45
  • 76
6
votes
2 answers

Optimize my.cnf configuration for 1 gb ram with 100+ users online

My mysql keeps crashing. And I think it's because of improper configuration of my.cnf. Here's my my.cnf current configuration. Please help me to optimize it. I'm using a 1gb ram and 30gb ssd. I wanted to optimize my allocated ram and memory. I…
user3416962
  • 89
  • 1
  • 2
  • 7
6
votes
3 answers

Percona 5.6 high memory usage

I'm not sure if stack is the right place to ask this, but I recently upgraded to Percona 5.6 from 5.5 and my memory usage has skyrocketed! This is from PS: mysql 4598 0.0 29.5 1583356 465312 ? Sl Oct17 9:07 /usr/sbin/mysqld…
Dani
  • 1,220
  • 7
  • 22
6
votes
1 answer

Working around invalid conversion from const

I am compiling Percona (MySQL variant) on my Raspberry Pi, which has an ARM processor. I've encountered an issue during compilation that has been reported, but nobody is willing to fix because ARM is an unsupported…
Leigh
  • 12,859
  • 3
  • 39
  • 60
5
votes
2 answers

Percona Server 5.5 or MariaDB on Windows

I am running a MySQL 5.5 on a x64 Windows Server and keep getting a auto increment id error which is a known error in MySQL. I would like to try out Percona Server or MariaDB as they have higher benchmarks but I can't find a drop in replacement…
runxc1 Bret Ferrier
  • 8,096
  • 14
  • 61
  • 100
5
votes
0 answers

Percona PMM2 Docker image - how to use it?

How do I run Percona PMM2 with docker-compose? I can run PMM1 just fine. But PMM2 has absolutely zero documentation available and I can't seem to figure it out. Sample docker-compose.yml file db: image: mariadb:10.4.13 ports: -…
Renka
  • 146
  • 9
1
2
3
…
43 44