Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [percona-server]

Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.

Percona Server for MySQL is a rebase of MySQL's Community Edition server that focuses on implementing performance improvements that make the database scale better, and perform more consistently. These enhancements are available for MySQL 5.0, 5.1, 5.5, 5.7 and 8.0.

Percona Server comes with the XtraDB storage engine, which is an enhanced replacement of MySQL's InnoDB storage engine. In addition, Percona also includes the new MyRocks storage engine, developed in partnership with Facebook.

Percona Server is developed by the consulting company Percona, which also provides other helpful open source projects such as the Percona Toolkit, Percona XtraDB Cluster, and Percona Monitoring and Management. All software produced by Percona is 100% Free and Open Source.

130 questions
28
votes
3 answers

Should a MySQL replication slave be set to read only?

I've got replication running on Percona Server 5.5 by following this guide and wondered if I should add read-only=1 to my slave's my.cnf to make it read only? The guide sets up replication for the mysql table so users are replicated but I am…
xref
  • 759
  • 2
  • 9
  • 16
25
votes
4 answers

How do you identify InnoDB table corruption?

I have some tables that are partitioned and have several indexes on a replicated slave. After copying the snap shot (verified safe) to a new slave and upgrading mysqld from 5.1.42 to 5.5.15 and restarting replication, I'm getting InnoDB crashes with…
randomx
  • 3,944
  • 4
  • 31
  • 44
24
votes
2 answers

Percona vs MySQL

What is Percona? How does it differ from MySQL? When should we consider switching (or upgrading) from stock MySQL to Percona? To add some specifics in our situation we almost exclusively use InnoDB (which I understand Percona has done a lot of…
Noah Goodrich
  • 510
  • 1
  • 5
  • 15
11
votes
1 answer

Capabilities of InnoDB INSERT Performance

Hi I am running the most recent version of Percona Server. Server version: 5.5.24-55 Percona Server (GPL), Release 26.0 I have a 10 cpu box of these characteristics. processor : 0 vendor_id : AuthenticAMD cpu family : 16 model …
Don Wool
  • 339
  • 2
  • 4
  • 10
9
votes
2 answers

What should I set my table_definition_cache to?

I just discovered table_definition_cache and I am trying to decide what to set it to. I am messing with my config because of performance issues. On one server I have 36599 tables and when I run SHOW GLOBAL STATUS the value for Opened tables is…
ODelibalta
  • 289
  • 2
  • 3
  • 12
8
votes
1 answer

Do you still use MyISAM or prefer Aria storage engine?

If Aria storage engine (previously called Maria) is the "new" MyISAM, which supports transaction and automatic crash recovery: Why still use MyISAM ? Should changing storage engine from MyISAM to Aria be a problem? (lose index or something)
jcho360
  • 2,009
  • 8
  • 24
  • 31
7
votes
1 answer

Percona mysqld got signal 11

I've googled and searched stackexchange, but can't find anything relevant to this particular issue (there are other error 11 issues, just not for this as far as I can tell). We have a server that is not really doing a ton of reads or writes. The…
Clayton Dukes
  • 123
  • 1
  • 8
6
votes
2 answers

MySQL stuck on "wsrep: initiating replication for write set (-1)"

I ran into a situation with MySQL recently which I hadn't seen before. We have a Percona cluster with 3 nodes. The master stopped processing queries and the PHP FPM web application we host became unresponsive. When I checked SHOW PROCESSLIST, MySQL…
Josh
  • 558
  • 3
  • 8
  • 18
6
votes
1 answer

Tuning dedicated Percona Server with XtraDB for OLTP

Hardware specs for an OLTP DB dual quad core xeon with hyperthreading 24GB ram Hardware RAID10 BBU Software specs Standard install of Ubuntu 10.04LTS with default LVM partitioning Installed Percona Server with XtraDB My priority is data…
Jessie Evangelista
  • 61
  • 2
6
votes
4 answers

Mysql (percona-server 5.5) completely stalls during import (myloader)

While configuring our new servers (IBM X3650M4, 2x Intel Xeon E5-2620, 64G RAM, RAID 10 (4x 240G SSD)) we bumped into a strange problem. We're trying to import dumps (mydumper) from our (old) production environment into our new one, but we're hardly…
tersmitten
  • 193
  • 1
  • 12
5
votes
1 answer

Error 1236 From Master After Restored Replication

I've been trying to restore a broken replication caused by power interruption. upon checking the slaveDB, it was already broken so I setup a new replication. And upon supposedly completing the replication, i'm stuck with this: Got fatal error 1236…
paacharon3
  • 55
  • 1
  • 5
5
votes
1 answer

Online Schema migration in MySQL : When to start?

I'm the tech lead of a Social Media SAAS, where we're currently experiencing a big increase in data amount we're storing in our mySQL-database. We're having a single MySQL db, and besides many really small tables, we have two tables with approx…
Johannes N.
  • 153
  • 5
5
votes
3 answers

MySQL information_schema doesn't update

I have a database, say abc, in mysql server. It has only one table named test. test uses innodb engine and I've set innodb_file_per_table to true. After I run the query delete from abc.test, I want to calculate the database size of abc. Here is the…
Eagle
  • 271
  • 3
  • 7
4
votes
2 answers

Identifying cause of high I/O

I'm trying to diagnose the bottleneck for high-write I/O activity on a percona master (with replication to a slave). The pattern of behaviour is roughly cyclic and regular: 60 mins of 75-90% write-based IO utilisation followed by 10 mins of ~25%.…
mattp
  • 61
  • 1
  • 8
4
votes
1 answer

Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID?

I'm setting up 5.6 Percona Mysql, in order to enable GTID should I have to enable log_slave_update on both Master and Slave ? If I should enable log_slave_update, then I'm counting this to CONS for having GTID. Also if you can let me know any other…
Mannoj
  • 1,581
  • 3
  • 15
  • 36
1
2 3
…
8 9