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
31
votes
7 answers

mysql process cannot be stopped

I have recently installed 5.5.28-29.2 Percona Server (GPL), Release 29.2 in a Ubuntu 12.04 OS Desktop. I have tried to stop the server using different methods: - sudo /etc/init.d/mysql stop - sudo kill -9 pid - mysqladmin -u root -p shutdown All…
ljmelgui
  • 970
  • 1
  • 11
  • 24
23
votes
4 answers

Should I migrate from MySQL to Percona server

I have been experiencing dirty pages flushing problem in MySQL server. This occupies lot of CPU resources and my site becomes down because of lack of resources left in server. I got 10 Million records in database and it will grow further. My tables…
devuser29
  • 233
  • 1
  • 2
  • 4
19
votes
3 answers

Where is Percona's my.cnf file?

I cannot find where the setting files my.cnf or my.ini are. I want to change some aspecte of the configuration. I'm using Centos 6.
Hafizan Aziz
  • 269
  • 1
  • 3
  • 13
17
votes
5 answers

Installing Percona/MySQL unattended on Ubuntu

I can install MYSQL on Ubuntu without prompts with the code below: dbpass="mydbpassword" export DEBIAN_FRONTEND=noninteractive echo mysql-server-5.1 mysql-server/root_password password $dbpass | debconf-set-selections echo mysql-server-5.1…
ObiHill
  • 11,448
  • 20
  • 86
  • 135
17
votes
2 answers

Whats the use of SELECT .. FOR UPDATE when using Repeatable Read isolation?

When using Repeatable Read isolation, you are guaranteed that the rows you read using SELECT wont be modified until your transaction completes. This seems to be similar to what SELECT .. FOR UPDATE offers. So what is the point of using SELECT FOR…
pdeva
  • 43,605
  • 46
  • 133
  • 171
15
votes
3 answers

MySQL Fatal error: Can't open and lock privilege tables: Incorrect file format 'user'

MySQL (Percona 5.6) will not start. This error has happened to me several times. Each time, I have had to remove MySQL data directories and reinstall MySQL. Is there another way to fix MySQL? (Specifically one in which the data not blown…
Paul Draper
  • 78,542
  • 46
  • 206
  • 285
13
votes
2 answers

determine if mysql or percona or mariaDB

How can i tell if a server I'm connecting to is Percona or MySQL or MariaDB? Is there any standard way of doing this? I'm currently using SHOW VERSION to test the server version, but I would also need to display the server name in the app I'm…
Quamis
  • 10,924
  • 12
  • 50
  • 66
13
votes
2 answers

How do I do a `CREATE INDEX` with Percona's `pt-online-schema-change` tool?

How do I do a CREATE INDEX with Percona's pt-online-schema-change tool? I want to do something like: CREATE UNIQUE INDEX idx_name ON table_name (col_1, col_2, ...) USING BTREE According to the documentation, I must use the --alter argument and…
einnocent
  • 3,567
  • 4
  • 32
  • 42
12
votes
2 answers

Different explain plan in same cluster

I have a problem with this query: SELECT uca.user_activity_id, uca.user_call_id, uca.call_activity_id, uca.user_activity_token, uc.call_group_id, uc.user_id FROM users_calls_activities uca INNER JOIN users_calls_activities…
Sal00m
  • 2,938
  • 3
  • 22
  • 33
12
votes
1 answer

query_cache_type: enable or disable?

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
  • 633
  • 1
  • 5
  • 20
11
votes
2 answers

COMMIT OR conn.setAutoCommit(true)

I have noticed some programmer using COMMIT other using conn.setAutoCommit(true); to end the transaction or roll back so what are the benefits of using one instead of the other? Where is the main…
Motasem
  • 599
  • 1
  • 6
  • 13
11
votes
2 answers

Start Transaction OR Begin Work

I don't know what is better to use Start Transaction OR Begin Work, and what is the difference.
Motasem
  • 599
  • 1
  • 6
  • 13
10
votes
3 answers

MySQL 5.6 deadlock for locking the same rows twice?

I am seeing a deadlock with MySQL 5.6 because of what seems like trying to lock the same row/s twice. From the snippet below, rows where id = (11, 12, 13, 14, 15) already have a lock. And when another transaction tried to acquire a lock on these,…
Shri Javadekar
  • 258
  • 3
  • 11
10
votes
1 answer

Query is cached on local setup, but never on server?

I am having a lot of troubles with the query cache on a project: I am running a Percona flavor of MySQL, same versions both on my local development machine as on the production server. Now, enabling the query cache gives me excellent results on my…
Steven Rombauts
  • 333
  • 1
  • 8
9
votes
1 answer

Find Foreign Key Constraint Column Information Between Tables

Table A has a foreign key constraint (type) to Table B (id). However, type is not null and id is nullable. I'm trying to build a query using information_schema that will look at foreign key constraints and match up the column types and nullable…
JimRomeFan
  • 407
  • 6
  • 19
1
2 3
…
43 44