Questions tagged [percona-server]
Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.
122
questions
27
votes
3
answers
62k
views
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 ...
- 749
25
votes
4
answers
59k
views
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 ...
- 3,934
24
votes
2
answers
23k
views
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 ...
- 510
11
votes
1
answer
10k
views
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 ...
- 339
8
votes
1
answer
11k
views
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 ...
- 1,989
7
votes
1
answer
8k
views
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 ...
- 123
6
votes
2
answers
29k
views
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 ...
- 249
6
votes
4
answers
2k
views
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) ...
- 193
6
votes
1
answer
2k
views
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 ...
6
votes
2
answers
5k
views
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 ...
- 508
5
votes
3
answers
8k
views
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 ...
- 271
5
votes
1
answer
1k
views
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 ...
- 153
4
votes
2
answers
7k
views
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-...
- 61
4
votes
1
answer
7k
views
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 ...
- 45
4
votes
1
answer
3k
views
How to clear gcache pages in Percona PXC
I have a 4 node cluster(percona PXC) and one of the nodes have more than 150 gcache disk files each of size ~128 MB. I would like to purge or flush them so that the server user fresh gcache disk file.
...
- 794
4
votes
1
answer
4k
views
Is it mandatory to enable --log_slave_updates with MySQL Replication using GTID? [duplicate]
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 ...
- 1,511
4
votes
1
answer
963
views
Is the innodb_lazy_drop_table problem solved?
I'm researching database configuration for MySQL/MariaDB. I've been reading the configuration chapter in "High Performance MySQL". In there, it suggests that innodb_lazy_drop_table can be used to ...
- 143
4
votes
1
answer
5k
views
InnoDB temporary table location
I have a busy InnoDB table that expands and contracts regularly in size on a daily basis based on it's load. Typically, we'd see the table grow to 80GB in size (50/50 data and indexes) and then shrink ...
- 143
3
votes
3
answers
1k
views
MySQL can take more than an hour to start
I have a mysql (Percona) 5.7 instance with over 1Million tables. When I start the database, it can take more than an hour to start. Errorlog doesn't show anything, but when I trace mysqld_safe, I ...
- 161
3
votes
1
answer
9k
views
Very poor insert performance MySQL / Percona Server
I'm running a Percona-Server instance off an Ubuntu server install. I'm using an application that needs to access this database, and its having VERY poor performance. Once the database has been ...
- 33
3
votes
1
answer
1k
views
mysql_upgrade check if it's neccessary to run it
How can I determine, do I need to run 'mysql_upgrade` command on database?
Percona-server-5.6.41 is installed and running now for a several monthes. Before it mysql-5.6 was installed. In-place ...
- 113
3
votes
1
answer
114
views
Super slow (day long) count(*) after upgrade to 5.6
After upgrading to Percona 5.6.20 from 5.5.34 I noticed counts on larger tables take a massively long time to execute.
The table is about 27G and 300M rows. It is not compressed and was innodb ...
- 5,203
3
votes
1
answer
3k
views
MySQL: mysqld_safe options
Is there a way to specify these options in configuration file?
I've tried to add them into [mysqld_safe] section but it doesn't work:
[mysqld_safe]
numa-interleave = 1
flush-caches = 1
-
# ps -ww -...
- 459
3
votes
1
answer
376
views
MySQL Replication not proceeding
I have a weird replication problem I have not seen before. It's basic mysql replication with single master and two slaves. One of the slaves is not executing replication events and seems just stuck ...
- 5,203
3
votes
2
answers
5k
views
What are the causes of InnoDB Index Corruption?
I'm running into issues where many of my database servers are experiencing repeat index corruption. The index corruption across several physical hosts, and many different tables. Whenever I restore a ...
- 131
3
votes
1
answer
8k
views
MySQL - Persistent values in my.cnf
I have a small doubt regarding making variables persistent in Percona Server 5.6 in Linux.
I need to make log-bin-trust-function-creators persistent so that I need not make it to true everytime on ...
- 1,836
3
votes
1
answer
4k
views
MySQL Handler_read_rnd_next == tablescans without indexes?
I am in the process of tuning our Percona 5.5 server, and have been using percona's tools to plot our database's performance.
In the MySQL Handlers Plot, i have been noticing alot of "...
- 300
3
votes
0
answers
156
views
SSL for security - Percona MySQL
I have been told to implement SSL in my Master-Master MySQL instances by my security team to have secure traffic only to be received at the database end. I have never implemented SSL in a database ...
- 1,836
2
votes
2
answers
1k
views
Percona 5.7 tokudb poor query performance - wrong (non-clustered) index chosen
I have a table with about 8.5m rows in it. The table is tokudb and it has the indexes described below. I'm experiencing dismal performance when trying to run update statements like the following:
...
- 251
2
votes
2
answers
438
views
Is there any reason not to use Percona 'innodb_fast_checksum'?
I recently came across a change that Percona Server implemented over normal MySQL InnoDB. The new feature is innodb_fast_checksum
XtraDB can use a more CPU-efficient algorithm, based on 4-byte ...
- 23.3k
2
votes
2
answers
2k
views
Is it necessary to run apply-log immediately after innobackupexec has run?
i have been trying to read other questions, but i did not find a answer to suit me. So excuse me if i ask something that has been already asked.
I'm trying to organize my self and backup all my mysql ...
- 121
2
votes
1
answer
1k
views
Optimize Percona MySQL InnoDB 3.2TB database
(Before you will call me an idiot or start laughing, please remember it's a real deal on my side and I cannot cancel this assignment as it is a part of a bigger project)
I have a database server that ...
- 23
2
votes
2
answers
2k
views
any documentation on tpcc-mysql benchmark tool
Where can I find tpcc-mysql documentation? I google it but I can't find any documentation about it.
- 663
2
votes
1
answer
2k
views
Unknown storage engine 'XtraDB'
I installed Percona Server 5.6.12-rc60.4, when I want create table such as :
CREATE TABLE IF NOT EXISTS `mydb`.`table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 64 ) NOT NULL ,
PRIMARY ...
- 663
2
votes
1
answer
1k
views
What is the Best way to set Disaster recovery setup for percona Xtra DB Cluster?
We do have a Percona XtraDB Cluster(Master-Master-Master) setup in one country. Now we want to setup a disaster recovery setup in some other country. Please provide us the best possible ways to do ...
2
votes
1
answer
889
views
Strange Locking issues while playing back logs via percona playback
Problem while replaying logs
I am in the process of benchmarking a new DB node (specs at the end) and have run across some strange behavior:
As described here i:
Created a dump (innobackupex ftw)
I ...
- 300
2
votes
1
answer
728
views
How often should MySQL (stock, Percona, etc.) be upgraded?
My organization runs several data-driven web applications backed by various flavors of MySQL on RHEL (i.e. we're just like everyone else!) Some of our web apps use the standard build of MySQL, and we ...
- 292
2
votes
2
answers
3k
views
Slow INSERTs to MEMORY table
I've been trying to work this issue out, been really killing me! We've been experiencing some slow database queries for a Prestashop installation that we host, and a look into the query log revealed ...
- 21
2
votes
1
answer
2k
views
Missing mysql, sys, performance_schema
I have Percona Mysql 8.0.19-10 on debian 10.
A year ago I had some issues restoring a backup that required me to mess with tablespaces. I forget what all I had done but eventually I got the database ...
- 163
2
votes
2
answers
152
views
Percona XtraDB Cluster - do I add arbiter IP in gcomm://?
I'm configuring Percona XtraDB Cluster 8 on two nodes, and use a 3rd node to act as an arbiter.
I cannot make up out of the docs whether to add the IP of the arbiter in the galera nodes addresses of ...
- 113
2
votes
1
answer
3k
views
slow writes on percona / mariadb server only when replication is running
Hi I am trying to migrate to percona server from mysql 5.6 on windows.
In my development machine for percona is running of centos 6.5 which is installed on vmware 5.5 sphere.
Our business ...
- 21
2
votes
1
answer
801
views
How big can innodb_doublewrite_file grow?
When I use the enable innodb_doublewrite_file ...
How big can this file grow ?
How can I calculate the optimal disk size, if it would be used only for this file?
2
votes
1
answer
3k
views
Queries getting stuck on very simple COUNT queries
process list:
| 16004 | metrics | xxx:64616 | metrics | Query | 29064 | Sending data | SELECT COUNT(*) FROM Plugin where LastUpdated >= '1356856200' | ...
- 21
2
votes
1
answer
516
views
Assertion failure from InnoDB while restoring using Innobackupex
I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes:
We recently upgraded our production DBs ...
- 300
2
votes
1
answer
273
views
Percona Server 5.6.40 restarting with singal 11
We recently migrated our mysql to new hardware and it was running in slave mode for 15 days. We made it the master 11th June. On 13th June it restarted for the first time with signal 11.
Stacktrace ...
2
votes
1
answer
249
views
Replicating into a Percona XtraDB Cluster
We have a 2 node (plus an arbiter) Percona XtraDB cluster. It is used for data indexing/archiving. It has it's own database called archive but it is also the replication slave for a database called ...
- 141
2
votes
2
answers
4k
views
Percona xtradb cluster node2 won't start
I have configured Percona Xtradb cluster 5.6. The first node starts fine when bootstrapped, but the second node seems to have an issue with this variable setting:
wsrep_provider=/usr/lib/...
- 333
1
vote
1
answer
815
views
Percona and MariaDB-10.0 ignoring not null on table fields
On the percona-5.6 and MariaDB-10.0 servers, the NOT NULL declared on table field are being ignored. I am able to leave fields declared as NOT NULL empty when inserting data and the servers are not ...
- 333
1
vote
2
answers
3k
views
Mysqldump failing while restoring database - MySQL 5.6
I have dumped one of my databases of size 5-6GB. I'm trying to restore to another instance but the same is getting failed after sometime with the following error:
ERROR 2013 (HY000) at line 12006: ...
- 1,836
1
vote
2
answers
2k
views
Baffled with MySQL LEFT JOIN query that I have to speed it up
I am kind of a puzzled with this query trying to optimize it but no way I am able to (due to my limited knowledge as a DBA). So, I asked the experts.
In my setup I have three (primary) tables. ...
- 205