Database Administrators Stack Exchange
Database Administrators 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 for MySQL. They have downloads for Percona Server for MySQL (5.7, 5.6, 5.5, 5.1), Percona XtraDB Cluster, Percona Server for MongoDB and tools for backup, monitoring, online schema changes and more.

One of their most notable enhancements is the storage engine XtraDB (complete drop-in replacement for InnoDB) which has been around since December 2008.

Percona also has a well-known blog, previously known as the 'MySQL Performance Blog', now called the 'Database Performance Blog'.

343 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
26
votes
2 answers

How do I properly perform a MySQL bake-off?

I want to performance test (aka bake-off) MySQL server rpm against some other forks such as Percona server, MariaDB, and possibly some others. I'm hoping that by asking this question I can better understand the methodology behind setting up a proper…
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
12
votes
1 answer

Why default character_set_server is latin1?

I am using MySQL 5.5 and when I show variables about charset, I have +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ |…
Yoga
  • 549
  • 3
  • 8
  • 15
11
votes
1 answer

What is the difference between XtraBackup and rsync?

Yes, I'm going to run strace on them both... However, I would like to know ... What is XtraBackup is doing over and above rsync -ac src dest ? What's so special about XtraBbackup ? How is XtraBackup interacting with mysqld ?
randomx
  • 3,944
  • 4
  • 31
  • 44
10
votes
2 answers

What is the optimal solution for storing real time time-series in MariaDB / MySQL?

Use case: A measurement creates a given number of images. For each image we need to store a small set of quality indicators (floats, doubles) along with an image integer [1 ...N], a timestamp and one or two foreign key values. This should then be…
dbdemon
  • 6,964
  • 4
  • 21
  • 40
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

MySQL requires FORCE INDEX on huge table and simple SELECTs

We have an application which stores articles from different sources in a MySQL table and allows users to retrieve those articles ordered by date. Articles are always filtered by source, so for client SELECTs we always have WHERE source_id IN…
Jacket
  • 540
  • 2
  • 6
  • 13
8
votes
2 answers

query_cache_type = 0 vs query_cache_type = 1

Recently, I moved from standard MySQL to Percona, and used the Percona Wizard to generate my.cnf. However, I can see that, by default, the generated settings for my.cnf use query_cache_type = 0. (query cache is disabled). The only thing I run on…
bazaglia
  • 267
  • 2
  • 3
  • 6
8
votes
2 answers

How to set MySQL binlog retention in hours?

I'm in a situation where the MySQL log partition is being filled in less than a day. I can't disable binlogs, since I need them for replication. I know I can set log retention but that accepts days, and a search only showed me this…
hoodakaushal
  • 205
  • 1
  • 2
  • 5
8
votes
3 answers

How to run OPTIMIZE TABLE on a 3-node cluster?

I've my hands on a 3-node Percona XtraDB Cluster where, according to mysqlcheck, some tables are corrupted (some indexes contain the wrong number of entries): mydb.mytable Warning : InnoDB: Index 'foo' contains 1393929 entries, should be…
dr_
  • 1,334
  • 4
  • 19
  • 40
7
votes
2 answers

Investigate peak in MySQL throughput

Recently one of our servers has ran out of memory and crashed. After reviewing the munin graphs, it appears that the only metric (other than memory usage) that peaked just before the crash was the MySQL throughput. However we were expecting to see a…
Max Corbeau
  • 349
  • 5
  • 10
6
votes
1 answer

Mysql Cluster vs Percona/Maridb Cluster

We want to setup a mysql cluster with master-master sync replication, to provide HA so that one db for write from one app, other for write from other app. It is a webapp with high write and medium read We are considering adding mysql cluster and…
doesnt_matter
  • 63
  • 1
  • 5
6
votes
1 answer

MySQL Partitions with Partition limit

I have a partitioned table on the basis of the Primary key having 1.5 Billion rows in it. But when I check the .ibd files only 80 ibd show in GB's whereas 120ibd shows 1MB file. I would like to know how does the distribution work when I limit…
Rohan
  • 61
  • 1
6
votes
2 answers

Transaction speed benchmarks for mySQL v5.6 replication - seems very slow

I'm trying to select the best configuration for our new infrastructure but got a bit confused about the results. I used sysbench v0.5 for the tests: prepare data sysbench --test=/usr/share/doc/sysbench/tests/db/oltp.lua \ --oltp-test-mode=complex…
cenk
  • 163
  • 1
  • 1
  • 5
1
2 3
…
22 23