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 sa...

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 ano...

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 wan...

I don't know what is better to use Start Transaction OR Begin Work, and what is the difference.

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....

I'm trying to run percona xtradb cluster. The output from the percona server is as followings: mysqld: [Warning] World-writable config file '/etc/mysql/my.cnf' is ignored. 2019-06-10T07:24:28.0008...

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 UPDAT...

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: '...

I am trying to take backup from a remote machine using innobackupex. ./innobackupex --host=<mysql_server> --user=<username> <backup_dir>. Its failing as it is unable to locate ...

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? (Sp...

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 ...

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 | d...

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...

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 "201...

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 constr...

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...

ALTER TABLE in MySql allows ALGORITHM=INPLACE for avoiding table copy during altering. But for default they use copy instead of inplace. Why? Does default value used for backward compatibility or t...

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 ...

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 n...

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...

I though it is a silly question but after searching all over internet could not find an answer. So how do I check if I have Percona or original MySQL installed on the server?

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 Localho...

I have been trying to create a percona role in ansible and failing at it. I won't really say failing but it doesn't work as planned. Below is a snippet of the role - name: Setting up percona ser...

I've got an app which deals with a lot of data in other languages (webpage titles and meta descriptions). I recently switched from MySQL to Percona and have found all the errors which MySQL seemed ...

Problem Summary: While trying to convert a site with mysql database from latin1 to utf8, some special characters are not displaying correctly despite ensuring charsets are all utf8 system wide. ...